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

Hmm the PGUSER is not working:

(GC92@gmc013:/users/gc92)
> PGUSER=dmtools
(GC92@gmc013:/users/gc92)
> psql "service=pgrls"
Password: 
psql: FATAL:  password authentication failed for user "gc92"
FATAL:  password authentication failed for user "gc92"
(GC92@gmc013:/users/gc92)
> echo $PGUSER
dmtools
(GC92@gmc013:/users/gc92)

On 9/20/17, 11:43 AM, "Alvaro Herrera" <alvherre@alvh.no-ip.org> wrote:
   Garry Chen wrote:   >    > Hi Alb,   >     Is there a way to give a username and passwd at the connection time?
Anotherword, not to set the username in gp_server.conf file.  Because psql just used my OS login id as username When I
removethe username from pg_server.conf file.      Hi Garr,      You can use the PGUSER environment variable to set the
username,and a   .pgpass file (or another file pointed to by the PGPASSFILE environment   variable) to give a password.
    --    Álvaro Herrera                https://www.2ndQuadrant.com/   PostgreSQL Development, 24x7 Support, Remote
DBA,Training & Services   
 


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