Garry Chen wrote:
> Hmm the PGUSER is not working:
>
> (GC92(at)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