From: Alexey Bobkov <bax@sunet.ru>
To: pgsql-admin@postgresql.org
Subject: pg_dump/pg_restore
Date: Mon, 12 Jan 2004 14:45:16 +0300
Message-ID: <400288CC.4050005@sunet.ru> (raw)
PostgreSQL 7.3.2
I have been dumping my database with next options:
pg_dump -f /path_to_database/backup/db_backup.file -Z 9 database_name
and get db_backup.file file.
Then a try to restore my data:
pg_restore /path_to_database/backup/db_backup.file
and get next error
pg_restore: [archiver] input file does not appear to be a valid archive
I think it's because in pg_dump, I not set -F c option :(
How I can restore this broken file?
Thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bax@sunet.ru
Subject: Re: pg_dump/pg_restore
In-Reply-To: <400288CC.4050005@sunet.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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