Thread: how to run psql without password prompt when using auth MD5/Password

how to run psql without password prompt when using auth MD5/Password

From
eyal edri
Date:
Hi,

Is there a way to run psql -U user -d dbname -c "select....." 

without the psql asking for a password prompt from the user? 

when setting the pg_hba.conf file to use md5 or password.

(btw, i've tried using ident, but couldn't make it work with jboss).

thanks!

Eyal.

Re: how to run psql without password prompt when using auth MD5/Password

From
Grzegorz Szpetkowski
Date:
Sure,


http://stackoverflow.com/questions/6216432/windows-psql-command-line-is-there-a-way-to-allow-for-passwordless-login/6216838#6216838

Regards,
Grzegorz Szpetkowski

2011/6/5 eyal edri <eyal.edri@gmail.com>:
> Hi,
> Is there a way to run psql -U user -d dbname -c "select....."
> without the psql asking for a password prompt from the user?
> when setting the pg_hba.conf file to use md5 or password.
> (btw, i've tried using ident, but couldn't make it work with jboss).
> thanks!
> Eyal.

of course trust is a way :)

but i need a more secure way, as my company requires.. like md5.
only i want to be able to enter the password in the command line and not be promoted (so a script can do it).

eyal

On Sun, Jun 5, 2011 at 2:21 PM, Grzegorz Szpetkowski <gszpetkowski@gmail.com> wrote:
Sure,

http://stackoverflow.com/questions/6216432/windows-psql-command-line-is-there-a-way-to-allow-for-passwordless-login/6216838#6216838

Regards,
Grzegorz Szpetkowski

2011/6/5 eyal edri <eyal.edri@gmail.com>:
> Hi,
> Is there a way to run psql -U user -d dbname -c "select....."
> without the psql asking for a password prompt from the user?
> when setting the pg_hba.conf file to use md5 or password.
> (btw, i've tried using ident, but couldn't make it work with jboss).
> thanks!
> Eyal.

sorry, didn't saw the other option.

setting PGPASSWORD does the trick, even with md5.

thanks!! 

E.

On Sun, Jun 5, 2011 at 2:28 PM, eyal edri <eyal.edri@gmail.com> wrote:
of course trust is a way :)

but i need a more secure way, as my company requires.. like md5.
only i want to be able to enter the password in the command line and not be promoted (so a script can do it).

eyal


On Sun, Jun 5, 2011 at 2:21 PM, Grzegorz Szpetkowski <gszpetkowski@gmail.com> wrote:
Sure,

http://stackoverflow.com/questions/6216432/windows-psql-command-line-is-there-a-way-to-allow-for-passwordless-login/6216838#6216838

Regards,
Grzegorz Szpetkowski

2011/6/5 eyal edri <eyal.edri@gmail.com>:
> Hi,
> Is there a way to run psql -U user -d dbname -c "select....."
> without the psql asking for a password prompt from the user?
> when setting the pg_hba.conf file to use md5 or password.
> (btw, i've tried using ident, but couldn't make it work with jboss).
> thanks!
> Eyal.