Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #175287 > unrolled thread

Debian Jessie Postgres 9.4 connection problem

Back to article view | Back to linux.debian.user

Contents

  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

#175287 — Debian Jessie Postgres 9.4 connection problem

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

[toc] | [next] | [standalone]

#175295

[Multipart message — attachments visible in raw view] — view raw

Try pg_lsclusters to see which postgresql servers are running and listening
on which ports.

Regards
Johann



-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

[toc] | [prev] | [standalone]

Back to top | Article view | linux.debian.user

csiph-web