Re: Drop database / database in use question
От | Dan Armbrust |
---|---|
Тема | Re: Drop database / database in use question |
Дата | |
Msg-id | 82f04dc40810170816s3f932865v1b9c8230b496b80@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Drop database / database in use question (Alvaro Herrera <alvherre@commandprompt.com>) |
Ответы |
Re: Drop database / database in use question
Re: Drop database / database in use question |
Список | 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 по дате отправления: