Re: optimizing db for small table with tons of updates

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Kenji Morishige <kenjim(at)juniper(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: optimizing db for small table with tons of updates
Date: 2006-04-03 19:03:54
Message-ID: 20060403190354.GC15756@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kenji Morishige 2006-04-03 19:08:36 Re: optimizing db for small table with tons of updates
Previous Message Kenji Morishige 2006-04-03 19:02:13 Re: optimizing db for small table with tons of updates