Autovacuum Daemon Disrupting dropdb?

From: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
To: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Autovacuum Daemon Disrupting dropdb?
Date: 2006-03-11 20:29:05
Message-ID: AC09762F-DDFE-483D-8CB9-C1A4A9D59415@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew T. O'Connor 2006-03-11 20:44:04 Re: Autovacuum Daemon Disrupting dropdb?
Previous Message Daniel Schuchardt 2006-03-11 20:09:38 Re: Any Delphi programmers on this list?