Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 2AE6F476061
	for <pgsql-docs@postgresql.org>; Sat,  2 Nov 2002 20:30:59 -0500 (EST)
Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251])
	by postgresql.org (Postfix) with ESMTP id 80117476543
	for <pgsql-docs@postgresql.org>; Sat,  2 Nov 2002 20:30:53 -0500 (EST)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.10.1) id gA31UX105468;
	Sat, 2 Nov 2002 20:30:33 -0500 (EST)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200211030130.gA31UX105468@candle.pha.pa.us>
Subject: Re: Documentation of .pgpass
In-Reply-To: <1036283150.31216.63.camel@linda>
To: Oliver Elphick <olly@lfix.co.uk>
Date: Sat, 2 Nov 2002 20:30:33 -0500 (EST)
Cc: pgsql-docs@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL99 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/3
X-Sequence-Number: 1527


Patch applied.  Thanks.

---------------------------------------------------------------------------


Oliver Elphick wrote:
> 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 

Content-Description: 

[ text/x-patch is unsupported, treating like TEXT/PLAIN ]

> Index: doc/src/sgml/libpq.sgml
> ===================================================================
> 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='pgpassfile'>
> +<filename>$HOME/.pgpass</></link>
>  file.
>  </para>
>  </listitem>
> @@ -2133,6 +2134,11 @@
>   <primary>files</primary>
>  </indexterm>
>  <para>
> +<anchor id="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>
>  
>  <sect1 id="libpq-threading">

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073