1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
5
>The Password File</TITLE
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
15
TITLE="libpq - C Library"
16
HREF="libpq.html"><LINK
18
TITLE="Environment Variables"
19
HREF="libpq-envars.html"><LINK
21
TITLE="The Connection Service File"
22
HREF="libpq-pgservice.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
56
TITLE="Environment Variables"
57
HREF="libpq-envars.html"
66
TITLE="libpq - C Library"
83
TITLE="libpq - C Library"
92
TITLE="The Connection Service File"
93
HREF="libpq-pgservice.html"
108
>31.14. The Password File</A
114
> in a user's home directory or the
115
file referenced by <TT
118
> can contain passwords to
119
be used if the connection requires a password (and no password has been
120
specified otherwise). On Microsoft Windows the file is named
123
>%APPDATA%\postgresql\pgpass.conf</TT
128
> refers to the Application Data subdirectory in
132
> This file should contain lines of the following format:
162
Each of the first four fields can be a literal value, or
166
>, which matches anything. The password field from
167
the first line that matches the current connection parameters will be
168
used. (Therefore, put more-specific entries first when you are using
169
wildcards.) If an entry needs to contain <TT
176
>, escape this character with <TT
183
> matches both TCP (host name
187
>) and Unix domain socket (<TT
191
or the default socket directory) connections coming from the local
192
machine. In a standby server, a database name of <TT
196
matches streaming replication connections made to the master server.
200
> field is of limited usefulness because
201
users have the same password for all databases in the same cluster.
204
> On Unix systems, the permissions on <TT
208
disallow any access to world or group; achieve this by the command
211
>chmod 0600 ~/.pgpass</TT
212
>. If the permissions are less
213
strict than this, the file will be ignored. On Microsoft Windows, it
214
is assumed that the file is stored in a directory that is secure, so
215
no special permissions check is made.
223
SUMMARY="Footer navigation table"
234
HREF="libpq-envars.html"
252
HREF="libpq-pgservice.html"
262
>Environment Variables</TD
276
>The Connection Service File</TD
b'\\ No newline at end of file'