Re: [Linux-ha-dev] [PATCH] manage PostgreSQL 9.0 streaming replication using Master/Slave

2011-02-07 Thread Florian Haas
On 2011-02-07 17:44, Serge Dubrouski wrote: > Hello - > > First of all thanks for doing this. It's definitely a neat option to > have. Unfortunately I haven't yet worked with ProstgreSQL 9.0. Could > you please elaborate little bit more on how it works? What happens if > master dies? Who is respon

Re: [Linux-ha-dev] [PATCH] manage PostgreSQL 9.0 streaming replication using Master/Slave

2011-02-07 Thread Serge Dubrouski
Hello - First of all thanks for doing this. It's definitely a neat option to have. Unfortunately I haven't yet worked with ProstgreSQL 9.0. Could you please elaborate little bit more on how it works? What happens if master dies? Who is responsible for creating/deleting recovery.conf file? Also pl

Re: [Linux-ha-dev] New master/slave resource agent for DB2 databases in HADR (High Availability Disaster Recovery) mode

2011-02-07 Thread Holger Teutsch
On Mon, 2011-02-07 at 12:31 +0100, Dejan Muhamedagic wrote: > On Mon, Feb 07, 2011 at 12:27:38PM +0100, Holger Teutsch wrote: > > On Mon, 2011-02-07 at 11:46 +0100, Florian Haas wrote: > > > On 2011-02-07 11:38, Holger Teutsch wrote: > > > > [...] > > > > As conclusion: > > > > 1) > > > > R

[Linux-ha-dev] [PATCH] manage PostgreSQL 9.0 streaming replication using Master/Slave

2011-02-07 Thread Takatoshi MATSUO
Hello I wrote a patch for pgsql RA to manage PostgreSQL 9.0 streaming replication(PGSR) which is new feature in Postgres 9.0. I add new parameters, "rep_mode", "trigger_file" and "tmpdir". "rep_mode" means replication mode Default is "none" which do the same thing as before. You have to set "asy

Re: [Linux-ha-dev] New master/slave resource agent for DB2 databases in HADR (High Availability Disaster Recovery) mode

2011-02-07 Thread Dejan Muhamedagic
On Mon, Feb 07, 2011 at 12:27:38PM +0100, Holger Teutsch wrote: > On Mon, 2011-02-07 at 11:46 +0100, Florian Haas wrote: > > On 2011-02-07 11:38, Holger Teutsch wrote: > > > [...] > > > As conclusion: > > > 1) > > > Rolling HADR into the existing agent seems impossible to me or > > >

Re: [Linux-ha-dev] New master/slave resource agent for DB2 databases in HADR (High Availability Disaster Recovery) mode

2011-02-07 Thread Dejan Muhamedagic
Hi Holger, On Mon, Feb 07, 2011 at 11:38:10AM +0100, Holger Teutsch wrote: > On Mon, 2011-02-07 at 08:42 +0100, Florian Haas wrote: > > Hello Holger, > > > > that would be excellent functionality to have, thanks very much for the > > contribution! Is there any chance this could be rolled into the

Re: [Linux-ha-dev] New master/slave resource agent for DB2 databases in HADR (High Availability Disaster Recovery) mode

2011-02-07 Thread Holger Teutsch
On Mon, 2011-02-07 at 11:46 +0100, Florian Haas wrote: > On 2011-02-07 11:38, Holger Teutsch wrote: > > [...] > > As conclusion: > > 1) > > Rolling HADR into the existing agent seems impossible to me or > > at least will end in a pollution of if and case statement and > > ov

Re: [Linux-ha-dev] New master/slave resource agent for DB2 databases in HADR (High Availability Disaster Recovery) mode

2011-02-07 Thread Florian Haas
On 2011-02-07 11:38, Holger Teutsch wrote: > [...] > As conclusion: > 1) > Rolling HADR into the existing agent seems impossible to me or > at least will end in a pollution of if and case statement and > over complex logic. > > 2) > Adding support for a standard dat

Re: [Linux-ha-dev] New master/slave resource agent for DB2 databases in HADR (High Availability Disaster Recovery) mode

2011-02-07 Thread Holger Teutsch
On Mon, 2011-02-07 at 08:42 +0100, Florian Haas wrote: > Hello Holger, > > that would be excellent functionality to have, thanks very much for the > contribution! Is there any chance this could be rolled into the existing > db2 agent? You could use the ocf_is_ms() function to detect whether the >