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

[Michael P. <mic...@gm...>]

Hi

On Fri, Jul 8, 2011 at 9: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".
>
This bug is related with autovacuum launcher which is not able to get a
valid snapshot from GTM. I am studying this test case and may have a fix for
that next week.

> 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 &".
>
Your configuration files look OK.
However, a datanode is a node that do not interact with other nodes through
a connection pooling, so you do not need to set data_node_hosts,
data_node_ports, pooler_port in its configuration file. num_data_nodes also
in unnecessary


> Any suggestions what I should do or try?
>
Have you started your nodes with -i option so as they accept TCP-IP
connections?
As Lionel said, pg_hba.conf setting is full of traps. You should check that
also.

Regards,
-- 
Michael Paquier
http://michael.otacoo.com