The following bug has been logged online:

Bug reference: 1349
Logged by: PiotrL

Email address: vpiotr (AT) poczta (DOT) onet.pl

PostgreSQL version: 7.4.6

Operating system: Windows

Description: Gap in documentation - pg_dump

Details:

I'm sorry, but I didn't found a better place to report that:

There is no information how to specify user's password in pg_dump
documentation. I have spent half of day searching for that (pg_hba.conf was
not working for me) and the answer is very simple:

You can use SET variables for that:

PGUSER=web-user
PGPASSWORD=secret

Please include that in pg_dump documentation.

Regards,
Piotr



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

On Thu, Dec 16, 2004 at 08:16:56 +0000,
PostgreSQL Bugs List <pgsql-bugs (AT) postgresql (DOT) org> wrote:
You don't want to do that; on many systems the contents of environment
variables are visible to other processes. You can keep a password in
~/.pgpass and that will work for more than just pg_dump. If the batch
scripts are running on the same machine as the server, consider using
ident authentication.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

On Thu, Dec 16, 2004 at 20:21:48 +0100,
Piotr Likus <vpiotr (AT) poczta (DOT) onet.pl> wrote:
The official documentation isn't likely to be changed to instruct people
how to incorrectly set up their system.

It may be that there is a deficiency in the pg_dump documentation if you
are expected to know something from another part of the manual that it
may not be obvious that you should know. In that case the answer is
to refer to the other section or to include enough information to
avoid needing to refer to the other section.`

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match