dump / restore problem with large objects
dump / restore problem with large objects
От:
SBSD PgAdmin <postgres@sbsd.de>
Дата:
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.