Re: Correct pg_dumpall Syntax - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Correct pg_dumpall Syntax
Date
Msg-id 485919A1.3040805@iol.ie
Whole thread Raw
In response to Correct pg_dumpall Syntax  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On 18/06/2008 15:16, Rich Shepard wrote:

>   I do not see an option on the man page for pg_dumpall that directs it to
> the data of a different version on a different filesystem. I would greatly
> appreciate learning the correct syntax that will allow me to use the
> 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.
>
>   There are no postmaster or postgres processes running.

As I understand it, pg_dump (and therefore pg_dumpall also) needs a
server process running: you direct it to the correct host with the -h
option.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Correct pg_dumpall Syntax
Next
From: "A. Kretschmer"
Date:
Subject: Re: Correct pg_dumpall Syntax