Обсуждение: [Admin] Large DataBase move
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.
thank you very much.
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. JD -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
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. -- Jesper
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. JD -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
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>