Re: Error trying to restore db with blobs - Mailing list pgsql-general

From Tom Lane
Subject Re: Error trying to restore db with blobs
Date
Msg-id 8524.1013698139@sss.pgh.pa.us
Whole thread Raw
In response to Error trying to restore db with blobs  ("Evandro" <evandro@horizontenet.com.br>)
List pgsql-general
"Evandro" <evandro@horizontenet.com.br> writes:
> pg_dump -Ft -b -o $DB | bzip2 > $ARQ
> pg_restore -h $SRV -vOd $DB -u $BUNZIPARQ

> Creating <Init> Max OID
> Archiver(db): Could not execute query. No result from backend.

This is is a bug in pg_restore that's triggered by the combination of
-Ft (or -Fc) and -o.  It's fixed in 7.2's pg_restore.

            regards, tom lane

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Error trying to restore db with blobs
Next
From: Erwin Ambrosch
Date:
Subject: PRIMARY KEY and UNIQUE