Обсуждение: Help pg_restore
I'm trying to restore a database dumped with pg_dump with the -o -Fc options with pg_restore from a 7.1.3 database into a 7.1.3 database on another machine. When using the -d option in pg_restore, I get this error: Connecting to database for restore Creating <Init> Max OID Archiver(db): Could not execute query. No result from backend. If I don't use -d and pipe the output of pg_restore into psql, I can restore the database, but it takes about 20 hours to restore a .2.8gb dump when uncompressed. So my question is: what is the syntax to restore this dump? Regards, Trevor Astrope astrope@e-corp.net
Trevor Astrope <astrope@e-corp.net> writes: > I'm trying to restore a database dumped with pg_dump with the -o -Fc > options with pg_restore from a 7.1.3 database into a 7.1.3 database on > another machine. > When using the -d option in pg_restore, I get this error: > Connecting to database for restore > Creating <Init> Max OID > Archiver(db): Could not execute query. No result from backend. This is a known bug in 7.1.* pg_restore: it doesn't work with -o -Fc (nor -o -Ft) archives. It's fixed in 7.2. If you don't want to update your server to 7.2 just yet, I believe it will work to install only the 7.2 version of pg_restore and use that to restore this archive. regards, tom lane