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 746C69DCD1F for ; Thu, 23 Feb 2006 17:23:09 -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 74963-02 for ; Thu, 23 Feb 2006 17:23:10 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 3F4E49DCCFE for ; Thu, 23 Feb 2006 17:23:06 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 1AF495642F; Thu, 23 Feb 2006 15:23:38 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Thu, 23 Feb 2006 15:23:37 -0600 Date: Thu, 23 Feb 2006 15:23:37 -0600 From: "Jim C. Nasby" To: "Mr. Dan" Cc: pgsql-admin@postgresql.org Subject: Re: PGPASSWORD Message-ID: <20060223212337.GB86022@pervasive.com> References: <43FE1E5C.7010604@radev.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060223:bitsandbytes88@hotmail.com::yMbo/Gludd8WIMUr:00000000000 0000000000000000000000004rc4 X-Hashcash: 1:20:060223:pgsql-admin@postgresql.org::ok/jWph62g2lJUcn:00000000000 0000000000000000000000000FLL X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.104 required=5 tests=[AWL=0.104] X-Spam-Score: 0.104 X-Spam-Level: X-Archive-Number: 200602/291 X-Sequence-Number: 20712 Depending on your actual config, you could well be able to set postgresql up so that it doesn't need any passwords, too. I prefer this when possible... but you need to understand the rammifications if you care about your data. Though, if all you're doing is running pgbench, I'd say just setup everything for TRUST and be done with it... ;) On Thu, Feb 23, 2006 at 03:55:28PM -0500, Mr. Dan wrote: > > > Thanks Milen! > > I use -P is bash shell scirpts. It used with with pgbench. > see pgbench --help. > > ~DjK > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461