| From: | Manuel Trujillo <manueltrujillo(at)dorna(dot)es> |
|---|---|
| To: | Srinivasa Rao Chava <s(dot)chava(at)wcom(dot)com> |
| Cc: | pg-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pg_restore |
| Date: | 2002-02-06 16:23:44 |
| Message-ID: | 1013012624.902.12.camel@klingon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)dorna(dot)es
Technical Engineer http://www.motograndprix.com
Dorna Sports S.L. +34 93 4702864
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-02-06 16:33:30 | Re: pg_restore |
| Previous Message | Srinivasa Rao Chava | 2002-02-06 15:47:38 | pg_restore |