Daniel Migowski <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
