Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0B3B82E018E for ; Thu, 13 Mar 2008 02:50:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 20850-03 for ; Thu, 13 Mar 2008 02:50:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.237]) by postgresql.org (Postfix) with ESMTP id DD48C2E018B for ; Thu, 13 Mar 2008 02:50:22 -0300 (ADT) Received: by qb-out-0506.google.com with SMTP id o12so2754714qba.17 for ; Wed, 12 Mar 2008 22:50:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=vC66Wh1zt6kVnnsj853KD16tMySxk9iJy+R/+SYqCHI=; b=slgqsKNm/ZUCKCroj4VkKaUAFfi3T7XBAd8zLNAaD/Ypl2v91rRzP1AVjvdqM103rXCIFigazNwdQWxc92L3V+Qz9tMyM5rihfIY/3PAkWZrmJzpntijbiDuD4uSbDaqR1f1RWMeE/2Ze9Y20ZNMdzsAdL0WJPWbEVoUkY+9Kc8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=TcFePVlRhjO0AFozwlDhs7vuOxdR/L3S8KYtiKjXuT1UvhNeYY3JR9cOJ59iX6saV61zovKvg/V4W2cCNRxRoNPOCYUzHAzaIQm5AzIg0sQIq24lReTGXEPfqLd/mEyyWl7rDdaxa3RwHVo31OFjMD1dH0ApKFaftJ6c2xSSfqg= Received: by 10.114.180.1 with SMTP id c1mr8729293waf.121.1205387421627; Wed, 12 Mar 2008 22:50:21 -0700 (PDT) Received: by 10.114.133.6 with HTTP; Wed, 12 Mar 2008 22:50:21 -0700 (PDT) Message-ID: Date: Wed, 12 Mar 2008 22:50:21 -0700 From: "Scott Marlowe" To: "Robert Treat" Subject: Re: migration of 7.4 to 8.1 Cc: pgsql-admin@postgresql.org, "sathiya psql" In-Reply-To: <200803122318.00032.xzilla@users.sourceforge.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200803122318.00032.xzilla@users.sourceforge.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/102 X-Sequence-Number: 28585 On Wed, Mar 12, 2008 at 8:17 PM, Robert Treat wrote: > 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. And if the OP is worried about running too new a version of pgsql, 8.2.6 is very mature. But if he's got 6 or more months until he goes live, which is common, I'd recommend going to 8.3 which will be well polished by then.