Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-23 Thread Shane Ambler
Jan Otto wrote: Hi Mathias, On Aug 22, 2008, at 8:35 AM, Mathias Stjernström wrote: I Agree with Robert but i never heard of Cybercluster before. Does anyone have any experience with Cybercluster? It sounds really interesting! Some months ago i took a look into cybercluster. At that point

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-22 Thread Jan Otto
Hi Mathias, On Aug 22, 2008, at 8:35 AM, Mathias Stjernström wrote: I Agree with Robert but i never heard of Cybercluster before. Does anyone have any experience with Cybercluster? It sounds really interesting! Some months ago i took a look into cybercluster. At that point cybercluster wa

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-22 Thread Peter Eisentraut
Dan Harris wrote: > My desire would be to have a parallel server that could act as a hot > standby system with automatic fail over in a multi-master role. I will add my "me too" for DRBD + Heartbeat. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread Mathias Stjernström
I Agree with Robert but i never heard of Cybercluster before. Does anyone have any experience with Cybercluster? It sounds really interesting! Best regards, Mathias Stjernström http://www.pastbedti.me/ On 22 aug 2008, at 08.18, RW wrote: My company finally has the means to install a new

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread Mathias Stjernström
Yup, but sometimes you are not in charge of the DDL changes. You may have many different users that make changes or for example if you are working with Ruby On Rails you have something thats called Migrations that handles all DDL changes in those situations it can get really complicated wit

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread RW
My company finally has the means to install a new database server for replication. I have Googled and found a lot of sparse information out there regarding replication systems for PostgreSQL and a lot of it looks very out-of-date. Can I please get some ideas from those of you that are curre

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread Joshua Drake
On Thu, 21 Aug 2008 17:54:11 -0400 Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Joshua Drake wrote: > > On Thu, 21 Aug 2008 23:21:26 +0200 > > Mathias Stjernström <[EMAIL PROTECTED]> wrote: > > > > > Yes thats true. It does support DDL changes but not in a > > > automatic way. You have to execute

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread david
On Thu, 21 Aug 2008, Mathias Stjernstr?m wrote: Hi Dan! Its true, many of the replication options that exists for PostgreSQL have not seen any updates in a while. If you only looking for redundancy and not a performance gain you should look at PostgreSQL PITR (http://www.postgresql.org/doc

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread Alvaro Herrera
Joshua Drake wrote: > On Thu, 21 Aug 2008 23:21:26 +0200 > Mathias Stjernström <[EMAIL PROTECTED]> wrote: > > > Yes thats true. It does support DDL changes but not in a automatic > > way. You have to execute all DDL changes with a separate script. > > > > What's the status of > > http://www.com

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread Alan Hodgson
On Thursday 21 August 2008, salman <[EMAIL PROTECTED]> wrote: > Mathias Stjernström wrote: > > Yes thats true. It does support DDL changes but not in a automatic way. > > You have to execute all DDL changes with a separate script. > > That's true, but it's quite simple to do with the provided perl

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread salman
Mathias Stjernström wrote: Yes thats true. It does support DDL changes but not in a automatic way. You have to execute all DDL changes with a separate script. That's true, but it's quite simple to do with the provided perl script(s) - slonik_execute_script. I've had to make use of it a few

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread Joshua Drake
On Thu, 21 Aug 2008 23:21:26 +0200 Mathias Stjernström <[EMAIL PROTECTED]> wrote: > Yes thats true. It does support DDL changes but not in a automatic > way. You have to execute all DDL changes with a separate script. > > What's the status of > http://www.commandprompt.com/products/mammothrepli

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread Mathias Stjernström
Yes thats true. It does support DDL changes but not in a automatic way. You have to execute all DDL changes with a separate script. What's the status of http://www.commandprompt.com/products/mammothreplicator/ ? Best regards, Mathias http://www.pastbedti.me/ On 21 aug 2008, at 23.04, And

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread Alan Hodgson
On Thursday 21 August 2008, Dan Harris <[EMAIL PROTECTED]> wrote: > Especially since we make frequent use of sequences in our databases. If > MM is too difficult, I'm willing to accept a hot-standby read-only > system that will handle queries until we can fix whatever ails the > master. A heartbe

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread Andrew Sullivan
On Thu, Aug 21, 2008 at 10:53:05PM +0200, Mathias Stjernström wrote: > For Master-Slave replication i think that Slony http://www.slony.info/ is > most up to date. But it does not support DDL changes. This isn't quite true. It supports DDL; it just doesn't support it in the normal way, and is b

Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread Mathias Stjernström
Hi Dan! Its true, many of the replication options that exists for PostgreSQL have not seen any updates in a while. If you only looking for redundancy and not a performance gain you should look at PostgreSQL PITR (http://www.postgresql.org/docs/8.1/static/backup-online.html ) For Master-S

[PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread Dan Harris
My company finally has the means to install a new database server for replication. I have Googled and found a lot of sparse information out there regarding replication systems for PostgreSQL and a lot of it looks very out-of-date. Can I please get some ideas from those of you that are current