Received: from montseny-f.ibernet.com (bcnsf.jazztel.es [212.106.195.71] (may be forged)) by postgresql.org (8.11.3/8.11.4) with ESMTP id g16GKcE78634 for ; Wed, 6 Feb 2002 11:20:38 -0500 (EST) (envelope-from manueltrujillo@dorna.es) Received: from klingon.web.es ([212.163.226.3]) by montseny-f.ibernet.com (Post.Office MTA v3.5.3 release 223 ID# 0-70794U9000L900S0V35) with ESMTP id com; Wed, 6 Feb 2002 17:20:41 +0100 Received: from localhost ([127.0.0.1] helo=localhost.localdomain ident=toomany) by klingon.web.es with esmtp (Exim 3.34 #1 (Debian)) id 16YUrI-0000Z1-00; Wed, 06 Feb 2002 17:23:44 +0100 Subject: Re: pg_restore From: Manuel Trujillo To: Srinivasa Rao Chava Cc: pg-admin In-Reply-To: <66d229f1.0202060747.39b66049@posting.google.com> References: <66d229f1.0202060747.39b66049@posting.google.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0.2 Date: 06 Feb 2002 17:23:44 +0100 Message-Id: <1013012624.902.12.camel@klingon> Mime-Version: 1.0 X-Archive-Number: 200202/43 X-Sequence-Number: 3204 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