X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9917F53205 for ; Fri, 1 Apr 2005 06:09:11 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66256-04 for ; Fri, 1 Apr 2005 05:09:08 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id C4A9053714 for ; Fri, 1 Apr 2005 06:09:06 +0100 (BST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id BD61230952; Fri, 1 Apr 2005 07:09:02 +0200 (MET DST) From: Christopher Browne X-Newsgroups: pgsql.interfaces.php Subject: Re: PostgreSQL Backup Script Date: Fri, 01 Apr 2005 00:04:48 -0500 Organization: cbbrowne Computing Inc Lines: 29 Message-ID: References: <77b69d2105033120543ca670a7@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:O71GKGjJERikdebSffEmK26CC3s= To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.403 tagged_above=0 required=5 tests=AWL, INFO_TLD X-Spam-Level: X-Archive-Number: 200504/8 X-Sequence-Number: 3092 vishalonlist@gmail.com ("Vishal Kashyap @ [SaiHertz]") wrote: > I am stuck with database backup. > While using pg_dump the utility asks for password but since I require > this process to be automated the password prompt is giving me > headaches > is their any way by which can pass the password automatically. > Like setting up a variable in php which passes the password to the > pg_dump utility on prompt this way the whole process of pg_dump would > get automated. > One obvious solution was to use .pgpass but it does not appeal me > because it is again a security threat. > any pointers or help may lead to unlocked secret. You seem to be imagining that there can exist a way of storing some form of a password in a fashion that allows automating these sorts of things that _doesn't_ present an identical security threat to that involved with .pgpass It may take a bit of thinking about the problem to disabuse oneself of such fantasies... -- (reverse (concatenate 'string "gro.mca" "@" "enworbbc")) http://linuxfinances.info/info/security.html Rules of the Evil Overlord #125. "Should I actually decide to kill the hero in an elaborate escape-proof deathtrap room (water filling up, sand pouring down, walls converging, etc.) I will not leave him alone five-to-ten minutes prior to "imminent" death, but will instead (finding a vantage point or monitoring camera) stick around and enjoy watching my adversary's demise."