[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] Cannot drop database because of AUTOVACUUM
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2011-12-24 14:39:37
Message-ID: 13480.1324737577 () sss ! pgh ! pa ! us
[Download RAW message or body]

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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[prev in list] [next in list] [prev in thread] [next in thread]