| From: | Garry Chen <gc92(at)cornell(dot)edu> |
|---|---|
| To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | using LDAP for connection information lookup to do remote database connection |
| Date: | 2017-09-19 14:43:33 |
| Message-ID: | 74DBE4C2-D042-43C3-92DB-4EA4C009777B@cornell.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2017-09-19 15:04:42 | Re: using LDAP for connection information lookup to do remote database connection |
| Previous Message | NAGA MANOJ BANDARU | 2017-09-19 13:21:46 | Version of libxml2 and libxslt libraries bundled with PostgreSQL-9.6.2 |