1

I have configured two gtm (gtm1,gtm2) in two different machine using postgres-xc. And configured coordinator1,datanode1 in gtm1 machine and coordinator2, datanode2 in gtm2 machine.

I have logged in both coordinator servers and created the datanode1 and datanode2 in both server. When I try to create the tables using the both node I am getting the error:

Failed to get Pooled connection

and when I check the datanode1 log file found the error like this:

unexpected EOF on client connection

halfer
  • 19,824
  • 17
  • 99
  • 186
Rajasekaran M
  • 163
  • 2
  • 16
  • When i try to add table after removing the datanode2 and coordinator2 in coordinator1, able to create the table, same for coordinator1. – Rajasekaran M Sep 24 '15 at 06:56

1 Answers1

1

The max_pool_size, max_connections and max_prepared_transactions parameters need to be set differently on coordinator and data nodes. On coordinators max_pool_size should be at least max_connections multiplied by the total number of data nodes (see Postgres-XL Specific Parameters and Starting Postgres-XL Cluster)

mdh
  • 5,355
  • 5
  • 26
  • 33