From: Sabin Coanda <sabin.coanda@deuromedia.ro>
To: pgsql-admin@postgresql.org
Subject: loosing constraint at backup
Date: Thu, 24 Apr 2008 10:47:00 +0300
Message-ID: <fupdtb$1rcd$1@news.hub.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sabin.coanda@deuromedia.ro
Subject: Re: loosing constraint at backup
In-Reply-To: <fupdtb$1rcd$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox