| From: | Garry Chen <gc92(at)cornell(dot)edu> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Re: using LDAP for connection information lookup to do remote database connection |
| Date: | 2017-09-20 17:01:55 |
| Message-ID: | 149DA872-E802-4BF6-868A-5D74C6499CBB@cornell.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Alvaro,
It is not working.
(GC92(at)gmc013:/users/gc92)
> PGUSER=dmtools
(GC92(at)gmc013:/users/gc92)
> export PGUSER
(GC92(at)gmc013:/users/gc92)
> psql "service=pgrls"
Password:
psql: FATAL: password authentication failed for user "gc92"
FATAL: password authentication failed for user "gc92"
(GC92(at)gmc013:/users/gc92)
> psql --version
psql (PostgreSQL) 9.6.5
Garry
On 9/20/17, 12:50 PM, "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
Garry Chen wrote:
> Hmm the PGUSER is not working:
>
> (GC92(at)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/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2017-09-22 07:38:48 | Re: Re: using LDAP for connection information lookup to do remote database connection |
| Previous Message | Alvaro Herrera | 2017-09-20 16:50:18 | Re: Re: using LDAP for connection information lookup to do remote database connection |