[Postgres-xc-bugs] ERROR: 'Failed to get pooled connections' with md5 authentication in datanodes

[Javier H. <jhe...@ce...>]

Hello,

============================================================================
                         POSTGRES-XC BUG REPORT TEMPLATE
============================================================================

Your name               : Javier Hernandez
Your email address      :jhe...@ce...


System Configuration:
---------------------
   Architecture        : Intel Xeon

   Operating System    :  Debian 7.1

   Postgres-XC version :  Postgres-XC 1.1

   Compiler used       : gcc 4.7.2


Please enter a FULL description of your problem:
------------------------------------------------


I have a cluster with 2 datanodes and 1 coordinator, all of them have configured with 'md5' as the authentication method in pg_hba.conf.
I have a user with the same name and password in each of the nodes and I can access (psql) individually to each node
but I can't execute any SQL sentence in the coordinator*ERROR:  Failed to get pooled connections*.
Changing to 'trust' authentication method in datanodes avoids the error but I need to secure the datanodes. Cretating a user with CREATE ROLE
in the coordinator and switch to 'md5' still fails, even using the new role.

According to the documentation it seems it should be supported.


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------*


Thank you,

-- 
Javier Hernández
Ingeniero de Bases de Datos
Centro de Estudios de Fisica del Cosmos de Aragon (ceFca)
http://www.cefca.es
Plza San Juan Nº 1, Planta 2ª
E-44001 Teruel (Spain)
Phone: +34 978 221266 Ext.1105
Fax:   +34 978 611801