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