There appears to be a problem with pgadminIII where the option to
disable triggers does not actually do anything! If I switch to the
pg_dump command line then the disable triggers works. Unfortunately I
still cannot restore a database backed up from a linux machine running
8.0.1 to an windows machine running 8.0.3.
My problem seems to be:
1. I use a archive backup, which contains tsearch2 tables causes
conflict with existing tsearch2 tables created from template1.
or...
2. I use plain backup and restore to a blank database created from
template0 - and the restore fails because it can't find tsearch2 types.
My head hurts.
I shall try to manually hack the plain backup file to remove references
to the tsearch2 tables.
Will all of these problems disappear if I upgrade the linux machine to
8.0.3?
Howard.
www.selestial.com
Howard Cole wrote:
To improve compatibility, I created a backup on the linux system
(8.0.1) using plain format, data only with triggers disabled. However,
when I try to restore the plain sql on the windows machine (8.0.3) it
fails because the first insert command fails a foreign key constraint.
Can I disable foreign key checks for the duration of the restore?
Howard
www.selestial.com
Howard Cole wrote:
Hi,
Should it be possible to create a compressed backup of a version
8.0.1 database running on linux and restore that backup on version
8.0.3 running on XP? I ask this because it does not seem to work for
me. Many problems seem to arise to do with tsearch2 extensions to
tables, even though tsearch2 is installed on the XP machine.
The backup was created using pgAdminIII.
Howard.
www.selestial.com
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
