Re: [Admin] Large DataBase move

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [Admin] Large DataBase move
Date: 2010-08-28 16:09:40
Message-ID: 4C7934C4.70702@krogh.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Carl Anderson 2010-08-28 18:03:11 vacuumdb: vacuuming of database "Validation" failed: ERROR: failed to re-find parent key in index...
Previous Message Joshua D. Drake 2010-08-28 15:44:17 Re: [Admin] Large DataBase move