Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-12-13 Thread Takatoshi MATSUO
Hello Serge 2011/12/13 Serge Dubrouski serge...@gmail.com: On Mon, Dec 12, 2011 at 5:32 AM, Takatoshi MATSUO matsuo@gmail.com wrote: Hello 2011/12/12 Serge Dubrouski serge...@gmail.com: On Thu, Dec 8, 2011 at 10:34 PM, Takatoshi MATSUO matsuo@gmail.com wrote: Hi Attila

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-12-12 Thread Takatoshi MATSUO
Hello 2011/12/12 Serge Dubrouski serge...@gmail.com: On Thu, Dec 8, 2011 at 10:34 PM, Takatoshi MATSUO matsuo@gmail.com wrote: Hi Attila 2011/12/8 Attila Megyeri amegy...@minerva-soft.com: Hi Takatoshi, One strange thing I noticed and could probably be improved. When there is

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-12-12 Thread Serge Dubrouski
On Mon, Dec 12, 2011 at 5:32 AM, Takatoshi MATSUO matsuo@gmail.comwrote: Hello 2011/12/12 Serge Dubrouski serge...@gmail.com: On Thu, Dec 8, 2011 at 10:34 PM, Takatoshi MATSUO matsuo@gmail.com wrote: Hi Attila 2011/12/8 Attila Megyeri amegy...@minerva-soft.com: Hi

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-12-11 Thread Serge Dubrouski
On Thu, Dec 8, 2011 at 10:34 PM, Takatoshi MATSUO matsuo@gmail.comwrote: Hi Attila 2011/12/8 Attila Megyeri amegy...@minerva-soft.com: Hi Takatoshi, One strange thing I noticed and could probably be improved. When there is data inconsistency, I have the following node properties:

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-12-08 Thread Attila Megyeri
[mailto:matsuo@gmail.com] Sent: 2011. november 28. 11:10 To: The Pacemaker cluster resource manager Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila 2011/11/28 Attila Megyeri amegy...@minerva-soft.com: Hi Takatoshi, I understand your point and I agree

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-12-08 Thread Takatoshi MATSUO
Hi Attila 2011/12/8 Attila Megyeri amegy...@minerva-soft.com: Hi Takatoshi, One strange thing I noticed and could probably be improved. When there is data inconsistency, I have the following node properties: * Node psql2: + default_ping_set : 100 +

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-28 Thread Attila Megyeri
: 2011. november 27. 11:07 To: The Pacemaker cluster resource manager Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila 2011/11/27 Attila Megyeri amegy...@minerva-soft.com: Hi Takatoshi, You were right, changing the shell to bash resolved the problem

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-28 Thread Takatoshi MATSUO
, Takatoshi MATSUO Bests, Attil -Original Message- From: Takatoshi MATSUO [mailto:matsuo@gmail.com] Sent: 2011. november 28. 2:10 To: The Pacemaker cluster resource manager Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila Primary can

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-27 Thread Attila Megyeri
To: The Pacemaker cluster resource manager Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila 2011/11/27 Attila Megyeri amegy...@minerva-soft.com: Hi Takatoshi, Thank you for coming back to me so quickly. In the /var/lib/pgsql there are the following files: PSQL1

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-27 Thread Takatoshi MATSUO
:17 To: The Pacemaker cluster resource manager Cc: Attila Megyeri Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila A quick snippet from the corosync.log Nov 23 05:43:05 psql1 pgsql[2845]: DEBUG: Checking right of master. Nov 23 05:43:05 psql1 pgsql

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-27 Thread Attila Megyeri
27. 11:07 To: The Pacemaker cluster resource manager Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila 2011/11/27 Attila Megyeri amegy...@minerva-soft.com: Hi Takatoshi, You were right, changing the shell to bash resolved the problem. The cluster now

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-27 Thread Takatoshi MATSUO
To: The Pacemaker cluster resource manager Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila 2011/11/27 Attila Megyeri amegy...@minerva-soft.com: Hi Takatoshi, You were right, changing the shell to bash resolved the problem. The cluster now started in sync mode

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-26 Thread Attila Megyeri
is appreciated! Regards, Attila -Original Message- From: Yoshiharu Mori [mailto:y-m...@sraoss.co.jp] Sent: 2011. november 25. 14:17 To: The Pacemaker cluster resource manager Cc: Attila Megyeri Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila A quick

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-26 Thread Takatoshi MATSUO
cluster resource manager Cc: Attila Megyeri Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila A quick snippet from the corosync.log Nov 23 05:43:05 psql1 pgsql[2845]: DEBUG: Checking right of master. Nov 23 05:43:05 psql1 pgsql[2845]: INFO: My data status

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-26 Thread Attila Megyeri
: Takatoshi MATSUO [mailto:matsuo@gmail.com] Sent: 2011. november 26. 18:27 To: The Pacemaker cluster resource manager Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila 1. Are there /var/lib/pgsql/xlog_note.0 , xlog_note.1, xlog_note.2 files

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-26 Thread Takatoshi MATSUO
. Regards, Takatoshi MATSUO Thanks, Attila -Original Message- From: Takatoshi MATSUO [mailto:matsuo@gmail.com] Sent: 2011. november 26. 18:27 To: The Pacemaker cluster resource manager Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-25 Thread Takatoshi MATSUO
Hi Attila 2011/11/24 Attila Megyeri amegy...@minerva-soft.com: Hi Takatoshi, All, Thanks for your reply. I see that you have invested significant effort in the development of the RA. I spent the last day trying to set up the RA, but without much success. My infrastructure is very similar

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-25 Thread Attila Megyeri
: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila 2011/11/24 Attila Megyeri amegy...@minerva-soft.com: Hi Takatoshi, All, Thanks for your reply. I see that you have invested significant effort in the development of the RA. I spent the last day trying to set up

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-25 Thread Attila Megyeri
resource manager Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila 2011/11/24 Attila Megyeri amegy...@minerva-soft.com: Hi Takatoshi, All, Thanks for your reply. I see that you have invested significant effort in the development of the RA. I spent the last

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-25 Thread Yoshiharu Mori
: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Takatoshi, I have restored the PSQL to run without corosync so I cannot send you the crm_mon output now. What I can tell for sure: - RA never promoted any of the nodes, no matter what the status was. It also did

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-25 Thread Attila Megyeri
Hi Yoshiharu, -Original Message- From: Yoshiharu Mori [mailto:y-m...@sraoss.co.jp] Sent: 2011. november 25. 14:17 To: The Pacemaker cluster resource manager Cc: Attila Megyeri Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila A quick snippet

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-23 Thread Attila Megyeri
: Takatoshi MATSUO [mailto:matsuo@gmail.com] Sent: 2011. november 17. 8:04 To: The Pacemaker cluster resource manager Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi All I create a RA for PosstgrSQL 9.1 Streaming Replication based on pgsql. RA https://github.com

[Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-16 Thread Attila Megyeri
Hi All, We have a two-node postgresql 9.1 system configured using streaming replicaiton (active/active with a read-only slave). We want to automate the failover process and I couldn't really find a resource agent that could do the job. All HA solutions for postgresql I have seen are based on a

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-16 Thread Florian Haas
Hi Attila, On 2011-11-16 10:27, Attila Megyeri wrote: Hi All, We have a two-node postgresql 9.1 system configured using streaming replicaiton(active/active with a read-only slave). We want to automate the failover process and I couldn’t really find a resource agent that could do the

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-16 Thread Attila Megyeri
Hi Florian, -Original Message- From: Florian Haas [mailto:flor...@hastexo.com] Sent: 2011. november 16. 11:49 To: The Pacemaker cluster resource manager Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed Hi Attila, On 2011-11-16 10:27, Attila Megyeri wrote

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-16 Thread Serge Dubrouski
replication failover - RA needed Hi Attila, On 2011-11-16 10:27, Attila Megyeri wrote: Hi All, We have a two-node postgresql 9.1 system configured using streaming replicaiton(active/active with a read-only slave). We want to automate the failover process and I couldn't really find

Re: [Pacemaker] Postgresql streaming replication failover - RA needed

2011-11-16 Thread Takatoshi MATSUO
] Postgresql streaming replication failover - RA needed Hi Attila, On 2011-11-16 10:27, Attila Megyeri wrote: Hi All, We have a two-node postgresql 9.1 system configured using streaming replicaiton(active/active with a read-only slave). We want to automate the failover process