Andrew Sullivan ajs
Fri Sep 17 12:12:48 PDT 2004
On Fri, Sep 17, 2004 at 11:33:39AM +0200, hannu at skype.net wrote:
> Hi
> 
> Is it true (as I think it is) that running pg_dump on master database will
> stall replication ?

Yes.  There's an exclusive lock that Slony grabs which blocks because
of the lock from pg_dump.  What would ne nice is an option to pg_dump
to exclude one schema.  Then you could exclude Slony's.

A
-- 
Andrew Sullivan  | ajs at crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.
		--Philip Greenspun


More information about the Slony1-general mailing list