pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedreplica of database
14+ messages / 8 participants
[nested] [flat]
* replica of database
@ 2008-09-11 04:09 Aftab Alam <AAlam@tsrdarashaw.com>
0 siblings, 1 reply; 14+ messages in thread
From: Aftab Alam @ 2008-09-11 04:09 UTC (permalink / raw)
To: pgsql-admin
Hi all,
Can any one tell me how to replicate a db.
Regards
aftab
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 04:41 Vishal Arora <aroravishal22@hotmail.com>
parent: Aftab Alam <AAlam@tsrdarashaw.com>
0 siblings, 1 reply; 14+ messages in thread
From: Vishal Arora @ 2008-09-11 04:41 UTC (permalink / raw)
To: Aftab Alam <aalam@tsrdarashaw.com>; pgsql-admin
Do you mean Replication? There are already several posts about replication. What Platform are you using and what version of PostgreSQL are you using?
> From: AAlam@tsrdarashaw.com> To: pgsql-admin@postgresql.org> Date: Thu, 11 Sep 2008 09:39:48 +0530> Subject: [ADMIN] replica of database> > Hi all,> > Can any one tell me how to replicate a db.> > Regards> aftab> > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.> > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)> To make changes to your subscription:> http://www.postgresql.org/mailpref/pgsql-admin
_________________________________________________________________
Search for videos of Bollywood, Hollywood, Mollywood and every other wood, only on Live.com
http://www.live.com/?scope=video&form=MICOAL=
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 04:44 Aftab Alam <AAlam@tsrdarashaw.com>
parent: Vishal Arora <aroravishal22@hotmail.com>
0 siblings, 2 replies; 14+ messages in thread
From: Aftab Alam @ 2008-09-11 04:44 UTC (permalink / raw)
To: Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin
Yes ,I want a replica of my db so that I can use it as failover
Version 7.3 linux AS release 4 update 6
________________________________
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora
Sent: Thursday, September 11, 2008 10:11 AM
To: Aftab Alam; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] replica of database
Do you mean Replication? There are already several posts about replication. What Platform are you using and what version of PostgreSQL are you using?
________________________________
> From: AAlam@tsrdarashaw.com
> To: pgsql-admin@postgresql.org
> Date: Thu, 11 Sep 2008 09:39:48 +0530
> Subject: [ADMIN] replica of database
>
> Hi all,
>
> Can any one tell me how to replicate a db.
>
> Regards
> aftab
>
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
________________________________
MSN Technology brings you the latest on gadgets, gizmos and the new hits in the gaming market. Try it now!<http://computing.in.msn.com/;
________________________________
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 04:52 Joshua D. Drake <jd@commandprompt.com>
parent: Aftab Alam <AAlam@tsrdarashaw.com>
1 sibling, 3 replies; 14+ messages in thread
From: Joshua D. Drake @ 2008-09-11 04:52 UTC (permalink / raw)
To: Aftab Alam <AAlam@tsrdarashaw.com>; +Cc: Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin
Aftab Alam wrote:
> Yes ,I want a replica of my db so that I can use it as failover
>
>
>
> Version 7.3 linux AS release 4 update 6
Version 7.3 is end of life and I don't know of *any* of the replication
technologies that will work with it.
Joshua D. Drake
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 05:14 Vishal Arora <aroravishal22@hotmail.com>
parent: Aftab Alam <AAlam@tsrdarashaw.com>
1 sibling, 0 replies; 14+ messages in thread
From: Vishal Arora @ 2008-09-11 05:14 UTC (permalink / raw)
To: Aftab Alam <aalam@tsrdarashaw.com>; pgsql-admin
From: AAlam@tsrdarashaw.comTo: aroravishal22@hotmail.com; pgsql-admin@postgresql.orgDate: Thu, 11 Sep 2008 10:14:42 +0530Subject: RE: [ADMIN] replica of database
Yes ,I want a replica of my db so that I can use it as failover
Version 7.3 linux AS release 4 update 6
I would strongly recommend you to upgrade to 8.3.x. this is the latest release. 7.3 is too old and I don't think even postgres community is supporting it any more. If need help in upgrading, do let us know.
- Vishal
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal AroraSent: Thursday, September 11, 2008 10:11 AMTo: Aftab Alam; pgsql-admin@postgresql.orgSubject: Re: [ADMIN] replica of database
Do you mean Replication? There are already several posts about replication. What Platform are you using and what version of PostgreSQL are you using?
> From: AAlam@tsrdarashaw.com> To: pgsql-admin@postgresql.org> Date: Thu, 11 Sep 2008 09:39:48 +0530> Subject: [ADMIN] replica of database> > Hi all,> > Can any one tell me how to replicate a db.> > Regards> aftab> > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.> > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)> To make changes to your subscription:> http://www.postgresql.org/mailpref/pgsql-admin
MSN Technology brings you the latest on gadgets, gizmos and the new hits in the gaming market. Try it now!
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.
_________________________________________________________________
Search for videos of Bollywood, Hollywood, Mollywood and every other wood, only on Live.com
http://www.live.com/?scope=video&form=MICOAL=
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 05:22 Scott Marlowe <scott.marlowe@gmail.com>
parent: Joshua D. Drake <jd@commandprompt.com>
2 siblings, 1 reply; 14+ messages in thread
From: Scott Marlowe @ 2008-09-11 05:22 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Aftab Alam <AAlam@tsrdarashaw.com>; Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin
On Wed, Sep 10, 2008 at 10:52 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
> Aftab Alam wrote:
>>
>> Yes ,I want a replica of my db so that I can use it as failover
>>
>>
>> Version 7.3 linux AS release 4 update 6
>
> Version 7.3 is end of life and I don't know of *any* of the replication
> technologies that will work with it.
I think older versions of slony can talk to it, but I'd only use that
to upgrade in place to 8.3. I'm pretty sure you'd have to make a stop
at 8.0 or 8.1 along the way...
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 13:42 Rex Mabry <rexmabry@yahoo.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 14+ messages in thread
From: Rex Mabry @ 2008-09-11 13:42 UTC (permalink / raw)
To: pgsql-admin
Version 8.3 has pg_standby. Does anyone know how well that works for failover?
--- On Thu, 9/11/08, Scott Marlowe <scott.marlowe@gmail.com> wrote:
From: Scott Marlowe <scott.marlowe@gmail.com>
Subject: Re: [ADMIN] replica of database
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: "Aftab Alam" <AAlam@tsrdarashaw.com>, "Vishal Arora" <aroravishal22@hotmail.com>, "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Date: Thursday, September 11, 2008, 12:22 AM
On Wed, Sep 10, 2008 at 10:52 PM, Joshua D. Drake <jd@commandprompt.com>
wrote:
> Aftab Alam wrote:
>>
>> Yes ,I want a replica of my db so that I can use it as failover
>>
>>
>> Version 7.3 linux AS release 4 update 6
>
> Version 7.3 is end of life and I don't know of *any* of the
replication
> technologies that will work with it.
I think older versions of slony can talk to it, but I'd only use that
to upgrade in place to 8.3. I'm pretty sure you'd have to make a stop
at 8.0 or 8.1 along the way...
--
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] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 14:30 Chris Browne <cbbrowne@acm.org>
parent: Joshua D. Drake <jd@commandprompt.com>
2 siblings, 1 reply; 14+ messages in thread
From: Chris Browne @ 2008-09-11 14:30 UTC (permalink / raw)
To: pgsql-admin
jd@commandprompt.com ("Joshua D. Drake") writes:
> Aftab Alam wrote:
>> Yes ,I want a replica of my db so that I can use it as failover
>>
>>
>>
>> Version 7.3 linux AS release 4 update 6
>
> Version 7.3 is end of life and I don't know of *any* of the
> replication technologies that will work with it.
Slony-I version 1.1 can still work with 7.3. We ceased support of 7.3
when we released v1.2, but recommended, at the time, using 1.1 for
7.3-compatibility.
http://archives.postgresql.org/pgsql-announce/2006-10/msg00012.php
--
output = ("cbbrowne" "@" "linuxfinances.info")
http://linuxfinances.info/info/emacs.html
"A LISP programmer knows the value of everything, but the cost of
nothing." -- Alan J. Perlis
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 14:35 Andrew Sullivan <ajs@commandprompt.com>
parent: Joshua D. Drake <jd@commandprompt.com>
2 siblings, 1 reply; 14+ messages in thread
From: Andrew Sullivan @ 2008-09-11 14:35 UTC (permalink / raw)
To: pgsql-admin
On Wed, Sep 10, 2008 at 09:52:41PM -0700, Joshua D. Drake wrote:
> Version 7.3 is end of life and I don't know of *any* of the replication
> technologies that will work with it.
The 1.0.x Slony releases work with 7.3.x, x>2. I don't recommend
sticking with 7.3, however.
A
--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 15:11 Brad Nicholson <bnichols@ca.afilias.info>
parent: Andrew Sullivan <ajs@commandprompt.com>
0 siblings, 0 replies; 14+ messages in thread
From: Brad Nicholson @ 2008-09-11 15:11 UTC (permalink / raw)
To: pgsql-admin
On Thu, 2008-09-11 at 10:35 -0400, Andrew Sullivan wrote:
> On Wed, Sep 10, 2008 at 09:52:41PM -0700, Joshua D. Drake wrote:
> > Version 7.3 is end of life and I don't know of *any* of the replication
> > technologies that will work with it.
>
> The 1.0.x Slony releases work with 7.3.x, x>2. I don't recommend
> sticking with 7.3, however.
If you ignore this very wise advise, and stick with 7.3 and decide to
give Slony 1.0.x a shot, be prepared for lots of late nights rebuilding
replicas and dealing if a whole multitude of other bugs it had then.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 15:43 Scott Marlowe <scott.marlowe@gmail.com>
parent: Rex Mabry <rexmabry@yahoo.com>
0 siblings, 0 replies; 14+ messages in thread
From: Scott Marlowe @ 2008-09-11 15:43 UTC (permalink / raw)
To: rexmabry@yahoo.com; +Cc: pgsql-admin
On Thu, Sep 11, 2008 at 7:42 AM, Rex Mabry <rexmabry@yahoo.com> wrote:
> Version 8.3 has pg_standby. Does anyone know how well that works for
> failover?
pg_standby is part of the Point in time recovery suite, which can be
used to create a cold (recovery on comand) or warm standby (continuous
recovery) server ready to take over with a few commands. It's quite
different from slony, in that there's not hot read-only standby, so
there's no load balancing, however, it usually produces less load on
the master db, so that's a plus.
PITR is quite well tested and used in a lot of production
environments. It has very different design objectives than slony or
pgpool or pgbouncer, which all allow you to have multiple live servers
at once.
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 18:19 Scott Marlowe <scott.marlowe@gmail.com>
parent: Chris Browne <cbbrowne@acm.org>
0 siblings, 1 reply; 14+ messages in thread
From: Scott Marlowe @ 2008-09-11 18:19 UTC (permalink / raw)
To: Chris Browne <cbbrowne@acm.org>; +Cc: pgsql-admin
On Thu, Sep 11, 2008 at 8:30 AM, Chris Browne <cbbrowne@acm.org> wrote:
> jd@commandprompt.com ("Joshua D. Drake") writes:
>> Aftab Alam wrote:
>>> Yes ,I want a replica of my db so that I can use it as failover
>>>
>>>
>>>
>>> Version 7.3 linux AS release 4 update 6
>>
>> Version 7.3 is end of life and I don't know of *any* of the
>> replication technologies that will work with it.
>
> Slony-I version 1.1 can still work with 7.3. We ceased support of 7.3
> when we released v1.2, but recommended, at the time, using 1.1 for
> 7.3-compatibility.
>
And as buggy as slony 1.0 might have been, I ran it for about 2 years
in production replicating a HUGE amount of data daily with zero
failures. Of course, the servers were fast and reliable, so that might
have helped cover a lot of issues other people had for us.
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 20:02 Brad Nicholson <bnichols@ca.afilias.info>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 14+ messages in thread
From: Brad Nicholson @ 2008-09-11 20:02 UTC (permalink / raw)
To: pgsql-admin
On Thu, 2008-09-11 at 12:19 -0600, Scott Marlowe wrote:
> On Thu, Sep 11, 2008 at 8:30 AM, Chris Browne <cbbrowne@acm.org> wrote:
> > jd@commandprompt.com ("Joshua D. Drake") writes:
> >> Aftab Alam wrote:
> >>> Yes ,I want a replica of my db so that I can use it as failover
> >>>
> >>>
> >>>
> >>> Version 7.3 linux AS release 4 update 6
> >>
> >> Version 7.3 is end of life and I don't know of *any* of the
> >> replication technologies that will work with it.
> >
> > Slony-I version 1.1 can still work with 7.3. We ceased support of 7.3
> > when we released v1.2, but recommended, at the time, using 1.1 for
> > 7.3-compatibility.
> >
>
> And as buggy as slony 1.0 might have been, I ran it for about 2 years
> in production replicating a HUGE amount of data daily with zero
> failures. Of course, the servers were fast and reliable, so that might
> have helped cover a lot of issues other people had for us.
And when we ran it we had replica's getting corrupted due to bugs almost
weekly (based on a particular pattern of activity). The edges are
there. It did never lose data on us.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: replica of database
@ 2008-09-11 22:18 Chris Browne <cbbrowne@acm.org>
parent: Brad Nicholson <bnichols@ca.afilias.info>
0 siblings, 0 replies; 14+ messages in thread
From: Chris Browne @ 2008-09-11 22:18 UTC (permalink / raw)
To: pgsql-admin
bnichols@ca.afilias.info (Brad Nicholson) writes:
> On Thu, 2008-09-11 at 12:19 -0600, Scott Marlowe wrote:
>> On Thu, Sep 11, 2008 at 8:30 AM, Chris Browne <cbbrowne@acm.org> wrote:
>> > jd@commandprompt.com ("Joshua D. Drake") writes:
>> >> Aftab Alam wrote:
>> >>> Yes ,I want a replica of my db so that I can use it as failover
>> >>>
>> >>>
>> >>>
>> >>> Version 7.3 linux AS release 4 update 6
>> >>
>> >> Version 7.3 is end of life and I don't know of *any* of the
>> >> replication technologies that will work with it.
>> >
>> > Slony-I version 1.1 can still work with 7.3. We ceased support of 7.3
>> > when we released v1.2, but recommended, at the time, using 1.1 for
>> > 7.3-compatibility.
>>
>> And as buggy as slony 1.0 might have been, I ran it for about 2 years
>> in production replicating a HUGE amount of data daily with zero
>> failures. Of course, the servers were fast and reliable, so that might
>> have helped cover a lot of issues other people had for us.
>
> And when we ran it we had replica's getting corrupted due to bugs almost
> weekly (based on a particular pattern of activity). The edges are
> there. It did never lose data on us.
Mind you, that was on 7.4, not 7.3.
It's possible that:
a) 7.4 did new stuff, so that those index corruptions would not have been
present in 7.3, but also that
b) 7.3 might have "data-eating problems not present in 7.4."
I *would* suggest using 1.1.[latest], of Slony-I, as that should have
the fewest issues, on the Slony-I side, of any version available to
run against PG 7.3, and should work the most cleanly.
But on the other hand, I'd *also* strongly urge using this to get off
of v7.3 and onto something a LOT newer, ASAP. I think you can get to
PostgreSQL 8.1 using the 1.1 branch, which is usefully newer :-).
--
let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];;
http://www3.sympatico.ca/cbbrowne/unix.html
Economists are still trying to figure out why the girls with the least
principle draw the most interest.
^ permalink raw reply [nested|flat] 14+ messages in thread
end of thread, other threads:[~2008-09-11 22:18 UTC | newest]
Thread overview: 14+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-11 04:09 replica of database Aftab Alam <AAlam@tsrdarashaw.com>
2008-09-11 04:41 ` Vishal Arora <aroravishal22@hotmail.com>
2008-09-11 04:44 ` Aftab Alam <AAlam@tsrdarashaw.com>
2008-09-11 04:52 ` Joshua D. Drake <jd@commandprompt.com>
2008-09-11 05:22 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-09-11 13:42 ` Rex Mabry <rexmabry@yahoo.com>
2008-09-11 15:43 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-09-11 14:30 ` Chris Browne <cbbrowne@acm.org>
2008-09-11 18:19 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-09-11 20:02 ` Brad Nicholson <bnichols@ca.afilias.info>
2008-09-11 22:18 ` Chris Browne <cbbrowne@acm.org>
2008-09-11 14:35 ` Andrew Sullivan <ajs@commandprompt.com>
2008-09-11 15:11 ` Brad Nicholson <bnichols@ca.afilias.info>
2008-09-11 05:14 ` Vishal Arora <aroravishal22@hotmail.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