Re: Upgrading using pg_dumpall

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrading using pg_dumpall
Date: 2016-09-03 23:01:43
Message-ID: alpine.LNX.2.11.1609031553370.21165@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-09-03 23:11:45 Re: Upgrading using pg_dumpall
Previous Message Adrian Klaver 2016-09-03 22:54:51 Re: Upgrading using pg_dumpall