Обсуждение: Bug to restore OID with pg_restore

Hi,

My server is a postgres v7.1.3.
I have a database with OID and to backup my database i use this syntaxe :
pg_dump -Ft -b -o -f mydb.tar mydb
when i want restore my database i use this command line:
pg_restore -o -d mydb mydb.tar
and i have this error :
Archiver(db): Could not execute query. No result from backend.

Could you help me, because i can't put my database offline and so i can't restore it with pg_restore.

I hope i am clear about my problem.
Hoping to hear from you soon.

Annie.


____________________________________________________________
Faites un voeu et puis Voila ! www.voila.fr
Avec Voila Mail, consultez vos e-mails sur votre mobile Wap.

abremond@voila.fr wrote:
> Hi,
>
> My server is a postgres v7.1.3.
> I have a database with OID and to backup my database i use this syntaxe :
> pg_dump -Ft -b -o -f mydb.tar mydb
> when i want restore my database i use this command line:
> pg_restore -o -d mydb mydb.tar
> and i have this error :
> Archiver(db): Could not execute query. No result from backend.
>
> Could you help me, because i can't put my database offline and so i can't restore it with pg_restore.
>
> I hope i am clear about my problem.
> Hoping to hear from you soon.

We only discovered this but recently, about two weeks ago.  We have a
fix in PostgreSQL 7.2RC2.  I think you can compile 7.2 and use that
pg_restore on a 7.1 database to restore.  It is the combination of -Ft
and -o that was at fault.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026