pg_dump/pg_restore

From: Alexey Bobkov <bax(at)sunet(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump/pg_restore
Date: 2004-01-12 11:45:16
Message-ID: 400288CC.4050005@sunet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jan Wieck 2004-01-12 14:38:11 Re: [HACKERS] IEEE 754
Previous Message kandiah ratnavale 2004-01-12 08:27:15 problem creating user