X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 147A3CC456 for ; Wed, 16 Jul 2003 13:41:56 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 99923-09 for ; Wed, 16 Jul 2003 13:42:14 +0000 (GMT) Received: from mail1.dr.myx.net (mail1.dr.myx.net [217.10.193.161]) by svr1.postgresql.org (Postfix) with ESMTP id B4D41CBF0C for ; Wed, 16 Jul 2003 10:41:51 -0300 (ADT) Received: from workstation24 (unknown [81.12.137.146]) by mail1.dr.myx.net (mydomain.myx.net) with ESMTP id 53D02300681 for ; Wed, 16 Jul 2003 16:42:07 +0300 (EEST) Message-ID: <004501c34b9f$f7d8f520$0600a8c0@fix.ro> From: "Viorel Dragomir" To: Subject: pg_dump "feature" Date: Wed, 16 Jul 2003 16:41:31 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0042_01C34BB9.1CAF0150" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=HTML_40_50 X-Spam-Level: X-Archive-Number: 200307/195 X-Sequence-Number: 14309 This is a multi-part message in MIME format. ------=_NextPart_000_0042_01C34BB9.1CAF0150 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable 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 . In 7.1.3 this command work, the only incovenience is that pg_dump shows "Us= er name: Password:"=20 but gets the password from file. In 7.3.x the pg_dump accepts the password only from stdin. The user must en= ter his password. It's a feature or a bug, because i can't see any logic in this behaviour. I hope i'll receive an answer, or else i'll post this topic on developers l= ist :) Thanks. ------=_NextPart_000_0042_01C34BB9.1CAF0150 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable
In 7.1.2 you can launch this command witho= ut any=20 problems:
pg_dump -u -s database <=20 file.txt
 
where file.txt contains 2 lines:
username
password
~
~
~
 
And you'll get the dump of the=20 <database>.
 
In 7.1.3 this command work, the only incov= enience=20 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=20 stdin. The user must enter his password.
It's a feature or a bug, because i can't s= ee any=20 logic in this behaviour.
 
I hope i'll receive an answer, or else i'l= l post=20 this topic on developers list :)
 
Thanks.
------=_NextPart_000_0042_01C34BB9.1CAF0150--