Debian Jessie Postgres 9.4 connection problem

From	Ramon Hofer <ramonhofer@bluewin.ch>
Newsgroups	linux.debian.user
Subject	Debian Jessie Postgres 9.4 connection problem
Date	2016-12-01 00:20 +0100
Message-ID	<sJmkp-4c1-5@gated-at.bofh.it> (permalink)
Organization	linux.* mail to news gateway

Show all headers | View raw

Hi all

I am trying to setup a postgresql 9.4 database on Debian Jessie. It
worked well on testing with postgresql 9.6 from the repos and then I
already could connect with
$ sudo -u postgres psql

I would like to use Jessie but when I try the same on stable with
postgresql 9.4, this is what I get when I try to connect to the
database:

$ sudo -u postgres psql
psql: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?

The service is started:

$ sudo service postgresql status
● postgresql.service - PostgreSQL RDBMS
   Loaded: loaded (/lib/systemd/system/postgresql.service; enabled)
   Active: active (exited) since Thu 2016-12-01 00:03:34 CET; 7min ago
 Main PID: 24644 (code=exited, status=0/SUCCESS)

Dec 01 00:03:34 sru-ac-data systemd[1]: Started PostgreSQL RDBMS.
Dec 01 00:03:34 sru-ac-data systemd[1]: Started PostgreSQL RDBMS.


Do you know of any problems?
And what I could do to make it work?


Thanks for your answer!


Best regards,
Ramon

Back to linux.debian.user | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Debian Jessie Postgres 9.4 connection problem Ramon Hofer <ramonhofer@bluewin.ch> - 2016-12-01 00:20 +0100
  Re: Debian Jessie Postgres 9.4 connection problem Johann Spies <johann.spies@gmail.com> - 2016-12-01 07:40 +0100

csiph-web