pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg_restore: [archiver] input file does not appear to be a valid archive 2+ messages / 2 participants [nested] [flat]
* pg_restore: [archiver] input file does not appear to be a valid archive @ 2004-09-15 13:04 ogjunk-pgjedan@yahoo.com 2004-09-15 14:22 ` Re: pg_restore: [archiver] input file does not appear to be a valid archive Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: ogjunk-pgjedan@yahoo.com @ 2004-09-15 13:04 UTC (permalink / raw) To: pgsql-admin Hello, I'm having trouble with pg_dump and pg_restore (PG 7.3.4). 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 # gzip -9 dbdump + scp it to a remote machine where I want to restore this dump in a different DB (same DB user, also on localhost, also PG 7.3.4, but different DB name) # gunzip dbdump.gz # pg_restore -a -d myOtherDbName dbdump But restore fails with this error: pg_restore: [archiver] input file does not appear to be a valid archive I checked the man pages for both commands, but didn't see anything that would make me think that I'm doing something wrong, but I must be.... Thanks, Otis ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_restore: [archiver] input file does not appear to be a valid archive 2004-09-15 13:04 pg_restore: [archiver] input file does not appear to be a valid archive ogjunk-pgjedan@yahoo.com @ 2004-09-15 14:22 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2004-09-15 14:22 UTC (permalink / raw) To: ogjunk-pgjedan@yahoo.com; +Cc: pgsql-admin <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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-09-15 14:22 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-09-15 13:04 pg_restore: [archiver] input file does not appear to be a valid archive ogjunk-pgjedan@yahoo.com 2004-09-15 14:22 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox