Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 27B6D632785 for ; Sun, 29 Aug 2010 12:04:54 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 66135-04 for ; Sun, 29 Aug 2010 15:04:47 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp212.iad.emailsrvr.com (smtp212.iad.emailsrvr.com [207.97.245.212]) by mail.postgresql.org (Postfix) with ESMTP id F11D1632694 for ; Sun, 29 Aug 2010 12:04:46 -0300 (ADT) Received: from relay11.relay.iad.mlsrvr.com (localhost [127.0.0.1]) by relay11.relay.iad.mlsrvr.com (SMTP Server) with ESMTP id 1307E1B4073; Sun, 29 Aug 2010 11:04:46 -0400 (EDT) Received: by relay11.relay.iad.mlsrvr.com (Authenticated sender: amitjain-AT-synechron.com) with ESMTPSA id 567711B406B; Sun, 29 Aug 2010 11:04:36 -0400 (EDT) Message-ID: <4C7A76F8.4040201@synechron.com> Date: Sun, 29 Aug 2010 20:34:24 +0530 From: Amit jain User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Jesper Krogh CC: "pgsql-admin@postgresql.org" Subject: Re: [Admin] Large DataBase move References: <1283010257.31376.21.camel@jd-desktop.unknown.charter.com> <4C7934C4.70702@krogh.cc> In-Reply-To: <4C7934C4.70702@krogh.cc> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.701 tagged_above=-10 required=5 tests=BAYES_40=-0.001, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201008/274 X-Sequence-Number: 35523 Upgrade with slony tool in less than 15min downtime. Try this out !! http://www.slony.info/documentation/versionupgrade.html Jesper Krogh wrote: > On 2010-08-28 17:44, Joshua D. Drake wrote: > >> On Sat, 2010-08-28 at 17:25 +0200, David Montoya wrote: >> >> >>> Hello: >>> >>> >>> I have a DB with 90GB in postgre 8.1 and I want to move to another >>> server. The new server has postgre 8.3 and I don't know if I can use >>> PITR to do the replication. >>> >>> >> You can not. >> >> Use Londiste or Slony. >> >> >> > Or just a dump/restore.. it is most likely less than 24 hours.. so if you > can justify that much down-time (read-only access), then that is the > easiest path. > > -- Regards, *Amit** Jain * *Synechron** Technologies Pvt. Ltd.* 4th Floor, B Wing, Block 1.2, Embassy Techzone, Rajiv Gandhi Infotech Park, Hinjewadi Phase II, Pune 411 057. Phone : +91.20.40262000 Ext 2163 | Mobile:+91.9561298565 | VoIP : +1.732.415.0894 http://www.synechron.com MailTo: amitjain@synechron.com