X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4400BD9845 for ; Wed, 9 Nov 2005 04:38:58 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55324-07 for ; Wed, 9 Nov 2005 08:38:56 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 0EC12D97F2 for ; Wed, 9 Nov 2005 04:38:56 -0400 (AST) Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by svr2.postgresql.org (Postfix) with ESMTP id 00FA6F0FAF for ; Wed, 9 Nov 2005 08:38:57 +0000 (GMT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id jA98ZHSv005706; Wed, 9 Nov 2005 10:35:17 +0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id jA98ZH3R005702; Wed, 9 Nov 2005 10:35:17 +0200 Date: Wed, 9 Nov 2005 10:35:17 +0200 (EET) From: Achilleus Mantzios To: "A. Kretschmer" Cc: pgsql-sql@postgresql.org Subject: Re: Migrating database from postgresql 7.4.6 to postgresql In-Reply-To: <20051109075500.GD30305@webserv.wug-glas.de> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/74 X-Sequence-Number: 23325 O A. Kretschmer έγραψε στις Nov 9, 2005 : > am 08.11.2005, um 23:18:35 -0800 mailte Louise Catherine folgendes: > > Hi, > > I would like to migrating my database from postgresql > > 7.4.6 to postgresql 8.0.3. > > Why not 8.1.0? > > > > Are there any problem during migrating database? a > > casting problem or sintax problem, or other problem? > > I dont know about problems. Install the new database (on the same > machine, use a different port), and use the pg_dump from the newer > version to dump the old db in the new db. Or better consult HISTORY. It is in the root of the tarball. > > > HTH, Andreas > -- -Achilleus