Обсуждение: 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