| From: | John DeSoi <jd(at)icx(dot)net> |
|---|---|
| To: | Dmitri Priimak <priimak(at)stanford(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: psql password prompt |
| Date: | 2004-09-25 17:38:00 |
| Message-ID: | A585DB36-0F19-11D9-838D-000A95B03262@icx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sep 25, 2004, at 12:48 PM, Dmitri Priimak wrote:
> There is one thing which somewhat annoys me, which is that psql always
> prompts me for a password.
> That makes it difficult for use in Makefile where I want to say 'make
> build_db', which would run psql for
> each stored procedure which needs to be updated. Is there a way to
> specify that password somehow in a
> command line like isql ( sybase cli client ) does?
You should be able to leave out the password altogether if you setup a
.pgpass file in your home directory.
http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html
Best,
John DeSoi, Ph.D.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | TroyGeek | 2004-09-25 21:26:35 | SMgrRelation hashtable corrupted |
| Previous Message | Peter Wullinger | 2004-09-25 17:23:13 | Re: psql password prompt |