Backup - Restore (pg-dump)

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

Responses

Browse pgsql-admin by date

  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