I administer a network where a postgres database on one machine is
nightly dumped to another machine where it is restored (for
verification purposes) once the dump completes. The process is roughly:
pg_dump remotedb
dropdb localdb
pg_restore remotedb.pgd
We recently upgraded the system to 8.1.x and enabled autovacuum and
the dropdb command has recently begun failing periodically. Is this
because the autovacuum daemon runs it technically runs as a user and
can thus prevent dropping a database? There is no public application
that accesses the database. I note that the autovacuum daemon
requires a superuser_reserved_connections slot.
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)