Re: hardcode password in connect string

2018-04-15 Thread Martín Marqués
El 15/04/18 a las 12:16, Raymond O'Donnell escribió: > On 15/04/18 12:35, Ricardo Martin Gomez wrote: >> Hello David, >> I think so, the parameter you need in psql command is -w mipassword. > > Sorry, this is not correct. -w causes psql *never* to prompt for a > password, and -W forces a password

Re: hardcode password in connect string

2018-04-15 Thread Guillaume Lelarge
2018-04-15 17:16 GMT+02:00 Raymond O'Donnell : > On 15/04/18 12:35, Ricardo Martin Gomez wrote: > >> Hello David, >> I think so, the parameter you need in psql command is -w mipassword. >> > > Sorry, this is not correct. -w causes psql *never* to prompt for a > password, and -W forces a password p

Re: hardcode password in connect string

2018-04-15 Thread Raymond O'Donnell
On 15/04/18 12:35, Ricardo Martin Gomez wrote: Hello David, I think so, the parameter you need in psql command is -w mipassword. Sorry, this is not correct. -w causes psql *never* to prompt for a password, and -W forces a password prompt. Neither allows the password to be passed as an argumen

Re: hardcode password in connect string

2018-04-15 Thread Ricardo Martin Gomez
s/ghei36> From: David Gauthier Sent: Friday, April 13, 2018 3:51:33 PM To: James Keener Cc: pgsql-generallists.postgresql.org Subject: Re: hardcode password in connect string PGPASSWORD env var works fine. Thanks ! On Fri, Apr 13, 2018 at 2:46 PM, James Keener mailto:j...@jimkeener.

Re: hardcode password in connect string

2018-04-13 Thread David Gauthier
PGPASSWORD env var works fine. Thanks ! On Fri, Apr 13, 2018 at 2:46 PM, James Keener wrote: > Is setting it as an environment variable an option? > https://www.postgresql.org/docs/9.1/static/libpq-envars.html > > Alternatively, a service file? https://www.postgresql.org/ > docs/9.0/static/libp

Re: hardcode password in connect string

2018-04-13 Thread Rob Sargent
On 04/13/2018 12:46 PM, James Keener wrote: Is setting it as an environment variable an option? https://www.postgresql.org/docs/9.1/static/libpq-envars.html Alternatively, a service file? https://www.postgresql.org/docs/9.0/static/libpq-pgservice.html Jim On April 13, 2018 2:43:01 PM EDT, D

Re: hardcode password in connect string

2018-04-13 Thread James Keener
Is setting it as an environment variable an option? https://www.postgresql.org/docs/9.1/static/libpq-envars.html Alternatively, a service file? https://www.postgresql.org/docs/9.0/static/libpq-pgservice.html Jim On April 13, 2018 2:43:01 PM EDT, David Gauthier wrote: >Hi: > >PG v9.5.2 on RHE