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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend