[GENERAL] Best Practices - Securing an Enterprise application using JBOSS & Postgres

What settings would you recommend for using postgres in an enterprise application together with jboss? there are numerous auth options (from the documentation): 19.3.1. Trust authentication 19.3.2. Password authenticati

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

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 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 e

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

t; > 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 : > > Hi, > > Is there a way to run psql -U user -d dbname -c "select.

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

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.

[GENERAL] using jboss with ident auth

Hi, I'm trying to use postgres with ident auth and jboss. here's my postgres files: pg_hba.conf: # TYPE DATABASEUSERCIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all ident map=vmap # IPv4