X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C4D61D1DA69 for ; Wed, 21 Apr 2004 10:28:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 58872-04 for ; Wed, 21 Apr 2004 10:28:30 -0300 (ADT) Received: from elbereth.noviforum.si (unknown [193.189.169.66]) by svr1.postgresql.org (Postfix) with ESMTP id 17122D1D179 for ; Wed, 21 Apr 2004 10:28:26 -0300 (ADT) Received: from elbereth.noviforum.si (localhost [127.0.0.1]) by elbereth.noviforum.si (8.12.10/8.12.10) with ESMTP id i3LDSNHh009057; Wed, 21 Apr 2004 15:28:23 +0200 Received: (from gregab@localhost) by elbereth.noviforum.si (8.12.10/8.12.10/Submit) id i3LDSNsr009056; Wed, 21 Apr 2004 15:28:23 +0200 Date: Wed, 21 Apr 2004 15:28:23 +0200 From: Grega Bremec To: Fischer Ulrich Cc: pgsql-admin@postgresql.org Subject: Re: problem with pg_dump and pg_restore Message-ID: <20040421132823.GA8984@elbereth.noviforum.si> References: <40866D3E.3060600@aerodynamics.ch> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="fdj2RfSjLxBAspz7" Content-Disposition: inline In-Reply-To: <40866D3E.3060600@aerodynamics.ch> User-Agent: Mutt/1.4.2i Organization: Noviforum, Ltd., Software & Media X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/276 X-Sequence-Number: 13249 --fdj2RfSjLxBAspz7 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable ...and on Wed, Apr 21, 2004 at 02:46:54PM +0200, Fischer Ulrich used the ke= yboard: > Hi >=20 > I try to move my datas from a postresql 7.3.2 to a postgresql 7.4.1. The= =20 > database was dumped with: >=20 > pg_dumpall -g GLOBALobjects.sql > pg_dump -s DATABASE > DBschema.sql > pg_dump -Fc DATABASE > DBdata.tar >=20 Why the schema/data separation? One important freedom you get when combining schema and data in the dumps is you can alter it after you imported the data and thus avoid cyclic dependencies where existance of one foreign key manda= tes the existance of another, which refers to the first one. For now though, try eliminating all constraints from the schema dump and ALTERing the tables after you imported the data. Hope this helped, --=20 Grega Bremec Senior Administrator Noviforum Ltd., Software & Media http://www.noviforum.si/ --fdj2RfSjLxBAspz7 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAhnb3Do/EMYD4+osRAm/GAKCX/tuCXZcVVk3pm6E2VOoIr9pyhwCgjl9e 07e/tjJG4xnUiGV7hIiIeFg= =amvd -----END PGP SIGNATURE----- --fdj2RfSjLxBAspz7--