"Dan Thomas" <godders(at)gmail(dot)com> writes:
> I've been having trouble running vacuumdb -a and pg_dumpall
> concurrently because they run through the databases in a different
> order (so dumpall was getting stuck behind vacuum's lock, and my
> firewall was rather unhelpfully closing the idle connection).
Um, whaddya mean "dumpall was getting stuck behind vacuum's lock"?
A plain vacuum doesn't take any locks that would block pg_dump.
While the proposed patch looks harmless enough, I'm unconvinced that
it will solve your problem, or even quite what the problem is.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2006-09-17 19:23:51|
|Subject: Re: [HACKERS] Developer's Wiki|
|Previous:||From: Tom Lane||Date: 2006-09-17 18:25:16|
|Subject: Re: [HACKERS] Developer's Wiki |
pgsql-patches by date
|Next:||From: Dan Thomas||Date: 2006-09-17 19:52:21|
|Subject: Re: tiny patch to make vacuumdb -a's database order match pg_dumpall|
|Previous:||From: Andrew - Supernews||Date: 2006-09-17 14:57:20|
|Subject: Re: Timezone List|