Re: [Postgres-xc-developers] Pacemaker RA for datanode/coordinator

I've heard another group is working together with Linux HA Japan to
provide XC RA's.

Sakata-san, could you provide related info if available?

Regards;
----------
Koichi Suzuki


2012/7/24 Nikhil Sontakke <ni...@st...>:
> Hi,
>
> So what's the latest status of these HA activities for PGXC?
>
> Like the coordinator/datanode agents being discussed here, do we have
> agents for GTM for example? Also is this happening in some open source
> group where we can participate and see the latest and greatest source
> changes?
>
> Regards,
> Nikhils
>
> On Mon, Jul 23, 2012 at 12:06 AM, Koichi Suzuki
> <ko...@in...> wrote:
>> Thanks.   I found the latter works for the master.
>> ---
>> Koichi
>>
>> On Mon, 23 Jul 2012 12:53:50 +0900
>> Michael Paquier <mic...@gm...> wrote:
>>
>>> > 2. select application_name,upper(state),upper(sync_state) from
>>> > pg_stat_replication;
>>> >
>>> > This does not work.  pg_stat_replication has zero row.
>>> >
>>> Because this is datanode slave, we don't have GTM connection or
>>> > snapshot.  This might be a cause of the problem 2, or we might have
>>> > blocked to update pg_stat_replication system catalog.
>>> >
>>> pg_stat_replication has by definition one row per wal sender process:
>>> http://www.postgresql.org/docs/9.1/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE
>>> AFAIK, slave has no wal sender processes running, so it is normal to see
>>> nothing on the slave side, all the data is on the master side. The data is
>>> only available on master, Am I missing smth?
>>> You might be able to see rows in pg_stat_replication on a slave if you use
>>> cascading replication however, but this feature is only available in 9.2.
>>> Also, in the case of XC, you can use EXECUTE DIRECT to get the information
>>> of pg_stat_replication from remote nodes, Coordinators and Datanodes
>>> included.
>>> --
>>> Michael Paquier
>>> http://michael.otacoo.com
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> Postgres-xc-developers mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>
>
> --
> StormDB - http://www.stormdb.com
> The Database Cloud
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers