| From: | Kenji Morishige <kenjim(at)juniper(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org |
| Cc: | kenjim(at)juniper(dot)net |
| Subject: | Re: optimizing db for small table with tons of updates |
| Date: | 2006-04-03 19:08:36 |
| Message-ID: | 20060403190836.GB14328@juniper.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-04-03 19:23:50 | Re: optimizing db for small table with tons of updates |
| Previous Message | Alvaro Herrera | 2006-04-03 19:03:54 | Re: optimizing db for small table with tons of updates |