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