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@postgresql.org)
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>