X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 747179DC9B8 for ; Thu, 23 Feb 2006 16:44:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66273-09 for ; Thu, 23 Feb 2006 16:44:03 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 117E09DC801 for ; Thu, 23 Feb 2006 16:44:01 -0400 (AST) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by svr4.postgresql.org (Postfix) with ESMTP id 044185AF3A9 for ; Thu, 23 Feb 2006 20:44:02 +0000 (GMT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1FCNJW-00061l-SG for pgsql-admin@postgresql.org; Thu, 23 Feb 2006 21:43:50 +0100 Received: from 85.187.136.11 ([85.187.136.11]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 23 Feb 2006 21:43:50 +0100 Received: from milen by 85.187.136.11 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 23 Feb 2006 21:43:50 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: PGPASSWORD Date: Thu, 23 Feb 2006 22:43:08 +0200 Lines: 25 Message-ID: <43FE1E5C.7010604@radev.net> References: Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1251 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: 85.187.136.11 User-Agent: Mozilla Thunderbird 1.5 (Windows/20051201) In-Reply-To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.373 required=5 tests=[AWL=0.120, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.373 X-Spam-Level: * X-Archive-Number: 200602/287 X-Sequence-Number: 20708 Mr. Dan написа: > Hi, > > When I was running 8.0.X on linux, I didn't have to include the postgres > -P password in my shell scripts(.sh). After I switched to 8.1.X, I've > had to include the -P PASSWORD ****** in all my scripts. I'm thinking > I'll just add PGPASSWORD as a postgres environment variable instead. I > did start running 8.1.X on a port that is different from the default, so > I added PGPORT as an environment variable, so I don't have to include -p > PORT NUMBER. Has anyone else noticed they had to start including a > password for the postgres user in 8.1.X? Is there any concern to adding > PGPASSWORD as an environment variable. > See the paragraph about "PGPASSWORD" at http://www.postgresql.org/docs/8.1/static/libpq-envars.html - it recommends the use of "~/.pgpass" file. BTW I can't seem to find any reference to a "-P" parameter related to supplying a password. -- Milen A. Radev