From: John Siracusa <siracusa@mindspring.com>
To: Postgres Admin <pgsql-admin@postgresql.org>
Subject: Re: pg_dump/pg_restore
Date: Mon, 12 Jan 2004 11:29:52 -0500
Message-ID: <BC2835B0.78BAB%siracusa@mindspring.com> (raw)
In-Reply-To: <4002C884.3080000@sancharnet.in>
On 1/12/04 11:17 AM, Sai Hertz And Control Systems wrote:
> Dear Alexey Bobkov ,
>> 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
>
> Use psql instead with command
> psql -U username databasename -f yourdb_file.sql
> Yes you will have to edit the file a bit.
> Drawbacks are :
> triggers will go of on all insert and will be stumbling block
Is this true when dumping using pg_dumpall and restoring by piping to psql?
Are triggers going off during the restore? I don't see a --disable-triggers
option to pg_dumpall.
-John
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: siracusa@mindspring.com
Subject: Re: pg_dump/pg_restore
In-Reply-To: <BC2835B0.78BAB%siracusa@mindspring.com>
* 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