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

[Abbas B. <abb...@te...>]

Hi,
I noticed that you have given 2 as pgxc_node_id in both the files you have
attached. Please make sure you have given different numbers to all the 4
nodes.

Another suggestion from my side will be to give IP address of GTM instead of
host name pg-db-01.

Regards
Abbas

On Fri, Jul 8, 2011 at 5:04 PM, David Hartveld <dav...@me...>wrote:

> 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
>
>