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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings