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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
