Re: [ADMIN] [Admin] Large DataBase move

2010-08-29 Thread Amit jain
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 po

Re: [ADMIN] [Admin] Large DataBase move

2010-08-28 Thread Jesper Krogh
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.

Re: [ADMIN] [Admin] Large DataBase move

2010-08-28 Thread Joshua D. Drake
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

[ADMIN] [Admin] Large DataBase move

2010-08-28 Thread David Montoya
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.