| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Tommy Flewwelling <tommyflewwelling(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: The .pgpass file |
| Date: | 2007-11-07 18:41:50 |
| Message-ID: | 20071107184150.GC21788@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tommy Flewwelling wrote:
>
> Hello,
>
> How do I specify in the command-line to access the .pgpass file when
> creating a database?
You don't. If the file exists and has the correct permission, createdb
will read it. If the needed password is found, the connection will be
done without ever prompting the user.
FWIW the -W switch is useless. If createdb finds that the password is
needed, it will prompt the user even if -W is not specified. If
createdb finds that the password is not needed, then it won't prompt the
user.
(Note that none of this is actually createdb's feature. It is all done
by libpq internally.)
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2007-11-07 19:05:23 | Re: any way for ORDER BY x to imply NULLS FIRST in 8.3? |
| Previous Message | Alvaro Herrera | 2007-11-07 18:34:08 | Re: Npsql is much faster than ODBC ? |