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
Hello
2011/12/12 Serge Dubrouski :
>
>
> On Thu, Dec 8, 2011 at 10:34 PM, Takatoshi MATSUO
> wrote:
>>
>> Hi Attila
>>
>> 2011/12/8 Attila Megyeri :
>> > Hi Takatoshi,
>> >
>> > One strange thing I noticed and could probably be improved.
>> > When there is data inconsistency, I have the following
On Mon, Dec 12, 2011 at 5:32 AM, Takatoshi MATSUO wrote:
> Hello
>
> 2011/12/12 Serge Dubrouski :
> >
> >
> > On Thu, Dec 8, 2011 at 10:34 PM, Takatoshi MATSUO
> > wrote:
> >>
> >> Hi Attila
> >>
> >> 2011/12/8 Attila Megyeri :
> >> > Hi Takatoshi,
> >> >
> >> > One strange thing I noticed and co
Hello Serge
2011/12/13 Serge Dubrouski :
>
>
> On Mon, Dec 12, 2011 at 5:32 AM, Takatoshi MATSUO
> wrote:
>>
>> Hello
>>
>> 2011/12/12 Serge Dubrouski :
>> >
>> >
>> > On Thu, Dec 8, 2011 at 10:34 PM, Takatoshi MATSUO
>> > wrote:
>> >>
>> >> Hi Attila
>> >>
>> >> 2011/12/8 Attila Megyeri :
>> >>
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 coul
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
On Wed, Nov 16, 2011 at 12:55 PM, Attila Megyeri
wrote:
> 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
nager
>> Subject: Re: [Pacemaker] 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
t;rsc_location-2-rule-2" $role="master" -inf: defined
fail-count-vip-rep \
rule $id="rsc_location-2-rule-3" -inf: not_defined default_ping_set or
default_ping_set lt 100
colocation rsc_colocation-1 inf: msPostgresql clnPingCheck
colocation rsc_colocation-2 inf:
Hi Attila
2011/11/24 Attila Megyeri :
> 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 to yours, except fo
: The Pacemaker cluster resource manager
Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed
Hi Attila
2011/11/24 Attila Megyeri :
> Hi Takatoshi, All,
>
> Thanks for your reply.
> I see that you have invested significant effort in the development of the RA.
m]
Sent: 2011. november 25. 8:56
To: The Pacemaker cluster resource manager
Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed
Hi Attila
2011/11/24 Attila Megyeri :
> Hi Takatoshi, All,
>
> Thanks for your reply.
> I see that you have invested significant effor
r 25. 9:28
> To: The Pacemaker cluster resource manager
> Subject: Re: [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 ca
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 snip
is running as a hot
standby.
Any help 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 rep
ion :
> 1900
> Nov 26 13:36:33 psql1 pgsql[20176]: INFO: psql2 xlog location :
> 1900
> Nov 26 13:36:41 psql1 pgsql[20343]: DEBUG: PostgreSQL is running as a hot
> standby.
>
>
> Any help is appreciated!
>
> Regards,
> Attila
>
>
>
: 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?
These
gt;> Nov 23 05:43:05 psql1 pgsql[2845]: INFO: psql1 xlog location :
>>> 0D00 Nov 23 05:43:05 psql1 pgsql[2845]: INFO: psql2 xlog
>>> location : 00000800
>>>
>>> As you see, the "my data status" returns an empty string.
>>
>&g
Pacemaker cluster resource manager
Subject: Re: [Pacemaker] Postgresql streaming replication failover - RA needed
Hi Attila
2011/11/27 Attila Megyeri :
> Hi Takatoshi,
>
> Thank you for coming back to me so quickly.
>
> In the /var/lib/pgsql there are the following files:
>
> PSQL1:
>> created that directory and i keep some of the files there.
>
> It's no ploblem.
> If you want to change this path, please specify it using "tmpdir" parameter.
>
> Regards,
> Takatoshi MATSUO
>
>>
>> Thanks,
>> Attila
>>
>&g
[mailto:matsuo@gmail.com]
Sent: 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 :
> Hi Takatoshi,
>
> You were right, changing the shell to bash resolved t
ov 27 16:03:27 psql1 pgsql[12204]: ERROR: My data is inconsistent.
> Nov 27 16:03:27 psql1 pgsql[12339]: DEBUG: notify: post for start
> Nov 27 16:03:27 psql1 pgsql[12373]: DEBUG: notify: pre for stop
> Nov 27 16:03:27 psql1 pgsql[12407]: INFO: PostgreSQL is already stopped.
>
>
> Tha
2300 Nov 27 16:03:27 psql1
> pgsql[12204]: ERROR: My data is inconsistent.
> Nov 27 16:03:27 psql1 pgsql[12339]: DEBUG: notify: post for start Nov
> 27 16:03:27 psql1 pgsql[12373]: DEBUG: notify: pre for stop Nov 27
> 16:03:27 psql1 pgsql[12407]: INFO: PostgreSQL is already st
t at all. Don't mention it.
Regards,
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] Post
ATSUO [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 :
> Hi Takatoshi,
>
> I understand your point and I agree that the correct b
Hi Attila
2011/12/8 Attila Megyeri :
> 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
>+ master-postgresql:1 :
On Thu, Dec 8, 2011 at 10:34 PM, Takatoshi MATSUO wrote:
> Hi Attila
>
> 2011/12/8 Attila Megyeri :
> > 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:
> >+ defau
27 matches
Mail list logo
