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