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.conf file. 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