[Postgres-xl-general] Misconfiguration?

Aaron Jackson ajackson at revionics.com
Wed Jun 18 13:06:56 PDT 2014


So, opening trust permissions in the datanode as follows seems to have worked.

host all all 192.168.24.0/24 trust

I’ll have to change my pgxc_ctl.conf accordingly to produce the correct result.

Thanks

Aaron
From: Mason Sharp [mailto:msharp at translattice.com]
Sent: Wednesday, June 18, 2014 2:45 PM
To: Aaron Jackson
Cc: postgres-xl-general at lists.sourceforge.net
Subject: Re: [Postgres-xl-general] Misconfiguration?



On Wed, Jun 18, 2014 at 2:57 PM, Aaron Jackson <ajackson at revionics.com<mailto:ajackson at revionics.com>> wrote:

I also have local changes to the coordinator pg_hba.conf that are not included in the datanode’s version of pg_hba.conf.  It wasn’t clear if identity delegation and authorization was also required at the datanode.  In any event, I’ll try a localized change there.  Here is my pg_hba.conf on my coordinator …

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32<http://127.0.0.1/32>            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     postgres                                trust
#host    replication     postgres        127.0.0.1/32<http://127.0.0.1/32>            trust
#host    replication     postgres        ::1/128                 trust
#=================================================
# Addition at initialization, 20140618_18:37:04
#================================================
# Added to all the pg_hba.conf
# Original: coordExtraPgHba
host    all             postgres        x.y.z.0/24           trust
host    all             all             x.y.z.0/24           trust
host    all             all             0.0.0.0/0<http://0.0.0.0/0>               pam
host    all             all             0.0.0.0/0<http://0.0.0.0/0>               password
host all postgres 10.11.19.0/24<http://10.11.19.0/24> trust
# End of addition

I realize all those entries may not make sense – I was tinkering to see if I could find combinations that were causing the problem.  The last entry is the one that pgxc_ctl adds by default.   And I’ve removed the actual subnet.

Aaron
From: Aaron Jackson [mailto:ajackson at revionics.com<mailto:ajackson at revionics.com>]
Sent: Wednesday, June 18, 2014 1:48 PM
To: postgres-xl-general at lists.sourceforge.net<mailto:postgres-xl-general at lists.sourceforge.net>
Subject: [Postgres-xl-general] Misconfiguration?

I have some experience building a postgres-xc cluster using pgxc_ctl, so I have done a similar job building a postgres-xl cluster.  I have a 3 node setup, with 1 coordinator, 1 datanode and 1 gtm proxy on each device.  Postgres-XL was built using the intel compiler due to previous runtime issues building optimizing versions with GCC.

I build the cluster using “pgxc_ctl init all” which works fine.  And then proceed to build a database.  If I do this as the user/role postgres, everything is fine, but if I do this as my local user, it fails with “ERROR:  Failed to get pooled connections” – I am hoping that this is simply a misconfiguration on my part.  For compatibility, I set my coordPorts to 5432 and my poolerPorts to 6432.

Checking listening sockets, indicated a listener on port 5432 but nothing listening on 6432.

Any  thoughts on what I might have misconfigured?

Aaron


It is good that pgxc_ctl init all worked. Note that pooler ports must be included in the datanodes in Postgres-XL, which also means datanodes need access to other datanodes.

It sounds like a pg_hba.conf issue, but the line

host    all             all             x.y.z.0/24           trust

should take care of it, if that is your actual subnet. Does it work if you use

host all all 10.11.19.0/24<http://10.11.19.0/24> trust

?



--
Mason Sharp

TransLattice - http://www.translattice.com
Distributed and Clustered Database Solutions

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20140618/4fd192b3/attachment.htm>


More information about the postgres-xl-general mailing list