X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 49D0711F65F8 for ; Mon, 3 Apr 2006 16:08:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62654-09 for ; Mon, 3 Apr 2006 16:08:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from colo-dns-ext2.juniper.net (colo-dns-ext2.juniper.net [207.17.137.64]) by postgresql.org (Postfix) with ESMTP id 294F011F6614 for ; Mon, 3 Apr 2006 16:08:37 -0300 (ADT) Received: from merlot.juniper.net (merlot.juniper.net [172.17.27.10]) by colo-dns-ext2.juniper.net (8.12.3/8.12.3) with ESMTP id k33J8a1Z080578; Mon, 3 Apr 2006 12:08:36 -0700 (PDT) (envelope-from kenjim@juniper.net) Received: from kenjim-lnx.juniper.net (kenjim-lnx.juniper.net [172.17.58.60]) by merlot.juniper.net (8.11.3/8.11.3) with ESMTP id k33J8a511624; Mon, 3 Apr 2006 12:08:36 -0700 (PDT) (envelope-from kenjim@juniper.net) Received: from kenjim-lnx.juniper.net (kenjim-lnx.juniper.net [127.0.0.1]) by kenjim-lnx.juniper.net (8.13.4/8.13.4) with ESMTP id k33J8avl014699; Mon, 3 Apr 2006 12:08:36 -0700 Received: (from kenjim@localhost) by kenjim-lnx.juniper.net (8.13.4/8.13.4/Submit) id k33J8ajO014698; Mon, 3 Apr 2006 12:08:36 -0700 Date: Mon, 3 Apr 2006 12:08:36 -0700 From: Kenji Morishige To: Tom Lane , pgsql-performance@postgresql.org Cc: kenjim@juniper.net Subject: Re: optimizing db for small table with tons of updates Message-ID: <20060403190836.GB14328@juniper.net> References: <20060403182403.GA12257@juniper.net> <15521.1144089550@sss.pgh.pa.us> <20060403190213.GA14328@juniper.net> <20060403190354.GC15756@surnet.cl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060403190354.GC15756@surnet.cl> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200604/30 X-Sequence-Number: 18114 Sweet! Thanks. -Kenji On Mon, Apr 03, 2006 at 03:03:54PM -0400, Alvaro Herrera wrote: > Kenji Morishige wrote: > > I've been stumped as to how to call psql from the command line without it > > prompting me for a password. Is there a enviornoment variable I can specify for > > the password or something I can place in .pgsql? I could write a perl wrapper > > around it, but I've been wondering how I can call psql -c without it prompting > > me. Is it possible? > > Sure it is. Set up a .pgpass file. > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc.