From: | Howard Cole <howardnews(at)selestial(dot)com> |
---|---|
To: | 'PgSql General' <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Backup Compatibility between minor versions. |
Date: | 2005-06-08 13:04:34 |
Message-ID: | 42A6ECE2.80308@selestial.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | dong changyu | 2005-06-08 13:09:24 | vulnerability/SSL |
Previous Message | Sean Davis | 2005-06-08 12:44:59 | Re: Copying data from int column to array column |