Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore: [archiver] input file does not appear to be a valid archive - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_restore: [archiver] input file does not appear to be a valid archive
Date
Msg-id 3379.1095258158@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore: [archiver] input file does not appear to be a valid archive  (<ogjunk-pgjedan@yahoo.com>)
List pgsql-admin
Tree view 
<ogjunk-pgjedan@yahoo.com> writes:
> This is how I'm dumping my DB:

> # pg_dump -d mydb --clean --inserts --column-inserts --format=P -v -h
> localhost -p 5432 -U otis > dbdump

> # pg_restore -a -d myOtherDbName dbdump
> pg_restore: [archiver] input file does not appear to be a valid archive

Plain dump format is a script to feed to psql.  pg_restore is only for
the other two formats.

            regards, tom lane

pgsql-admin by date:

Previous
From:
Date:
Subject: pg_restore: [archiver] input file does not appear to be a valid archive
Next
From: Gaetano Mendola
Date:
Subject: Re: VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat 7.3