=?utf-8?Q?[EMAIL PROTECTED]?= 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
