Re: [Admin] Large DataBase move - Mailing list pgsql-admin

From Jesper Krogh
Subject Re: [Admin] Large DataBase move
Date
Msg-id 4C7934C4.70702@krogh.cc
Whole thread Raw
In response to Re: [Admin] Large DataBase move  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: [Admin] Large DataBase move  (Amit jain <amitjain@synechron.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [Admin] Large DataBase move
Next
From: Carl Anderson
Date:
Subject: vacuumdb: vacuuming of database "Validation" failed: ERROR: failed to re-find parent key in index...