From: | Doug McNaught <doug(at)wireboard(dot)com> |
---|---|
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 13:43:14 |
Message-ID: | m3vgd0p4b1.fsf@varsoon.denali.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Evandro" <evandro(at)horizontenet(dot)com(dot)br> writes:
> This is the command for dump I´m using:
> pg_dump -Ft -b -o $DB | bzip2 > $ARQ
>
> This is the command for restore:
> pg_restore -h $SRV -vOd $DB -u $BUNZIPARQ
>
> This error occurs both in 7.12 and 7.13 I didn´t tested in 7.2
>
> I´m getting this error:
>
> Creating <Init> Max OID
> Archiver(db): Could not execute query. No result from backend.
I just ran into something like this. Make sure you create the
database you're going to restore into with template0 as the template,
eg:
$ createdb -T template0 $DB
$ pg_restore <...>
That fixed it for me.
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-02-14 14:48:59 | Re: Error trying to restore db with blobs |
Previous Message | Erwin Ambrosch | 2002-02-14 13:27:22 | PRIMARY KEY and UNIQUE |