Re: [Postgres-xc-general] postgres-xc 0.9.5: Do not have a GTM snapshot available / Failed to get pooled connection

[Lionel F. <lio...@gm...>]

Hello,

(from my own experience) ensure that nothing is blocking incoming
connections (like tcpwrappers => /etc/hosts.allow, /etc/hosts.deny, or
firewall). ACL of pg_ha.conf could be part of the solution there.

You could ensure everything is connected correctly by issuing 'netstat -apn'
on each node, and looking for ESTABLISHED connections from/to GTM port and
coordinator ports.

Regards

Lionel Frachon

2011/7/8 David Hartveld <dav...@me...>

> Hi all,
>
> I'm experimenting a bit with postgres-xc 0.9.5 on debian squeeze, with a
> build from the 0.9.5 sources. I think I've set up a cluster with three hw
> systems, two nodes (data node/coordinator each) and a gtm node, properly,
> following the installation manual.
>
> However, the data nodes complain when they are started, every so many
> seconds: "WARNING:  Do not have a GTM snapshot available". And when I
> connect to a coordinator and try to execute 'CREATE DATABASE mydb;', I get
> the message: "ERROR:  Failed to get pooled connections". I've attached the
> configuration files that I am using for coordinator and datanode (the
> difference between nodes 1 and 2 being only that pgxc_node_id is 1 and 2
> respectively). The GTM is started with "$GTM -x 628 -p 5000 -D $DATADIR -l
> $LOGFILE &".
>
> Any suggestions what I should do or try?
>
> Greetings,
> David
>
>
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>