Hi,
I am using the fulldump and fullrestore scripts from Colin Stearman.
This script (fulldump) executes
pg_dumpall -g >$Globals
and for each database
pg_dump -Fc -Z1 -b "$db_name" -f "$BackupDir/$db_name.pgdump"
fullrestore works something like this:
psql template1 <$Globals
and for each database
pg_restore -d $DBName $file
When I try to do a fullrestore on another Postgres server
restoring fails with some databases.
I get the following error message:
pg_restore: [archiver (db)] could not create large object cross-reference
entry
I searched the www for a while, but can not find anything helpful.
Whats going wrong?
Im using PostgreSQL 7.2.1 at the server where the dumps are
taken from and PostgreSQL 7.2.4 where the dumps should be restored to.