Skip site navigation (1) Skip section navigation (2)

loosing constraint at backup

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-admin(at)postgresql(dot)org
Subject: loosing constraint at backup
Date: 2008-04-24 07:47:00
Message-ID: fupdtb$1rcd$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-admin
Hi there,

I have a script running frequently in development process that copy a 
database from a linux os machine to another windows os.

On windows I have "PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC 
gcc.exe (GCC) 3.4.2 (mingw-special)".
On linux: "PostgreSQL 8.2.3 on i686-redhat-linux-gnu, compiled by GCC gcc 
(GCC) 4.0.2 20051125 (Red Hat 4.0.2-8)".

The script use the following commands to dump/restore:

pg_dump.exe <src_db> -i -F c -b -v -U postgres -f <bak_file> -h src_ip -p 
src_port
pg_restore.exe -i -d <dst_db> -v --disable-triggers -U postgres <bak_name>

In rare cases, I found one foreign key constraint is missing on destination.

Unfortunatelly, in spite this problem happens to me since a long time, the 
problem is not reproductible, and this is the reason I was reticent to post 
it until now.
In the future, also I will keep the backup file to found whether the problem 
is on dump or restore.

Is this problem known ?

TIA,
Sabin 



Responses

pgsql-admin by date

Next:From: Abhishek MishraDate: 2008-04-24 08:45:51
Subject: Problem with SGT (Singapore) timezone
Previous:From: Darren ReedDate: 2008-04-24 04:04:22
Subject: Re: Some additions to pg_filedump...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group