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 78AAC9DC806 for ; Thu, 23 Feb 2006 15:43:27 -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 57346-05 for ; Thu, 23 Feb 2006 15:43:27 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 2124D9DC973 for ; Thu, 23 Feb 2006 15:43:25 -0400 (AST) Received: from hotmail.com (bay102-f23.bay102.hotmail.com [64.4.61.33]) by svr4.postgresql.org (Postfix) with ESMTP id 7633F5AF0AE for ; Thu, 23 Feb 2006 19:43:26 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 23 Feb 2006 11:43:23 -0800 Message-ID: Received: from 64.4.61.200 by by102fd.bay102.hotmail.msn.com with HTTP; Thu, 23 Feb 2006 19:43:19 GMT X-Originating-IP: [66.160.12.211] X-Originating-Email: [bitsandbytes88@hotmail.com] X-Sender: bitsandbytes88@hotmail.com From: "Mr. Dan" To: pgsql-admin@postgresql.org Subject: PGPASSWORD Date: Thu, 23 Feb 2006 14:43:19 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 23 Feb 2006 19:43:23.0925 (UTC) FILETIME=[68712450:01C638B1] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.439 required=5 tests=[AWL=-0.480, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, MSGID_FROM_MTA_HEADER=0] X-Spam-Score: 1.439 X-Spam-Level: * X-Archive-Number: 200602/284 X-Sequence-Number: 20705 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. Thanks for any feedback, ~DjK