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/
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