I686LINUX/util/I686LINUX/doc/postgresql/html/libpq-pgpass.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >The Password File</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 Documentation"
  13 HREF="index.html"><LINK
  14 REL="UP"
  15 TITLE="libpq - C Library"
  16 HREF="libpq.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="Environment Variables"
  19 HREF="libpq-envars.html"><LINK
  20 REL="NEXT"
  21 TITLE="Behavior in Threaded Programs"
  22 HREF="libpq-threading.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="SECT1"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="libpq-envars.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="libpq.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 >Chapter 27. <SPAN
  68 CLASS="APPLICATION"
  69 >libpq</SPAN
  70 > - C Library</TD
  71 ><TD
  72 WIDTH="10%"
  73 ALIGN="right"
  74 VALIGN="top"
  75 ><A
  76 HREF="libpq.html"
  77 >Fast Forward</A
  78 ></TD
  79 ><TD
  80 WIDTH="10%"
  81 ALIGN="right"
  82 VALIGN="top"
  83 ><A
  84 HREF="libpq-threading.html"
  85 ACCESSKEY="N"
  86 >Next</A
  87 ></TD
  88 ></TR
  89 ></TABLE
  90 ><HR
  91 ALIGN="LEFT"
  92 WIDTH="100%"></DIV
  93 ><DIV
  94 CLASS="SECT1"
  95 ><H1
  96 CLASS="SECT1"
  97 ><A
  98 NAME="LIBPQ-PGPASS"
  99 >27.11. The Password File</A
 100 ></H1
 101 ><A
 102 NAME="AEN21881"
 103 ></A
 104 ><A
 105 NAME="AEN21883"
 106 ></A
 107 ><P
 108 >The file <TT
 109 CLASS="FILENAME"
 110 >.pgpass</TT
 111 > in a user's home directory is a file
 112 that can contain passwords to be used if the connection requires a
 113 password (and no password has been specified otherwise).
 114 This file should have lines of the following format:
 115 </P><PRE
 116 CLASS="SYNOPSIS"
 117 ><VAR
 118 CLASS="REPLACEABLE"
 119 >hostname</VAR
 120 >:<VAR
 121 CLASS="REPLACEABLE"
 122 >port</VAR
 123 >:<VAR
 124 CLASS="REPLACEABLE"
 125 >database</VAR
 126 >:<VAR
 127 CLASS="REPLACEABLE"
 128 >username</VAR
 129 >:<VAR
 130 CLASS="REPLACEABLE"
 131 >password</VAR
 132 ></PRE
 133 ><P>
 134 Each of the first four fields may be a literal value, or <TT
 135 CLASS="LITERAL"
 136 >*</TT
 137 >,
 138 which
 139 matches anything.  The password field from the first line that matches the
 140 current connection parameters will be used.  (Therefore, put more-specific
 141 entries first when you are using wildcards.)
 142 If an entry needs to contain <TT
 143 CLASS="LITERAL"
 144 >:</TT
 145 > or
 146 <TT
 147 CLASS="LITERAL"
 148 >\</TT
 149 >, escape this character with <TT
 150 CLASS="LITERAL"
 151 >\</TT
 152 >.</P
 153 ><P
 154 >The permissions on <TT
 155 CLASS="FILENAME"
 156 >.pgpass</TT
 157 > must disallow any
 158 access to world or group; achieve this by the command
 159 <TT
 160 CLASS="COMMAND"
 161 >chmod 0600 ~/.pgpass</TT
 162 >.
 163 If the permissions are less strict than this, the file will be ignored.</P
 164 ></DIV
 165 ><DIV
 166 CLASS="NAVFOOTER"
 167 ><HR
 168 ALIGN="LEFT"
 169 WIDTH="100%"><TABLE
 170 SUMMARY="Footer navigation table"
 171 WIDTH="100%"
 172 BORDER="0"
 173 CELLPADDING="0"
 174 CELLSPACING="0"
 175 ><TR
 176 ><TD
 177 WIDTH="33%"
 178 ALIGN="left"
 179 VALIGN="top"
 180 ><A
 181 HREF="libpq-envars.html"
 182 ACCESSKEY="P"
 183 >Prev</A
 184 ></TD
 185 ><TD
 186 WIDTH="34%"
 187 ALIGN="center"
 188 VALIGN="top"
 189 ><A
 190 HREF="index.html"
 191 ACCESSKEY="H"
 192 >Home</A
 193 ></TD
 194 ><TD
 195 WIDTH="33%"
 196 ALIGN="right"
 197 VALIGN="top"
 198 ><A
 199 HREF="libpq-threading.html"
 200 ACCESSKEY="N"
 201 >Next</A
 202 ></TD
 203 ></TR
 204 ><TR
 205 ><TD
 206 WIDTH="33%"
 207 ALIGN="left"
 208 VALIGN="top"
 209 >Environment Variables</TD
 210 ><TD
 211 WIDTH="34%"
 212 ALIGN="center"
 213 VALIGN="top"
 214 ><A
 215 HREF="libpq.html"
 216 ACCESSKEY="U"
 217 >Up</A
 218 ></TD
 219 ><TD
 220 WIDTH="33%"
 221 ALIGN="right"
 222 VALIGN="top"
 223 >Behavior in Threaded Programs</TD
 224 ></TR
 225 ></TABLE
 226 ></DIV
 227 ></BODY
 228 ></HTML
 229 >