Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id DDFB94758E6
	for <pgsql-docs@postgresql.org>; Sat,  2 Nov 2002 19:25:49 -0500 (EST)
Received: from anchor-post-39.mail.demon.net (anchor-post-39.mail.demon.net
	[194.217.242.80])
	by postgresql.org (Postfix) with ESMTP id 56B2E4758DC
	for <pgsql-docs@postgresql.org>; Sat,  2 Nov 2002 19:25:49 -0500 (EST)
Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk)
	by anchor-post-39.mail.demon.net with esmtp (Exim 3.36 #2)
	id 1888aM-0001NG-0U
	for pgsql-docs@postgresql.org; Sun, 03 Nov 2002 00:25:51 +0000
Received: from localhost ([127.0.0.1] helo=localhost.localdomain ident=olly)
	by linda.lfix.co.uk with esmtp (Exim 3.36 #1 (Debian))
	id 1888aM-00006S-00
	for <pgsql-docs@postgresql.org>; Sun, 03 Nov 2002 00:25:50 +0000
Subject: Documentation of .pgpass
From: Oliver Elphick <olly@lfix.co.uk>
To: pgsql-docs@postgresql.org
Content-Type: multipart/mixed; boundary="=-qVskTMc74dYcrJAI3SRa"
X-Mailer: Ximian Evolution 1.0.8 
Date: 03 Nov 2002 00:25:50 +0000
Message-Id: <1036283150.31216.63.camel@linda>
Mime-Version: 1.0
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/1
X-Sequence-Number: 1525

--=-qVskTMc74dYcrJAI3SRa
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

This patch adds information to the documentation on .pgpass and creates
additional index entries for it.


-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                            
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Lo, children are an heritage of the LORD; and the  
      fruit of the womb is his reward."        Psalms 127:3 

--=-qVskTMc74dYcrJAI3SRa
Content-Description: 
Content-Disposition: inline; filename=libpq-doc.diff
Content-Transfer-Encoding: quoted-printable
Content-Type: text/x-patch; charset=ISO-8859-15

Index: doc/src/sgml/libpq.sgml
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/libpq.sgml,v
retrieving revision 1.97
diff -u -r1.97 libpq.sgml
--- doc/src/sgml/libpq.sgml	2002/09/21 18:32:53	1.97
+++ doc/src/sgml/libpq.sgml	2002/11/03 00:20:20
@@ -2047,7 +2047,8 @@
 <envar>PGPASSWORD</envar>
 sets the password used if the backend demands password
 authentication.  This functionality is deprecated for security
-reasons; consider migrating to use the <filename>$HOME/.pgpass</>
+reasons; consider migrating to use the <link linkend=3D'pgpassfile'>
+<filename>$HOME/.pgpass</></link>
 file.
 </para>
 </listitem>
@@ -2133,6 +2134,11 @@
  <primary>files</primary>
 </indexterm>
 <para>
+<anchor id=3D"pgpassfile"/>
+<indexterm>
+ <primary>password</primary>
+ <secondary>.pgpass</secondary>
+</indexterm>
 <filename>$HOME/.pgpass</filename> is a file that can contain passwords
 to be used if the connection requires a password. This file should have the
 format:
@@ -2144,6 +2150,11 @@
 Entries with <literal>:</literal> or <literal>\</literal> should be escaped
 with <literal>\</literal>.
 </para>
+<para>
+The permissions on <filename>$HOME/.pgpass</filename> must disallow any
+access to world or group; achieve this by the command
+<command>chmod 0600 $HOME/.pgaccess</command>.
+If the permissions are less strict than this, the file will be ignored.
 </sect1>
=20
 <sect1 id=3D"libpq-threading">

--=-qVskTMc74dYcrJAI3SRa--