Bug to restore OID with pg_restore

=?utf-8?Q?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, Pennsylvania 19026