Обсуждение: The .pgpass file

Hello,

How do I specify in the command-line to access the .pgpass file when creating a database?

I would like to use ~/.pgpass instead of –W on the command line when creating a database (createdb) and was wondering the correct syntax.

For example,

I don’t want to have to include (-W):

C:\postgressql\bin>createdb -U postgres –p 5432 -W –E UTF8 myDatabase

and substitute it for ~/.pgpass or PGPASSFILE:

C:\postgressql\bin>createdb -U postgres –p 5432 ~/.pgpass –E UTF8 myDatabase

How do I inform the complier to extract the password from the file and not the prompt the user?

Any suggestions would be greatly appreciated.

Tommy_

Tommy Flewwelling <tommyflewwelling@hotmail.com> writes:
> How do I specify in the command-line to access the .pgpass file when creating a database?

Huh?  You don't specify anything, it's done automatically when needed.

> I don�t want to have to include (-W):
> C:\postgressql\bin>createdb -U postgres �p 5432 -W �E UTF8 myDatabase

You never have to include -W, whether you use .pgpass or not.  That
switch is only there for historical reasons.

            regards, tom lane

Am Mittwoch, 7. November 2007 schrieb Tommy Flewwelling:
> How do I inform the complier to extract the password from the file and not
> the prompt the user?

It does that automatically.  Just omit the -W option.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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