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 <gszpetkow...@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.e...@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. >
