X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.225.181])
	by svr1.postgresql.org (Postfix) with ESMTP id AD944CC62E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 16 Jul 2003 14:33:07 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new,
	port 10024) with ESMTP id 40398-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 16 Jul 2003 14:33:16 +0000 (GMT)
Received: from exchange.hq.openratings.com (unknown [141.149.165.226])
	by svr1.postgresql.org (Postfix) with ESMTP id 3D1BECC64F
	for <pgsql-sql@postgresql.org>; Wed, 16 Jul 2003 11:32:53 -0300 (ADT)
Received: from openratings.com (cancun.hq.openratings.com [10.0.0.225]) by
	exchange.hq.openratings.com with SMTP (Microsoft Exchange
	Internet Mail Service Version 5.5.2653.13)
	id 38QM4LQV; Wed, 16 Jul 2003 10:33:20 -0400
Message-ID: <3F156253.3080104@openratings.com>
Date: Wed, 16 Jul 2003 10:33:55 -0400
From: Dmitry Tkach <dmitry@openratings.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Viorel Dragomir <bc@vio.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_dump "feature"
References: <004501c34b9f$f7d8f520$0600a8c0@fix.ro>
In-Reply-To: <004501c34b9f$f7d8f520$0600a8c0@fix.ro>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/201
X-Sequence-Number: 14315

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.