Re: Bug to restore OID with pg_restore

=?utf-8?Q?abremond(at)voila(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026