Cannot drop database because of AUTOVACUUM

Started by Daniel Migowskiover 14 years ago2 messagesbugs
Jump to latest
#1Daniel Migowski
dmigowski@ikoffice.de

Hello,

I have a rare problem. I just restored a large database, and found out I made an error. Now I want to drop it, but can't do it because of the autovacuum process, running for minutes now, which i don't want to kill.

Isn't it possible to stop it from running if this is the only process connected to a database when I want to drop it?

Regards,
Daniel Migowski

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Daniel Migowski (#1)
Re: Cannot drop database because of AUTOVACUUM

Daniel Migowski <dmigowski@ikoffice.de> writes:

I have a rare problem. I just restored a large database, and found out I made an error. Now I want to drop it, but can't do it because of the autovacuum process, running for minutes now, which i don't want to kill.

Um ... if you're going to drop the database, why would you care about
letting an autovacuum complete? Its work would only be thrown away
anyway.

Isn't it possible to stop it from running if this is the only process connected to a database when I want to drop it?

An autovacuum process should get killed automatically if you issue a
DROP against its database (or table, for that matter).

If there's a bug here, you've not explained what it is.

regards, tom lane