Re: 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: Re: Autovacuum Daemon Disrupting dropdb?
Date: 2006-03-12 20:43:15
Message-ID: 2DEE6A87-1E8F-41D0-A9BB-D7BB1714C60B@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mar 11, 2006, at 4:13 PM, Tom Lane wrote:

> For a "real" solution, perhaps DROP DATABASE could somehow look to
> determine if there's an autovac daemon active in the target database,
> and if so send it a SIGINT and wait for it to go away.

In general, it also seems like a --force option or something similar
would be reasonable for dropdb because the state of the database in
terms of user activity wouldn't seem to matter a whole lot if the
intent is to drop it.

--
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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Javier Carlos 2006-03-12 20:50:41 Re: getting failed while creating user accounts
Previous Message P G 2006-03-12 17:03:21 COPY has no access permissions