From: | "creid" <creid(at)netbcg(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Backup - Restore (pg-dump) |
Date: | 2003-09-03 19:33:10 |
Message-ID: | LCEPJPNMJAAFPONODDCOOENKCEAA.creid@netbcg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Any Help
I recently upgraded to 7.3.4 from 7.3.2. Prior to the upgrade I used
"pg_dump -a > olddatafile" for just data and "pg_dump -s > oldschemafile"
for schema using the pg_dump utility from 7.3.2. After a "successful"
install of 7.3.4, I created the database then went on to "successful"
"psql -f schemafile" and then "psql -f > datafile" and results were as
expected.
However, when i used the "pg_dump -a newdatafile" and "psql -f newdatafile"
commands from the 7.3.4 version, I get random:
psql:bcgdata3:491: ERROR: $1 referential integrity violation - key
referenced from customer not found in euser
psql:bcgdata3:491: lost synchronization with server, resetting connection
psql:bcgdata3:507: ERROR: $1 referential integrity violation - key
referenced from billing not found in customer
psql:bcgdata3:507: lost synchronization with server, resetting connection
psql:bcgdata3:528: ERROR: $1 referential integrity violation - key
referenced from shipping not found in customer
psql:bcgdata3:528: lost synchronization with server, resetting connection
psql:bcgdata3:586: ERROR: $1 referential integrity violation - key
referenced from javastore not found in euser
psql:bcgdata3:586: lost synchronization with server, resetting connection
psql:bcgdata3:628: ERROR: $1 referential integrity violation - key
referenced from bcgmodules not found in javastore
psql:bcgdata3:628: lost synchronization with server, resetting connection
I tried each command on old cluster and new cluster and very same results.
However, I successfully update the 7.3.4 database when I "psql -f
olddatafile" using the 7.3.4 psql command.
What might be my problem and/or solution? I hope I am clear enough for a
positive response.
Thanks Much
C
creid(at)netbcg(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2003-09-03 20:01:52 | Re: Backup - Restore (pg-dump) |
Previous Message | Rhaoni Chiu Pereira | 2003-09-03 19:15:58 | SQL slower when running for the second time |