Re: yum packages for 9.5 vs <=9.4

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
>
>

Curiosity got the better of me, so now I have tried it:

unix_socket_directories = '/tmp, /var/run/postgresql'


aklaver@panda:~> /usr/local/pgsql95/bin/psql -d postgres -p 5462 -h /tmp
-U postgres
psql (9.5.0)
Type "help" for help.

postgres=# \q
aklaver@panda:~> /usr/local/pgsql95/bin/psql -d postgres -p 5462 -h
/var/run/postgresql -U postgres
psql (9.5.0)
Type "help" for help.

postgres=#



--
Adrian Klaver
adrian.klaver@aklaver.com