pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed[Admin] Large DataBase move
4+ messages / 4 participants
[nested] [flat]
* [Admin] Large DataBase move
@ 2010-08-28 15:25 David Montoya <erethond@gmail.com>
2010-08-28 15:44 ` Re: [Admin] Large DataBase move Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 4+ messages in thread
From: David Montoya @ 2010-08-28 15:25 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [Admin] Large DataBase move
2010-08-28 15:25 [Admin] Large DataBase move David Montoya <erethond@gmail.com>
@ 2010-08-28 15:44 ` Joshua D. Drake <jd@commandprompt.com>
2010-08-28 16:09 ` Re: [Admin] Large DataBase move Jesper Krogh <jesper@krogh.cc>
0 siblings, 1 reply; 4+ messages in thread
From: Joshua D. Drake @ 2010-08-28 15:44 UTC (permalink / raw)
To: David Montoya <erethond@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [Admin] Large DataBase move
2010-08-28 15:25 [Admin] Large DataBase move David Montoya <erethond@gmail.com>
2010-08-28 15:44 ` Re: [Admin] Large DataBase move Joshua D. Drake <jd@commandprompt.com>
@ 2010-08-28 16:09 ` Jesper Krogh <jesper@krogh.cc>
2010-08-29 15:04 ` Re: [Admin] Large DataBase move Amit jain <amitjain@synechron.com>
0 siblings, 1 reply; 4+ messages in thread
From: Jesper Krogh @ 2010-08-28 16:09 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [Admin] Large DataBase move
2010-08-28 15:25 [Admin] Large DataBase move David Montoya <erethond@gmail.com>
2010-08-28 15:44 ` Re: [Admin] Large DataBase move Joshua D. Drake <jd@commandprompt.com>
2010-08-28 16:09 ` Re: [Admin] Large DataBase move Jesper Krogh <jesper@krogh.cc>
@ 2010-08-29 15:04 ` Amit jain <amitjain@synechron.com>
0 siblings, 0 replies; 4+ messages in thread
From: Amit jain @ 2010-08-29 15:04 UTC (permalink / raw)
To: Jesper Krogh <jesper@krogh.cc>; +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>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-08-29 15:04 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-08-28 15:25 [Admin] Large DataBase move David Montoya <erethond@gmail.com>
2010-08-28 15:44 ` Joshua D. Drake <jd@commandprompt.com>
2010-08-28 16:09 ` Jesper Krogh <jesper@krogh.cc>
2010-08-29 15:04 ` Amit jain <amitjain@synechron.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox