Re: [NOVICE] Re: using LDAP for connection information lookup to doremote database connection - Mailing list 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.conffile.  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


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