Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B3E722E0043 for ; Thu, 13 Mar 2008 00:19:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 08398-02 for ; Thu, 13 Mar 2008 00:19:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from vms040pub.verizon.net (vms040pub.verizon.net [206.46.252.40]) by postgresql.org (Postfix) with ESMTP id 798FA2E003F for ; Thu, 13 Mar 2008 00:19:06 -0300 (ADT) Received: from new-host.home ([71.245.161.199]) by vms040.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JXN00H96G0K1KA1@vms040.mailsrvcs.net> for pgsql-admin@postgresql.org; Wed, 12 Mar 2008 22:21:57 -0500 (CDT) Date: Wed, 12 Mar 2008 23:17:59 -0400 From: Robert Treat Subject: Re: migration of 7.4 to 8.1 In-reply-to: To: pgsql-admin@postgresql.org Cc: "sathiya psql" Message-id: <200803122318.00032.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-15 Content-transfer-encoding: 7bit Content-disposition: inline References: User-Agent: KMail/1.9.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/100 X-Sequence-Number: 28583 On Wednesday 12 March 2008 01:27, sathiya psql wrote: > Is there any article describing the migration database from postgresql > 7.4to 8.1 I don't know of any specific references, but the process is not fundementally different from any other major version upgrade. You'll want to do a schema only dump of your current database any load that into the 8.1 database. Once you feel comfortable that this works ok, try a data only dump and load that into the 8.1 server. Once you comfortable all that works, you're ready to upgrade. I will note that if you're planning to upgrade, I'd recommend going stright to 8.3. 8.1 is a few years old, and 8.3 provides a number of features and improvement you'll benefit from. Unless you have a strong reason to do otherwise, go to 8.3. HTH. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL