pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
loosing constraint at backup 2+ messages / 1 participants [nested] [flat]
* loosing constraint at backup @ 2008-04-24 07:47 Sabin Coanda <sabin.coanda@deuromedia.ro> 2008-04-24 09:30 ` Re: loosing constraint at backup Sabin Coanda <sabin.coanda@deuromedia.ro> 0 siblings, 1 reply; 2+ messages in thread From: Sabin Coanda @ 2008-04-24 07:47 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: loosing constraint at backup 2008-04-24 07:47 loosing constraint at backup Sabin Coanda <sabin.coanda@deuromedia.ro> @ 2008-04-24 09:30 ` Sabin Coanda <sabin.coanda@deuromedia.ro> 0 siblings, 0 replies; 2+ messages in thread From: Sabin Coanda @ 2008-04-24 09:30 UTC (permalink / raw) To: pgsql-admin After retrying the scenario, I found the problem is in the dump, and the constraint is missing in the backup file. Sabin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-04-24 09:30 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-04-24 07:47 loosing constraint at backup Sabin Coanda <sabin.coanda@deuromedia.ro> 2008-04-24 09:30 ` Sabin Coanda <sabin.coanda@deuromedia.ro>
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