From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Trevor Astrope <astrope(at)e-corp(dot)net> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Help pg_restore |
Date: | 2002-02-26 23:19:54 |
Message-ID: | 13280.1014765594@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Trevor Astrope <astrope(at)e-corp(dot)net> writes:
> I'm trying to restore a database dumped with pg_dump with the -o -Fc
> options with pg_restore from a 7.1.3 database into a 7.1.3 database on
> another machine.
> When using the -d option in pg_restore, I get this error:
> Connecting to database for restore
> Creating <Init> Max OID
> Archiver(db): Could not execute query. No result from backend.
This is a known bug in 7.1.* pg_restore: it doesn't work with -o -Fc
(nor -o -Ft) archives. It's fixed in 7.2.
If you don't want to update your server to 7.2 just yet, I believe it
will work to install only the 7.2 version of pg_restore and use that
to restore this archive.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Helge Bahmann | 2002-02-26 23:41:36 | Re: configure --with-pam |
Previous Message | Chris Bowlby | 2002-02-26 20:08:50 | [GENERAL] password change... |