On Sat, 3 Sep 2016, Adrian Klaver wrote:
Once you verify that the new instance is running and you can connect to it
then:
Shut down 9.3.4 using pg_ctl stop as user postgres. Started 9.5.4 as user
postgres using 'pg_ctl start /var/lib/pgsql/9.5/data &'.
psql -U some_user -d postgres -p 5442 -f your_dumpall.sql
In /tmp there's only
.s.PGSQL.5432=
.s.PGSQL.5432.lock
and since only 9.5.4 is now running that port should be available.
The above command failed when run as both me (as user owning/granted all
privileges on all databases) and as superuser postgres.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
