Unable to connect to Postgresql

From: John Iliffe <john(dot)iliffe(at)iliffe(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Unable to connect to Postgresql
Date: 2017-04-07 21:38:22
Message-ID: 201704071738.22937.john.iliffe@iliffe.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When I attempt to run any web application php cannot open a database
because of failure to connect. (Please disregard the programme name, it is
running in mod_php, not as an fcgi module). The (php) message is:

--------------------------
[Fri Apr 07 17:03:28.597101 2017] [php7:warn] [pid 1797:tid
140599445419776] [client 192.168.1.10:45127] PHP Warning: pg_connect():
Unable to connect to PostgreSQL server: could not connect to server: No
such file or directory\n\tIs the server running locally and
accepting\n\tconnections on Unix domain socket
&quot;/tmp/.s.PGSQL.5432&quot;? in /httpd/iliffe/testfcgi.php on line 121
----------------------------

The proper socket does exist:

-------------------------------------
ls -al /tmp | grep PGSQL
srwxrwxrwx. 1 postgres postgres 0 Apr 7 16:53 .s.PGSQL.5432
-rw-------. 1 postgres postgres 49 Apr 7 16:53 .s.PGSQL.5432.lock

ss -a | grep 5432
u_str LISTEN 0 128 /tmp/.s.PGSQL.5432 30480 * 0
-------------------------------------

Running on Fedora 25 with SELinux in PERMISSIVE mode. The audit log shows
no hits on Postgresql.

Postgresql version number is 9.6.2

As expected, the postgresql log shows nothing since the last start up.

Thanks in advance.

John
=====================================

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-04-07 22:51:33 Re: Unable to connect to Postgresql
Previous Message David G. Johnston 2017-04-07 20:40:56 Re: SELECT and RowExclusiveLock