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