Re: [NOVICE] Re: using LDAP for connection information lookup to doremote database connection

Hi Alb,Is there a way to give a username and passwd at the connection time? Another word, not to set the username in
gp_server.conffile.  Because psql just used my OS login id as username When I remove the username from pg_server.conf
file.


Garry

On 9/19/17, 11:35 AM, "pgsql-novice-owner@postgresql.org on behalf of Garry Chen" <pgsql-novice-owner@postgresql.org on
behalfof gc92@cornell.edu> wrote:
 
   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
useLDAP for connection string lookup when try to       > connect to remote database using psql?  I have client install
onmy 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)             You know that there has to
bemore than one 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
aline in brackets, like       [mydatabase]              Other than that, the LDAP URL looks fine.              > When
   > > psql pgrls       > psql: could not connect to server: No such file or directory       >                 Is the
serverrunning locally and accepting       >                 connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?      >        > Can anyone guide me through how to?              You'd have to
callit like this:              psql "service=mydatabase"              (Assuming that you named the service control 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

 


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice