Re: Autovacuum Daemon Disrupting dropdb?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Autovacuum Daemon Disrupting dropdb?
Дата
Msg-id 20037.1142115186@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Autovacuum Daemon Disrupting dropdb?  ("Matthew T. O'Connor" <matthew@zeut.net>)
Ответы Re: Autovacuum Daemon Disrupting dropdb?  ("Thomas F. O'Connell" <tfo@sitening.com>)
Список pgsql-general
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> I suppose you could instead:

> connect to local postmaster
> disable autovacuum
> pg_dump remotedb
> dropdb localdb
> pg_restore remotedb.pgd
> enable autovacuum

For a "real" solution, perhaps DROP DATABASE could somehow look to
determine if there's an autovac daemon active in the target database,
and if so send it a SIGINT and wait for it to go away.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Thomas F. O'Connell"
Дата:
Сообщение: Re: Autovacuum Daemon Disrupting dropdb?
Следующее
От: venu gopal
Дата:
Сообщение: getting failed while creating user accounts