From: Dmitry Tkach <dmitry@openratings.com>
To: Viorel Dragomir <bc@vio.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_dump "feature"
Date: Wed, 16 Jul 2003 10:33:55 -0400
Message-ID: <3F156253.3080104@openratings.com> (raw)
In-Reply-To: <004501c34b9f$f7d8f520$0600a8c0@fix.ro>
References: <004501c34b9f$f7d8f520$0600a8c0@fix.ro>
Viorel Dragomir wrote:
> In 7.1.2 you can launch this command without any problems:
> pg_dump -u -s database < file.txt
>
> where file.txt contains 2 lines:
> username
> password
> ~
> ~
> ~
>
> And you'll get the dump of the <database>.
>
> In 7.1.3 this command work, the only incovenience is that pg_dump
> shows "User name: Password:"
> but gets the password from file.
>
> In 7.3.x the pg_dump accepts the password only from stdin. The user
> must enter his password.
> It's a feature or a bug, because i can't see any logic in this behaviour.
It's a feature :-)
The logic is that it is insecure to keep passwords in files.
If you are not concerned about the security in this case, you can switch
to ident or trust identification. That won't prompt you for the password.
Dima.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dmitry@openratings.com, bc@vio.ro
Subject: Re: pg_dump "feature"
In-Reply-To: <3F156253.3080104@openratings.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox