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 D56999DCCF1 for ; Thu, 23 Feb 2006 19:08:54 -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 88736-05 for ; Thu, 23 Feb 2006 19:08:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.30.94]) by postgresql.org (Postfix) with ESMTP id B570C9DC99B for ; Thu, 23 Feb 2006 19:08:51 -0400 (AST) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:1285 helo=[127.0.0.1]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FCPX2-0000f2-Kn; Thu, 23 Feb 2006 23:05:56 +0000 Message-ID: <43FE4084.3050509@mailnetwork.co.uk> Date: Thu, 23 Feb 2006 23:08:52 +0000 From: Andy Shellam Reply-To: andy.shellam@mailnetwork.co.uk Organization: the mail network User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: "Mr. Dan" CC: pgsql-admin@postgresql.org Subject: Re: PGPASSWORD References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/298 X-Sequence-Number: 20719 Look at your pg_hba.conf file - your old configuration might have had a "trust" authentication set somewhere for your local machine/network IPs, rendering any password unnecessary. Andy Mr. Dan wrote: > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > !DSPAM:43fe0ff820151195621447! > >