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 15:43:42
Message-ID: 20170920154342.c4wkqzeih25xihud@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Garry Chen wrote:
>
> 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.conf file. Because psql just used my OS login id as username When I remove the 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

In response to

Responses

Browse pgsql-novice by date

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