| From: | Strahinja Kustudić <strahinjak(at)nordeus(dot)com> |
|---|---|
| To: | pgsql-pkg-yum <pgsql-pkg-yum(at)postgresql(dot)org> |
| Subject: | Postgres 9.4 and 9.5 on CentOS on same machine unix socket incompatibility |
| Date: | 2016-03-15 11:20:02 |
| Message-ID: | CADKbJJUB=VX8TKkRDoAXkRrdBT4aE9crxHH46pNUcTJ0muy0yg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-pkg-yum |
I had Postgres 9.4 installed on CentOS 5 which is listening on default port
5432 and everything worked fine when I wanted to connect using the unix
socket. Then I installed Postgres 9.5 (just installed it) and now psql
wants to connect to a different unix socket path:
/usr/pgsql-9.4/bin/psql -U postgres
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 thing is that 9.4 doesn't create a unix socket in that directory, it
only creates it in /tmp. I think the problem is with all older versions,
not just 9.4.
How does 9.5 tell all other psql versions where to search for the unix
socket?
Strahinja Kustudić | Lead System Engineer | Nordeus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim GÜNDÜZ | 2016-03-15 12:02:36 | Re: pgfincore94 fails check-files on EL-7 |
| Previous Message | Bernd Helmle | 2016-03-11 12:01:54 | Re: systemd service files vs. postgresql9x-setup |