From: Amit jain <amitjain@synechron.com>
To: Jesper Krogh <jesper@krogh.cc>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: [Admin] Large DataBase move
Date: Sun, 29 Aug 2010 20:34:24 +0530
Message-ID: <4C7A76F8.4040201@synechron.com> (raw)
In-Reply-To: <4C7934C4.70702@krogh.cc>
References: <AANLkTimdqrp-FkfE_ZY+qPjSdF4LjR4SuT3VTf8VnX9C@mail.gmail.com>
<1283010257.31376.21.camel@jd-desktop.unknown.charter.com>
<4C7934C4.70702@krogh.cc>
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 <http://www.synechron.com/; MailTo:
amitjain@synechron.com <mailto:nilnandanj@synechron.com>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: amitjain@synechron.com, jesper@krogh.cc
Subject: Re: [Admin] Large DataBase move
In-Reply-To: <4C7A76F8.4040201@synechron.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox