Re: using jboss with ident auth

On 06/02/11 6:54 AM, eyal edri wrote:
> when i try to run any command that uses the xml file for auth, it
> failes with:
>
> FATAL: Ident authentication failed for user "postgres"

ident authentication means unix user "joe" can only authenticate as
postgres user/role "joe" (unless you set up an ident map, which imho is
a bit messy)

>
> when i use 'password' or 'md5' it works.
>
>
> btw, i would have used password or md5 if there was a away to run psql
> commands with password unattended (without password prompt..).
>

use a $HOME/.pgpass file

--
john r pierce                            N 37, W 123
santa cruz ca                         mid-left coast