HI Albe,Thank you very much, It is working now after few modifications on pg_service file.
Garry
On 9/19/17, 11:04 AM, "Albe Laurenz" <laurenz.albe@wien.gv.at> wrote:
Garry Chen wrote: > Is it passable to use LDAP for connection string lookup when try to > connect to remote
databaseusing psql? I have client install on my work station and my > LDAP entry for remote postgresql database
lookslike 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) You know that there has to be more
thanone line in the file? There is a complete example of a stanza at the bottom of
https://www.postgresql.org/docs/current/static/libpq-ldap.html In particular, the stanza has to begin with a line
inbrackets, like [mydatabase] Other than that, the LDAP URL looks fine. > When > > psql pgrls > psql:
couldnot 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
throughhow to? You'd have to call it like this: psql "service=mydatabase" (Assuming that you named the
servicecontrol file stanza "mydatabase".) Yours, Laurenz Albe
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice