Re: Correct pg_dumpall Syntax

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Correct pg_dumpall Syntax
Date: 2008-06-18 17:47:52
Message-ID: 20080618174752.GC850@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 18, 2008 at 10:42:51AM -0700, Rich Shepard wrote:
> [rshepard(at)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/.

Did you use a non-ascii dump format? Try

psql -U postgres -f pg814data.sql

A

--
Andrew Sullivan
ajs(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2008-06-18 17:49:15 Re: Correct pg_dumpall Syntax
Previous Message Rich Shepard 2008-06-18 17:42:51 Re: Correct pg_dumpall Syntax