Re: [Postgres-xc-developers] Detecting XC

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

If you're detecting a datanode, you can do like this from any
available coordinator through psql:

EXECUTE DIRECT ON (nodename) 'SELECT 1';

If it is successful, the datanode is connected to the coordinator and
GTM is up and running.

You can detect a coordinator in the same way as vanilla PostgreSQL through psql:

SELECT 1;

They work when GTM is up and the coordinator is connected to GTM.
Anyway, without GTM up and running, the cluster won't work.

Please note that pgxc_ctl monitor command goes directly to datanodes
because it configures all the components.

Regards;

---
Koichi Suzuki


2014-02-05 David E. Wheeler <da...@ju...>:
> PGXC Hackers,
>
> What is the simplest way to tell if the server one has connected to is XC? Try to call pgxc_version()? `SHOW gtm_host`? Or is there something else to check, maybe something that doesn't throw an exception?
>
> Thanks,
>
> David
> ------------------------------------------------------------------------------
> Managing the Performance of Cloud-Based Applications
> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
> Read the Whitepaper.
> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers