Date: Thu, 12 May 2005 22:43:26 +0200
From: Martin Pitt <mpitt@debian.org>
To: PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Subject: Fwd: Bug#308535: postgresql-client: [psql] manual page does not
	document ~/.pgpass file
Message-ID: <20050512204326.GC21489@piware.de>
Mail-Followup-To: PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="ZwgA9U+XZDXt4+m+"
Content-Disposition: inline
User-Agent: Mutt/1.5.9i


--ZwgA9U+XZDXt4+m+
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi PostgreSQL developers!

We recently got the bug report below. Do you agree that documenting
~/.pgpass in psql(1) is a good idea?

Thanks for considering and have a nice day!

Martin

----- Forwarded message from Jari Aalto <jari.aalto@cante.net> -----

Subject: Bug#308535: postgresql-client: [psql] manual page does not documen=
t ~/.pgpass file
Reply-To: Jari Aalto <jari.aalto@cante.net>, 308535@bugs.debian.org
=46rom: Jari Aalto <jari.aalto@cante.net>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Date: Tue, 10 May 2005 23:26:00 +0300
X-Spam-Status: No, score=3D0.0 required=3D4.0 tests=3DAWL,BAYES_50 autolear=
n=3Dno=20
	version=3D3.0.2

Package: postgresql-client
Version: 7.4.7-6
Severity: minor

psql(1) manual page does not mention in the FILES section ~/.pgpass file
and how it is used. It should include:=20

  FILES

      ...

      o The file ~/.pgpass in is a file that can contain passwords to be
	used if the connection requires a password (and no password has
	been specified otherwise). This file should have lines of the
	following format:

  	    hostname:port:database:username:password

	Each of the first four fields may be a literal value, or *, which
	matches anything. The password field from the first line that matches
	the current connection parameters will be used. (Therefore, put
	more-specific entries first when you are using wildcards.) If an entry
	needs to contain : or \, escape this character with \.

	The permissions on .pgpass must disallow any access to world or group;
	achieve this by the command chmod 0600 ~/.pgpass. If the permissions
	are less strict than this, the file will be ignored.

This explanation was exerpted from=20
http://www.postgresql.org/docs/7.4/static/libpq-pgpass.html
I have no idea why it is there, where nobidy is looking

----- End forwarded message -----

--=20
Martin Pitt              http://www.piware.de
Ubuntu Developer   http://www.ubuntulinux.org
Debian Developer        http://www.debian.org

--ZwgA9U+XZDXt4+m+
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)

iD8DBQFCg7/uDecnbV4Fd/IRAq4HAKDrqLCbN6Eph32voWvb4wmO+UK3DwCgypVF
TOgxng5Su9Je8oQ1RKL1aZw=
=PjWr
-----END PGP SIGNATURE-----

--ZwgA9U+XZDXt4+m+--