Re: Drop database / database in use question - Mailing list pgsql-general

From Dan Armbrust
Subject Re: Drop database / database in use question
Date
Msg-id 82f04dc40810170816s3f932865v1b9c8230b496b80@mail.gmail.com
Whole thread Raw
In response to Re: Drop database / database in use question  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Drop database / database in use question  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Drop database / database in use question  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
I don't suppose that there is any easy way way that I can stop and/or
disable the Autovac temporarily for the database that I want to drop.

The only thing that I have seen so far, is that I would have to add
rows to the pg_autovacuum  table for each table in my database, but
I'm    not confident that that would even stop it from accessing the
database, since it says that even when set to disabled, autovacuum
will still run to prevent transaction id wraparounds, so it seems that
it still would make make a quick check into the database that my drop
command could collide with.

pgsql-general by date:

Previous
From: Glyn Astill
Date:
Subject: Re: PQescapestringConn not found in libpq.dll
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Annoying Reply-To