Re: Error trying to restore db with blobs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Evandro" <evandro(at)horizontenet(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org, "Cristiano Reis Monteiro" <cristmon(at)ufba(dot)br>
Subject: Re: Error trying to restore db with blobs
Date: 2002-02-14 14:48:59
Message-ID: 8524.1013698139@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Evandro" <evandro(at)horizontenet(dot)com(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erwin Ambrosch 2002-02-14 15:06:35 PRIMARY KEY and UNIQUE
Previous Message Doug McNaught 2002-02-14 13:43:14 Re: Error trying to restore db with blobs