| From: | "Belinda M(dot) Giardine" <giardine(at)bio(dot)cse(dot)psu(dot)edu> |
|---|---|
| To: | John DeSoi <desoi(at)pgedit(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: running vacuum in scripts |
| Date: | 2005-09-20 15:11:28 |
| Message-ID: | Pine.GSO.4.53.0509201110080.1462@galapagos.bx.psu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 20 Sep 2005, John DeSoi wrote:
>
> On Sep 19, 2005, at 2:27 PM, Belinda M. Giardine wrote:
>
> > As far as I can tell vacuum must be run by the table or database
> > owner.
> > It wouldn't be as bad to have the password in the script if it was a
> > limited permissions user. Any suggestions on the best methods?
>
> Setup a .pgpass file so you don't need to embed the password in the
> script:
>
> http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
Thanks, this also could be useful. It sounds like I won't need it for
this if I use autovacuum, but could come in handy later.
Belinda
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2005-09-20 17:14:42 | Re: Slow search.. quite clueless |
| Previous Message | Belinda M. Giardine | 2005-09-20 15:04:44 | Re: running vacuum in scripts |