Re: [ADMIN] Replication/Failover/HA solution

2003-07-30 Thread Ragnar =?unknown-8bit?q?Kj=F8rstad?=
On Wed, Jul 30, 2003 at 05:14:12PM +0200, Dani Oderbolz wrote: > >On Wed, Jul 30, 2003 at 01:10:06PM +0200, Dani Oderbolz wrote: > >If you read my post carefully you will actually see it's the _same_ > >possibility :) > > > >But DRDB is only part of the solution - you also need something like > >he

Re: [ADMIN] Replication/Failover/HA solution

2003-07-30 Thread Dani Oderbolz
Ragnar Kjørstad wrote: On Wed, Jul 30, 2003 at 01:10:06PM +0200, Dani Oderbolz wrote: If you read my post carefully you will actually see it's the _same_ possibility :) But DRDB is only part of the solution - you also need something like heartbeat to manage what node postgresql runs on. Um, sor

Re: [ADMIN] Replication/Failover/HA solution

2003-07-30 Thread Ragnar =?unknown-8bit?q?Kj=F8rstad?=
On Wed, Jul 30, 2003 at 01:10:06PM +0200, Dani Oderbolz wrote: > >One possibility is to run postgresql (regular postgresql - no patches > >required) controlled by heartbeat (http://www.linux-ha.org/) on two > >nodes. Heartbeat will then make sure that only one of the nodes are > >active at any time

Re: [ADMIN] Replication/Failover/HA solution

2003-07-30 Thread Dani Oderbolz
Ragnar Kjørstad wrote: On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote: I am having a hard time selecting a Replication/Failover/HA solution for PGSQL. What is troubling is the number of solutions available in various states of development. Does the fact that dbmirror and rserv

Re: [ADMIN] Replication/Failover/HA solution

2003-07-29 Thread Ragnar =?unknown-8bit?q?Kj=F8rstad?=
On Wed, Jul 30, 2003 at 01:55:00AM +0530, Rajesh Kumar Mallah wrote: > >One possibility is to run postgresql (regular postgresql - no patches > >required) controlled by heartbeat (http://www.linux-ha.org/) on two > >nodes. Heartbeat will then make sure that only one of the nodes are > >active at an

Re: [ADMIN] Replication/Failover/HA solution

2003-07-29 Thread Rajesh Kumar Mallah
Ragnar Kjørstad wrote: On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote: I am having a hard time selecting a Replication/Failover/HA solution for PGSQL. What is troubling is the number of solutions available in various states of development. Does the fact that dbmirror and rserv

Re: [ADMIN] Replication/Failover/HA solution

2003-07-29 Thread Ragnar =?unknown-8bit?q?Kj=F8rstad?=
On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote: > I am having a hard time selecting a Replication/Failover/HA solution for > PGSQL. What is troubling is the number of solutions available in various > states of development. Does the fact that dbmirror and rserv appear in > the con

Re: [ADMIN] Replication/Failover/HA solution

2003-07-23 Thread Andrew Sullivan
On Tue, Jul 22, 2003 at 03:49:00PM -0400, Renney Thomas wrote: > Does it just slightly depend on java or is the whole package developed > in java. At the moment, the trigger inside the database is C and the egine which does the replication is Java. > Either way I would love to see and test your

Re: [ADMIN] Replication/Failover/HA solution

2003-07-22 Thread Renney Thomas
Does it just slightly depend on java or is the whole package developed in java. I generally prefer solutions based on C and C++ because of the performance advantage and they are nice and compact and can be packaged up into a nice executable or shared library. I have had very bad experiences

Re: [ADMIN] Replication/Failover/HA solution

2003-07-22 Thread Andrew Sullivan
On Tue, Jul 22, 2003 at 05:25:28PM -0400, Andrew Biagioni wrote: > Sorry -- by "production", what release version do you mean? eRServer v1.0 A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <[EMAIL PROTECTED]>

Re: [ADMIN] Replication/Failover/HA solution

2003-07-22 Thread Santiago Matiz
Sorry, was an error... -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Santiago Matiz Enviado el: martes, 22 de julio de 2003 16:53 Para: Andrew Biagioni; [EMAIL PROTECTED]; Andrew Sullivan Asunto: Re: [ADMIN] Replication/Failover/HA solution psql [dbname

Re: [ADMIN] Replication/Failover/HA solution

2003-07-22 Thread Santiago Matiz
psql [dbname and various options] -f [filename] -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Andrew Biagioni Enviado el: martes, 22 de julio de 2003 16:25 Para: [EMAIL PROTECTED]; Andrew Sullivan Asunto: Re: [ADMIN] Replication/Failover/HA solution 7/22

Re: [ADMIN] Replication/Failover/HA solution

2003-07-22 Thread Andrew Biagioni
7/22/03 3:32:03 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote: >On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote: >> I am having a hard time selecting a Replication/Failover/HA solution for >> PGSQL. What is troubling is the number of solutions available in various >> states of deve

Re: [ADMIN] Replication/Failover/HA solution

2003-07-22 Thread Andrew Sullivan
On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote: > I am having a hard time selecting a Replication/Failover/HA solution for > PGSQL. What is troubling is the number of solutions available in various > states of development. Does the fact that dbmirror and rserv appear in > the con

[ADMIN] Replication/Failover/HA solution

2003-07-21 Thread Renney Thomas
I am having a hard time selecting a Replication/Failover/HA solution for PGSQL. What is troubling is the number of solutions available in various states of development. Does the fact that dbmirror and rserv appear in the contrib directory, mean that they should be looked upon with more legitim