pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNEED REPLICATION SOLUTION -POSTGRES 9.1
4+ messages / 4 participants
[nested] [flat]
* NEED REPLICATION SOLUTION -POSTGRES 9.1
@ 2012-11-28 18:06 suhas.basavaraj12 <suhas.b@verse.in>
2012-11-28 18:18 ` Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 4+ messages in thread
From: suhas.basavaraj12 @ 2012-11-28 18:06 UTC (permalink / raw)
To: pgsql-admin
Hi,
We are planning to migrate our production databases to different
servers.We have around 8 servers with 8 different clusters.We are planning
t shuffle databases and make them as 7 cluster and migrate to new remote
servers .
We cannot use streaming replication as we are migrating different databases
from different clusters to one single cluster . This will be resulting in
huge downtime as data is huge .
Need expert advice on this scenario.Can we reduce downtime in any way ..??
Rgrds
Suhas
--
View this message in context: http://postgresql.1045698.n5.nabble.com/NEED-REPLICATION-SOLUTION-POSTGRES-9-1-tp5733937.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: NEED REPLICATION SOLUTION -POSTGRES 9.1
2012-11-28 18:06 NEED REPLICATION SOLUTION -POSTGRES 9.1 suhas.basavaraj12 <suhas.b@verse.in>
@ 2012-11-28 18:18 ` Scott Ribe <scott_ribe@elevated-dev.com>
2012-11-28 18:46 ` Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 Gabriel Muñoz <gabriel.munoz@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Scott Ribe @ 2012-11-28 18:18 UTC (permalink / raw)
To: suhas.basavaraj12 <suhas.b@verse.in>; +Cc: pgsql-admin
On Nov 28, 2012, at 11:06 AM, suhas.basavaraj12 wrote:
> Need expert advice on this scenario.Can we reduce downtime in any way ..??
You can use the Slony replication system: <http://slony.info/;
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: NEED REPLICATION SOLUTION -POSTGRES 9.1
2012-11-28 18:06 NEED REPLICATION SOLUTION -POSTGRES 9.1 suhas.basavaraj12 <suhas.b@verse.in>
2012-11-28 18:18 ` Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 Scott Ribe <scott_ribe@elevated-dev.com>
@ 2012-11-28 18:46 ` Gabriel Muñoz <gabriel.munoz@gmail.com>
2012-11-28 19:07 ` Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 Robert Treat <rob@xzilla.net>
0 siblings, 1 reply; 4+ messages in thread
From: Gabriel Muñoz @ 2012-11-28 18:46 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: suhas.basavaraj12 <suhas.b@verse.in>; pgsql-admin
I'm using WAL, I follow this tutorial:
http://blog.gomiso.com/2012/02/13/adventures-in-scaling-part-3-postgresql-streaming-replication/
It's work perfect for me, async replication.
Gabriel.
On Wed, Nov 28, 2012 at 3:18 PM, Scott Ribe <scott_ribe@elevated-dev.com>wrote:
> On Nov 28, 2012, at 11:06 AM, suhas.basavaraj12 wrote:
>
> > Need expert advice on this scenario.Can we reduce downtime in any way
> ..??
>
> You can use the Slony replication system: <http://slony.info/;
>
> --
> Scott Ribe
> scott_ribe@elevated-dev.com
> http://www.elevated-dev.com/
> (303) 722-0567 voice
>
>
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: NEED REPLICATION SOLUTION -POSTGRES 9.1
2012-11-28 18:06 NEED REPLICATION SOLUTION -POSTGRES 9.1 suhas.basavaraj12 <suhas.b@verse.in>
2012-11-28 18:18 ` Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 Scott Ribe <scott_ribe@elevated-dev.com>
2012-11-28 18:46 ` Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 Gabriel Muñoz <gabriel.munoz@gmail.com>
@ 2012-11-28 19:07 ` Robert Treat <rob@xzilla.net>
0 siblings, 0 replies; 4+ messages in thread
From: Robert Treat @ 2012-11-28 19:07 UTC (permalink / raw)
To: Gabriel Muñoz <gabriel.munoz@gmail.com>; +Cc: Scott Ribe <scott_ribe@elevated-dev.com>; suhas.basavaraj12 <suhas.b@verse.in>; pgsql-admin
The OP mentioned he couldn't use streaming as he is combining
databases from multiple clusters into one, so non-streaming WAL isn't
going to work any better for that.
He needs to use Slony, Bucardo, or some other trigger based system (or
roll his own) to accomplish this, WAL based solutions wont work.
Robert Treat
play: xzilla.net
work: omniti.com
On Wed, Nov 28, 2012 at 1:46 PM, Gabriel Muñoz <gabriel.munoz@gmail.com> wrote:
> I'm using WAL, I follow this tutorial:
> http://blog.gomiso.com/2012/02/13/adventures-in-scaling-part-3-postgresql-streaming-replication/
>
> It's work perfect for me, async replication.
>
> Gabriel.
>
>
>
>
> On Wed, Nov 28, 2012 at 3:18 PM, Scott Ribe <scott_ribe@elevated-dev.com>
> wrote:
>>
>> On Nov 28, 2012, at 11:06 AM, suhas.basavaraj12 wrote:
>>
>> > Need expert advice on this scenario.Can we reduce downtime in any way
>> > ..??
>>
>> You can use the Slony replication system: <http://slony.info/;
>>
>> --
>> Scott Ribe
>> scott_ribe@elevated-dev.com
>> http://www.elevated-dev.com/
>> (303) 722-0567 voice
>>
>>
>>
>>
>>
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-11-28 19:07 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-11-28 18:06 NEED REPLICATION SOLUTION -POSTGRES 9.1 suhas.basavaraj12 <suhas.b@verse.in>
2012-11-28 18:18 ` Scott Ribe <scott_ribe@elevated-dev.com>
2012-11-28 18:46 ` Gabriel Muñoz <gabriel.munoz@gmail.com>
2012-11-28 19:07 ` Robert Treat <rob@xzilla.net>
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