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

Alvaro,
It is not working.

(GC92@gmc013:/users/gc92)
> PGUSER=dmtools
(GC92@gmc013:/users/gc92)
> export PGUSER
(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)
> psql --version
psql (PostgreSQL) 9.6.5


Garry

On 9/20/17, 12:50 PM, "Alvaro Herrera" <alvherre@alvh.no-ip.org> wrote:
   Garry Chen wrote:   > Hmm the PGUSER is not working:   >    > (GC92@gmc013:/users/gc92)   > > PGUSER=dmtools
Well,you need to "export" it (examples assume Bourne shell, but maybe   yours is tcsh or something different, so YMMV).
Either      PGUSER=dmtools   export PGUSER   psql "service=.."      or      export PGUSER=dmtools   psql "service=..."
   or      PGUSER=dmtools psql "service="..."      --    Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQLDevelopment, 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