yum packages for 9.5 vs <=9.4 - Mailing list pgsql-general

From John R Pierce
Subject yum packages for 9.5 vs <=9.4
Date
Msg-id 56A11ED5.2080006@hogranch.com
Whole thread Raw
Responses Re: yum packages for 9.5 vs <=9.4  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: yum packages for 9.5 vs <=9.4  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: yum packages for 9.5 vs <=9.4  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List pgsql-general
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



--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: Yury Zhuravlev
Date:
Subject: Re: Building PostgreSQL 9.6devel sources with MicrosoftVisual C++ 2015?
Next
From: Adrian Klaver
Date:
Subject: Re: yum packages for 9.5 vs <=9.4