Autovacuum Daemon Disrupting dropdb?
От | Thomas F. O'Connell |
---|---|
Тема | Autovacuum Daemon Disrupting dropdb? |
Дата | |
Msg-id | AC09762F-DDFE-483D-8CB9-C1A4A9D59415@sitening.com обсуждение исходный текст |
Ответы |
Re: Autovacuum Daemon Disrupting dropdb?
|
Список | pgsql-general |
I administer a network where a postgres database on one machine is nightly dumped to another machine where it is restored (for verification purposes) once the dump completes. The process is roughly: pg_dump remotedb dropdb localdb pg_restore remotedb.pgd We recently upgraded the system to 8.1.x and enabled autovacuum and the dropdb command has recently begun failing periodically. Is this because the autovacuum daemon runs it technically runs as a user and can thus prevent dropping a database? There is no public application that accesses the database. I note that the autovacuum daemon requires a superuser_reserved_connections slot. -- Thomas F. O'Connell Database Architecture and Programming Co-Founder Sitening, LLC http://www.sitening.com/ 3004 B Poston Avenue Nashville, TN 37203-1314 615-260-0005 (cell) 615-469-5150 (office) 615-469-5151 (fax)
В списке pgsql-general по дате отправления: