Re: Re: using LDAP for connection information lookup to do remote database connection

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Garry Chen <gc92(at)cornell(dot)edu>
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 16:50:18
Message-ID: 20170920165018.x2sx5xlhxdzvndep@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Garry Chen 2017-09-20 17:01:55 Re: Re: using LDAP for connection information lookup to do remote database connection
Previous Message Garry Chen 2017-09-20 15:51:15 Re: Re: using LDAP for connection information lookup to do remote database connection