Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [postgresql]

PostgreSQL is a powerful, open source object-relational database system.

0
votes
0answers
12 views

ubuntu 18.04.1 LTS postgres systemd service

I am installing Postgres 11 on Ubuntu 18.04. When you do a non-default install: First install postgresql-common. Adapt the config file to NOT create main cluster , start_conf= 'auto' and ...
0
votes
0answers
14 views

Use PostgreSQL and pgAdmin on desktop?

I am looking a way to easily install / configure PostgreSQL and pgAdmin in the last LTS release of Ubuntu. I was trying for days but I cannot do it work. Thanks for use a bit of your time helping me :...
0
votes
1answer
32 views

Ubuntu 16.04. LTS unable to locate package postgresql-11

I am running into this issue where I am trying to install postgresql-ll and I followed the instructions given at https://wiki.postgresql.org/wiki/Apt. I have also read previous posts related to this ...
1
vote
1answer
42 views

Why is there no pgpool-II in 18.04 LTS?

Is there a reason why 18.04 has no pgpool-II package available? packages.ubuntu.com lists 14.04 LTS, 16.04 LTS, and 18.10 but is missing 18.04 LTS. I did not find a suitable answer to that via popular ...
-1
votes
2answers
111 views

Simple text editor for Ubuntu that has proper syntax highlighting for PostgreSQL

Is there a simple, small, fast text editor (like Gedit) for Ubuntu that has very good syntax highlighting for PostgreSQL? Don't suggest something you haven't used. I tested Gedit, Atom, and pgAdmin 4 ...
0
votes
1answer
58 views

While trying to upgrade postgresql postgresql-10 I get libpq5 : Depends: libssl1.0.0 (>= 1.0.2~beta3) but 1.0.1f-1ubuntu2.26 is to be installed

I've been trying to upgrade postgresql in my Ubuntu machine from 9.3 to 10. When I try sudo apt-get install postgresql-10 I get The following packages have unmet dependencies: postgresql-10 : ...
0
votes
1answer
181 views

could not connect to server: No such file or directory in PostgreSQL

I have a VPS with Ubuntu 14.04.5 LTS (GNU/Linux 2.6.32-042stab127.2 x86_64) and also have Postgresql installed. I'm using Postgresql in a ruby on rails application. Suddenly my application stopped ...
1
vote
3answers
167 views

Install Postgresql 9.4 on Ubuntu 18.04

Im trying to install postgresql 9.4 (because of BDR support) on Ubuntu 18.04, and following this building tutorial. but when im install some dependencies for postgres, its error root@ubuntu:/home/...
1
vote
1answer
68 views

Change PostgreSQL PGDATA variable with systemctl

I want to change the postgres' data directory to /home/postgres/data editing th postgresql.service instead of change the file /etc/postgresql/10/main/postgresql.conf. So, I edited the service with ...
0
votes
0answers
97 views

Connect to postgresql using php pdo - not working

I have Ubuntu 18.04, apache2, PHP 7.2.10-0ubuntu0.18.04.1, and PostgreSQL 10.5 (Ubuntu 10.5-0ubuntu0.18.04) running on localhost:5432. I am trying to make a PDO connection to a database. But it's not ...
0
votes
2answers
31 views

How to remove first X lines from file up to the first occurrence of particular string?

I have many PostgreSQL dump files such this and because I import these files automatically into another database server (H2) and SET command is not compatible with this database, I need to remove all ...
0
votes
0answers
22 views

pg_dump: role missing, how to add a “backup” role?

I am writing a backup script for my confluence database and data. I followed the advice in 1079213 and created the user backup-user. Access to my filesystem is ok. But I can't do the database dump. ...
0
votes
0answers
17 views

Ubuntu PostgreSQL on a raspberry pi

I am trying to setup a postgres database on my raspberry pi running Ubuntu. Everything works like connecting via PgAdmin to it. How can I access the database from outside my network?
0
votes
0answers
17 views

PhpPGAdmin stopped working after upgrade to 18.04

I've recently upgrade my development PC from Ubuntu16.04 to 18.04 and although Postgres continues to run, I get the following in my browser when trying to access phppgadmin printHeader('', null, true)...
0
votes
0answers
15 views

Error in Dockerfile while building postgresql10, What base image should I use?

ENV PG_MAJOR 10 ENV PG_VERSION 10.1-1.pgdg80+1 RUN echo 'deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main' $PG_MAJOR > /etc/apt/sources.list.d/pgdg.list RUN apt-get update \ &...
0
votes
0answers
419 views

Unable to Install PostgreSQL Unmet Dependencies [duplicate]

I'm trying to install PostgreSQL. First I successfully installed it using apt install postgresql, which currently installs version 9.5 by default. But I want to use a newer version. Here's what I've ...
0
votes
1answer
241 views

Bash Script that check if a database exist

I'm trying to create a bash script that check if a database(PostgreSQL) exists: function is_database() return $(sudo -u postgres psql -c "SELECT exists(SELECT datname FROM pg_catalog.pg_database ...
0
votes
0answers
216 views

pgAdmin4 not working - How to solve not listening 5432 on postgresql after set config file correctly

I am a novice ubuntu user. I am working on an ubuntu 18.04 VM on Windows10 machine through Putty. I installed postgreql & I am trying to install pgadmin4 but it's not working. When I run the ...
0
votes
0answers
17 views

Unable to install postgresql in ubuntu 16.04 [duplicate]

I tried to install postgresql using this instruction: sudo apt-get install postgresql-9.5 postgresql-contrib-9.5 In the stdout I got this: Reading package lists... Done Building dependency tree ...
0
votes
0answers
77 views

Groups,User and PostgreSQL access rights

I have a web app that uses a PosgreSQL database. To use the database I use the following command: sudo -u postgres psql I think, this is very basic, so I'm looking for something like: not all ...
1
vote
0answers
37 views

Postgresql command line utility dosen't start on WSL

I'm using Windows subsystem for Linux with Ubuntu 18.04; I'm trying to use postgresql on my machine, I've taken care of the relevant installations. But when I enter the command: sudo -u postgres ...
1
vote
1answer
37 views

Trouble to run commands after changing user password with home directory encryption

I needed to change a server password, done that by passwd. Thing is, this Ubuntu Server installation uses the home encryption aparently. Once I changed the password, after some package update, the ...
1
vote
0answers
534 views

Installing postgresql-10 libgssapi-krb5-2 (>= 1.14+dfsg) but 1.13.2+dfsg-5ub [duplicate]

i'm trying to install postgresql-10 via the instructions listed here: https://www.postgresql.org/download/linux/ubuntu/ I'm trying to run this step and I keep getting the following unmet dependency ...
0
votes
0answers
26 views

Cannot sudo apt-get update and install postgresql? [duplicate]

I got an error when I tried to update sudo apt-get update as below: Err:1 http://apt.postgresql.org/pub/repos/apt xenial-pgdg InRelease Temporary failure resolving 'apt.postgresql.org' Err:2 http://...
2
votes
1answer
199 views

Using bash in combination with psql, passing variable between them

I'm writing a bash script where I use psql (Postgresql). DATABASE='scifi' sudo -u postgres psql count=SELECT COUNT(*) FROM (SELECT datname FROM pg_catalog.pg_database WHERE lower(datname)=lower($...
0
votes
0answers
21 views

Lampp Apache cant connect wih PostgreSql server

Basicly i want to Lampp's Apache web server as main webserver for 3 Databases type that i have mysql (bundling with Lampp default),PostgreSql-10 (fully installed and tested),MongoDb (not yet started ...
2
votes
1answer
240 views

issue with pgadmin installing in ubuntu18 server

I have ubuntu 18 server installed & i want to make it postgres sql server for my own practice, Installed postgres but unable to get pgadmin tool. Any suggestion guys?????? Tried many times using "...
3
votes
1answer
764 views

Error: could not determine PostgreSQL version from '10.4'

getting error while installing uniq Error message: Downloading https://engci-maven-master.cisco.com/artifactory/api/pypi/apic-em-pypi-group/packages/86/fd/...
2
votes
2answers
2k views

How to execute SQL statement from command line?

I'm a longtime GUI user trying to switch to command line, and I'm not sure how to execute an SQL statement from the Ubuntu command line. I'm using postgres. I can use \c to connect to the database ...
0
votes
1answer
265 views

Problems with Ubuntu 18.04, Python 3.6.5, psql 10.4 and pgAdmin 1.22.2

Code did run with: Lubuntu 16.10, Python 3.5.2 (python3), psql 9.5.7 and pgAdmin 1.22.1. .... Also installed: Python 2.7.12 (python) Code does not run with: Ubuntu 18.04, Python 3.6.5 (python and ...
2
votes
1answer
4k views

How to install PostgreSQL 9.5 in Ubuntu 18.04?

I want to install PostgreSQL 9.5. But the available version is 9.6. I only need 9.5 to build wal2json against it and test it (requirement because of AWS version).
1
vote
1answer
135 views

Unable to uninstall PostgreSQL 9.3 from Ubuntu 14.04 without installing PostgreSQL 10

I just upgraded my Postgres instance from 9.3 to 9.6, and everything worked perfectly until I tried to uninstall 9.3. Apt is trying to install Postgres 10 during the removal of 9.3. 9.6 needs to stay ...
0
votes
1answer
1k views

Postgresql server is not listening

I know this question has asked many times, but non of those answers worked for me. The problem is, when I run "psql", I get the message psql: could not connect to server: No such file or directory ...
0
votes
0answers
19 views

Connection problem with postgresql

Have a problem connecting postgresql with local server 01:45:01: Ошибка: Error connecting to the server: FATAL: password authentication failed for user "postgres" FATAL: password authentication ...
0
votes
1answer
89 views

What's the difference between psql -V and apt-cache policy postgresql?

I have installed postgres 9.6, If you type in terminal psql -V or psql --version, you know which postgresql version you have installed, however, if you type sudo apt-cache policy postgresql, it ...
3
votes
1answer
4k views

Unable to install postgreSQL 9.6 in Ubuntu 18.04

I'm trying to install postgreSQL 9.6 in Ubuntu 18.04 via Ubuntu Software Centre and type from terminal sudo apt-get install postgresql-9.6 according to official documentation https://www....
0
votes
0answers
28 views

How to install postgresSQL-10 from binaries on ubuntu 18

I downloaded tar file from postgres site here, and followed next step from this document here and facing this issue ./configure :command not found
0
votes
0answers
47 views

how to create a postgres on NFS? [duplicate]

I have mounted NFS on the local server, want to build a database on NFS, other servers can access through an account, the problem is that the database is created, can only be accessed on the local ...
0
votes
0answers
30 views

Postgres installation in ubuntu 14

Setting up postgresql-10 (10.4-2.pgdg14.04+1) ... * Starting PostgreSQL 10 database server * Error: /usr/lib/postgresql/10/bin/pg_ctl /usr/lib/postgresql/10/bin/...
5
votes
1answer
672 views

How to install psql without Postgres?

I need the psql command line tools, but I don't need the actual Postgres RDBMS. This is to work with a package which supports a psql interface. Is it possible to install just psql? (Ubuntu 16.04)
1
vote
0answers
24 views

AWS Instance with 30 GB RAM, still running out of Memory and High CPU usage with small app?

We are on 30 GB AWS instance running a Ruby on Rails app using Passenger + Apache. Though the App Postgres DB has millions of records, The DB size is few GB only. Now I am finding the server to ...
0
votes
1answer
205 views

Set PostgreSQL pager to less?

I'm trying to get my psql pager output to look nicer. I've added the following to my ~/.bashrc export PAGER='less -S' And I've added these line to my ~/.psqlrc \x auto \pset pager on \setenv ...
4
votes
0answers
5k views

Pgadmin 4 Not working in ubuntu 18.04 [closed]

I have installed postgres 10 and pgadmin4 in my Ubuntu 18.04 version. everything went fine. I cannot open the pgadmin gui. what might be the reason. it simply wont open. Does it require Qt? how do i ...
1
vote
0answers
669 views

password authentication failed for user “manager”

I have created a user manager in Ubuntu server 17. Then create a node js application behalf of this user. Then try to connect to the postgresql 10 through the following config using postgres user. ...
1
vote
0answers
813 views

How to stop postgresql to free the port 5432

I am trying to run this command to install wsgi for python Flask: sudo apt-get install libapache2-mod-wsgi-py3 I am getting this error: Reading package lists... Done Building dependency tree ...
0
votes
0answers
23 views

Should I remove files in /etc/rc*.d that correspond to software I no longer have installed and if I should then how to do so?

In the /etc/rc*.d directories I have files such as *01mongodb, *01postgresqland *01mysql, but I have neither of these DB softwares installed anymore. As I know these files tell the system what to do ...
1
vote
1answer
47 views

I was following a blog post to install postgresql and start getting this error while updating my OS

N: Ignoring file 'pgdg.listsudo' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension
1
vote
0answers
227 views

dpkg: unrecoverable fatal error, aborting

I'm trying to install Postgresql on this Droplet, and the installation can't go through. This is the error I'm getting. root@testplatform:/usr/bin# sudo apt-get install postgresql postgresql-contrib ...
0
votes
1answer
187 views

Can't remove postgresql in ubuntu 16.04

Im trying to remove entire postgresql on ubuntu $ sudo apt-get --purge remove postgresql* Now it is not working anymore and i got this message. Reading package lists... Done Building dependency ...
0
votes
1answer
837 views

How to install postgresl 9.6.8 or 10.3 to Ubuntu 17.10 Artful Aardvark?

There is this postgres security patch which was deployed at heroku and now I can't install postgres dumps from heroku to my local machine. Because this masterminds able to produce only archived dumps ...