Re: Correct pg_dumpall Syntax - Mailing list pgsql-general

From Sam Mason
Subject Re: Correct pg_dumpall Syntax
Date
Msg-id 20080618174915.GL2572@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Re: Correct pg_dumpall Syntax  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On Wed, Jun 18, 2008 at 10:42:51AM -0700, Rich Shepard wrote:
> [rshepard@salmo /usr4/postgres-backups]$ pg_restore -U postgres < pg814data.sql
> pg_restore: [archiver] input file does not appear to be a valid archive
>
>   But it was created using the 8.3.3 pg_dumpall in /usr/bin/.

pgdumpall (and pgdump by default) will produce output in SQL format.
Restoring is just a simple matter of:

  psql dbname -f pg814data.sql

Hope that helps!


  Sam

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Correct pg_dumpall Syntax
Next
From: Rich Shepard
Date:
Subject: Re: Correct pg_dumpall Syntax