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

From: eyal edri <eyal(dot)edri(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to run psql without password prompt when using auth MD5/Password
Date: 2011-06-05 11:07:28
Message-ID: BANLkTikSxMQMBTMpBNNV6zxCJG+34UcZnA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Szpetkowski 2011-06-05 11:21:10 Re: how to run psql without password prompt when using auth MD5/Password
Previous Message piscesboy 2011-06-05 10:32:23 EnterpriseDB-xDBReplicationServer java process on OS X.