Hi!
8.0.1 and 8.1 beta.
Triggers are still fired although option --disable-triggers is applied
to pg_restore. The fired triggers abort pg_restore because of the
foreign keys violations.
The following restore script used to be working but it suddently
doesn't. I don't remember I ever changed this script since it had
worked.
#Backup command:
#PGCLIENTENCODING=UNICODE pg_dump -Fc db1 > db1
#
#Restore commands:
pg_restore -l db1 >list
createdb -E UNICODE db1
pg_restore -F c -L list -v -d db1 -s db1 >log-schema 2>&1
pg_restore -F c -L list -v -d db1 -a --disable-triggers db1 >log-data
2>&1
Any idea will be much appreciated.
Regards,
CN
--
http://www.fastmail.fm - Email service worth paying for. Try it for free