Hmm the PGUSER is not working:
(GC92@gmc013:/users/gc92)
> PGUSER=dmtools
(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)
> echo $PGUSER
dmtools
(GC92@gmc013:/users/gc92)
On 9/20/17, 11:43 AM, "Alvaro Herrera" <alvherre@alvh.no-ip.org> wrote:
Garry Chen wrote: > > Hi Alb, > Is there a way to give a username and passwd at the connection time?
Anotherword, not to set the username in gp_server.conf file. Because psql just used my OS login id as username When I
removethe 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