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>