Alvaro,
It is not working.
(GC92@gmc013:/users/gc92)
> PGUSER=dmtools
(GC92@gmc013:/users/gc92)
> export PGUSER
(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)
> psql --version
psql (PostgreSQL) 9.6.5
Garry
On 9/20/17, 12:50 PM, "Alvaro Herrera" <alvherre@alvh.no-ip.org> wrote:
Garry Chen wrote: > Hmm the PGUSER is not working: > > (GC92@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/
PostgreSQLDevelopment, 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