Re: Correct pg_dumpall Syntax - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Correct pg_dumpall Syntax
Date
Msg-id 20080618150416.GH433@commandprompt.com
Whole thread Raw
In response to Correct pg_dumpall Syntax  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Correct pg_dumpall Syntax  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On Wed, Jun 18, 2008 at 07:16:11AM -0700, Rich Shepard wrote:
> pg_dumpall from 8.3.3 to extract all data from the 8.1.4 version residing in
> /usr4/pgsql_old/data/ and write it to a file (with the -f option) in
> /usr4/postgres-backups.

Can't do it.  Start the old postmaster with -D /usr4/pgsql_old/data,
and then use pg_dumpall against that backend.

A

--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Need Help Recovering from Botched Upgrade Attempt
Next
From: Craig Ringer
Date:
Subject: Re: Need Help Recovering from Botched Upgrade Attempt