Re: Unable to connect to Postgresql

Hi Adrian:

Not the same problem.

Last time I couldn't get postgresql running at all. This time it is
running and I can't connect to it. I did check for something else holding
the socket, but as far as I can see nothing else has it.

Regards,

John
===================================
On Friday 07 April 2017 18:51:33 Adrian Klaver wrote:
> On 04/07/2017 02:38 PM, John Iliffe wrote:
> > 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
> > "/tmp/.s.PGSQL.5432"? 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.
>
> Well the last time this happened the answer was this:
>
> https://www.postgresql.org/message-id/25543.1489081789%40sss.pgh.pa.us
>
> > Thanks in advance.
> >
> > John
> > =====================================