Fwd: Bug#308535: postgresql-client: [psql] manual page does not document ~/.pgpass file

From: Martin Pitt <mpitt(at)debian(dot)org>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Fwd: Bug#308535: postgresql-client: [psql] manual page does not document ~/.pgpass file
Date: 2005-05-12 20:43:26
Message-ID: 20050512204326.GC21489@piware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs

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(dot)aalto(at)cante(dot)net> -----

Subject: Bug#308535: postgresql-client: [psql] manual page does not document ~/.pgpass file
Reply-To: Jari Aalto <jari(dot)aalto(at)cante(dot)net>, 308535(at)bugs(dot)debian(dot)org
From: Jari Aalto <jari(dot)aalto(at)cante(dot)net>
To: Debian Bug Tracking System <submit(at)bugs(dot)debian(dot)org>
Date: Tue, 10 May 2005 23:26:00 +0300
X-Spam-Status: No, score=0.0 required=4.0 tests=AWL,BAYES_50 autolearn=no
version=3.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:

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
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 -----

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jim Ramsey 2005-05-12 21:41:49 BUG #1667: Corrupt zipfile
Previous Message Martin Pitt 2005-05-12 20:39:33 Fwd: Bug#308513: postgresql-client: [manual] createuser(1) Add example '...WITH PASSWORD'

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2005-05-13 13:49:27 Re: Fwd: Bug#308535: postgresql-client: [psql] manual page does not document ~/.pgpass file
Previous Message Kris Jurka 2005-05-11 19:23:00 create rule syntax