Re: [Postgres-xc-general] postgres xc cluster query

[Koichi S. <koi...@gm...>]

Monitoring a node status is another thing.   pgxc_ctl provides a means
to check the status of each component.   You should be careful to
check if GTM is alive.   If it's dead, then all the query will be
blocked.   I mean, before you try to check if a coordinator or a
datanode is alive, you should check if the GTM is alive.

Regards;
---
Koichi Suzuki


2014/1/14 Michael Paquier <mic...@gm...>:
> On Tue, Jan 14, 2014 at 12:15 AM, Ying He <yin...@ya...> wrote:
>> hi,
>>
>> I am new to postgres xc. Is there a psql command that can be issued to
>> coordinator to query the current cluster's coordinators and datanodes? I
>> followed the setup steps and did CREATE NODE for coordinator and data nodes
>> and they are up and running, just wonder whether a command exists that can
>> query the current NODE and its status.
> You can have a look at the list of nodes registered with that:
> SELECT * FROM pgxc_node;
> Regards,
> --
> Michael
>
> ------------------------------------------------------------------------------
> CenturyLink Cloud: The Leader in Enterprise Cloud Services.
> Learn Why More Businesses Are Choosing CenturyLink Cloud For
> Critical Workloads, Development Environments & Everything In Between.
> Get a Quote or Start a Free Trial Today.
> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general