Skip site navigation (1) Skip section navigation (2)

Re: [Admin] Large DataBase move

From: Amit jain <amitjain(at)synechron(dot)com>
To: Jesper Krogh <jesper(at)krogh(dot)cc>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [Admin] Large DataBase move
Date: 2010-08-29 15:04:24
Message-ID: 4C7A76F8.4040201@synechron.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)synechron(dot)com <mailto:nilnandanj(at)synechron(dot)com>

 

 

 

 


In response to

pgsql-admin by date

Next:From: Rosser SchwarzDate: 2010-08-29 17:21:11
Subject: Re: Use hardware snapshots to restore postgres
Previous:From: Scott MarloweDate: 2010-08-29 02:05:12
Subject: Re: Use hardware snapshots to restore postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group