Re: [Admin] Large DataBase move
От | Amit jain |
---|---|
Тема | Re: [Admin] Large DataBase move |
Дата | |
Msg-id | 4C7A76F8.4040201@synechron.com обсуждение исходный текст |
Ответ на | Re: [Admin] Large DataBase move (Jesper Krogh <jesper@krogh.cc>) |
Список | 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@synechron.com <mailto:nilnandanj@synechron.com>
В списке pgsql-admin по дате отправления: