Re: Documentation of .pgpass

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Documentation of .pgpass
Date: 2002-11-03 01:30:33
Message-ID: 200211030130.gA31UX105468@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs


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(dot)Elphick(at)lfix(dot)co(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2002-11-03 01:31:18 Re: Extra indexing, multibyte correction
Previous Message Oliver Elphick 2002-11-03 00:27:51 Extra indexing, multibyte correction