I got it to work now. Thank you very much,
Garry
On 9/22/17, 3:38 AM, "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
Garry Chen wrote:
> 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.
Sure. Try something like:
$ psql "service=mydatabase user=mydbuser password=topsecret"
Yours,
Laurenz Albe