Postgres Pro
Downloads
Home   >   mailing lists

[NOVICE] using LDAP for connection information lookup to do remote databaseconnection - Mailing list pgsql-novice

From Garry Chen
Subject [NOVICE] using LDAP for connection information lookup to do remote databaseconnection
Date
Msg-id 74DBE4C2-D042-43C3-92DB-4EA4C009777B@cornell.edu
Whole thread Raw
Responses [NOVICE] Re: using LDAP for connection information lookup to do remotedatabase connection
List pgsql-novice
Tree view

Hi all,

                Is it passable to use LDAP for connection string lookup when try to connect to remote database using psql?  I have client install on my work station and my LDAP entry for remote postgresql database looks like this:

cn=pgrls,cn=OracleContext

cn=pgrls

objectclass=orclDBServer

objectclass=top

objectclass=orclService

description=host=pgrls.cy53k5nd.us-east-1.rds.amazonaws.com

description=port=5439

description=dbname=pgrls

 

And my .pg_service.conf

ldap://oid.ldap.cornell.edu:389:636/cn=OracleContext?description?one?(cn=pgrls)

 

When

> psql pgrls

psql: could not connect to server: No such file or directory

                Is the server running locally and accepting

                connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

 

Can anyone guide me through how to?

 

Thank you very much,

Garry

pgsql-novice by date:

Previous
From: NAGA MANOJ BANDARU
Date:
Subject: [NOVICE] Version of libxml2 and libxslt libraries bundled with PostgreSQL-9.6.2
Next
From: Albe Laurenz
Date:
Subject: [NOVICE] Re: using LDAP for connection information lookup to do remotedatabase connection