On 01/21/2016 10:09 AM, John R Pierce wrote:
the yum packages for 9.5 apparently changed the path of the socket from
/tmp to /var/run/postgresql
I have several versions installed on the same dev system running on
different ports.... for 9.1 through 9.4 this was no problem, but since
I installed 9.5, I now have to specify -h /tmp -p XXXX to connect to an
earlier version, this has raised havoc with my scripts and stuff, for
instance this script invoked from crontab no longer works on the earlier
versions...
#!/bin/bash
## postgres backup script
DD=$(date +%a)
PP=/backups/pgsql/svfis-kvm3
for p in 5432 5433 5434 5435; do
pg_dumpall -p $p -g -f $PP/pg_dumpall.$p.globals-$DD.sql
for db in $(psql -p $p -tc "select datname from pg_database where
not datistemplate"); do
pg_dump -Fc -p $p --schema-only -f $PP/pgdump.$p.$db.$DD.dump -d
$db
done
done
I have not actually done it but from here:
http://www.postgresql.org/docs/9.5/interactive/runtime-config-connection.html
unix_socket_directories (string)
Specifies the directory of the Unix-domain socket(s) on which the
server is to listen for connections from client applications. Multiple
sockets can be created by listing multiple directories separated by
commas. Whitespace between entries is ignored; surround a directory name
with double quotes if you need to include whitespace or commas in the
name. An empty value specifies not listening on any Unix-domain sockets,
in which case only TCP/IP sockets can be used to connect to the server.
The default value is normally /tmp, but that can be changed at build
time. This parameter can only be set at server start.
In addition to the socket file itself, which is named .s.PGSQL.nnnn
where nnnn is the server's port number, an ordinary file named
.s.PGSQL.nnnn.lock will be created in each of the
unix_socket_directories directories. Neither file should ever be removed
manually.
This parameter is irrelevant on Windows, which does not have
Unix-domain sockets.
Seems it would be possible to change the above to point at both /tmp and
/var/run/postgresql and keep everybody happy.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
