Re: [GENERAL] psql connection issue

2014-10-10 Thread Stephen Davies
Yes but that would have involved changing hundreds of CGI scripts. Dropping the private tmp was easier. On 11/10/14 07:01, Jim Nasby wrote: FWIW, you could also use an IP connection to Postgres instead of the local socket. On 10/8/14, 6:34 PM, Stephen Davies wrote: This is not the same issue.

Re: [GENERAL] psql connection issue

2014-10-10 Thread Jim Nasby
FWIW, you could also use an IP connection to Postgres instead of the local socket. On 10/8/14, 6:34 PM, Stephen Davies wrote: This is not the same issue. However, I had already disabled SELinux for other reasons. The actual cause of my issue was the "new" private tmp facility in systemd start

Re: [GENERAL] psql connection issue

2014-10-08 Thread Stephen Davies
This is not the same issue. However, I had already disabled SELinux for other reasons. The actual cause of my issue was the "new" private tmp facility in systemd startup of httpd. This makes the PostgreSQL socket invisible to CGI scripts. We have survived for many years without this before mig

Re: [GENERAL] psql connection issue

2014-10-08 Thread Adrian Klaver
On 10/07/2014 09:10 PM, Stephen Davies wrote: The permissions on the socket are 777 owner/group postgres. I installed the 9.3 onto the Centos 7 server using the repo at postgresql.org. (http://yum.postgresql.org/9.3/redhat/rhel-$releasever-$basearch) There is no /var/run/postgresql and find ca

Re: [GENERAL] psql connection issue

2014-10-07 Thread Stephen Davies
The permissions on the socket are 777 owner/group postgres. I installed the 9.3 onto the Centos 7 server using the repo at postgresql.org. (http://yum.postgresql.org/9.3/redhat/rhel-$releasever-$basearch) There is no /var/run/postgresql and find cannot find another socket anywhere else. Cheer

Re: [GENERAL] psql connection issue

2014-10-07 Thread Ian Barwick
On 14/10/08 12:51, Stephen Davies wrote: > I am in the process of migrating a bunch of databases and associated CGI > scripts from > 9.1.4 to 9.3 (and from 32-bit to 64-bit). > > The database migration has been successful but I have an issue with psql > connections from CGI scripts. > > I can

Re: [GENERAL] psql connection issue

2014-10-07 Thread Tom Lane
Stephen Davies writes: > I am in the process of migrating a bunch of databases and associated CGI > scripts from 9.1.4 to 9.3 (and from 32-bit to 64-bit). > The database migration has been successful but I have an issue with psql > connections from CGI scripts. > I can connect to the 9.3 serve

[GENERAL] psql connection issue

2014-10-07 Thread Stephen Davies
I am in the process of migrating a bunch of databases and associated CGI scripts from 9.1.4 to 9.3 (and from 32-bit to 64-bit). The database migration has been successful but I have an issue with psql connections from CGI scripts. I can connect to the 9.3 server locally with psql from the com