"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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq