Re: pg_restore - Mailing list pgsql-admin

From Manuel Trujillo
Subject Re: pg_restore
Date
Msg-id 1013012624.902.12.camel@klingon
Whole thread Raw
In response to pg_restore  (s.chava@wcom.com (Srinivasa Rao Chava))
List pgsql-admin
On Wed, 2002-02-06 at 16:47, Srinivasa Rao Chava wrote:
> Hey,
> I have upgraded my pgostgresql from 7.1.2 to 7.1.3 as the pg_restore
> is not working properly in 7.1.2
> I took the database backup with pg_dump.
> After upgrading to 7.1.3, I have restored the database with
> pg_restore.
> It is restoring , but giving the following error with sequences and
> recovery is failing

Hi.

I'm not any guru, but I think if you make the pg_dump/pg_restore with
the -x (whitout acl's), and -O (whitout owner) an, finally, -i
(ignore-version), will possible to make this backup (I think).

Have a nice day ;-)
TooManySecrets

--
Manuel Trujillo         manueltrujillo@dorna.es
Technical Engineer      http://www.motograndprix.com
Dorna Sports S.L.       +34 93 4702864


pgsql-admin by date:

Previous
From: s.chava@wcom.com (Srinivasa Rao Chava)
Date:
Subject: pg_restore
Next
From: Tom Lane
Date:
Subject: Re: pg_restore