Summary: | SSI issues with 9.1 | ||
---|---|---|---|
Product: | Slony-I | Reporter: | Steve Singer <ssinger> |
Component: | slon | Assignee: | Slony Bugs List <slony1-bugs> |
Status: | RESOLVED FIXED | ||
Severity: | enhancement | CC: | slony1-bugs |
Priority: | low | ||
Version: | 2.0 | ||
Hardware: | PC | ||
OS: | Linux | ||
Attachments: | Proposed fix |
Description
Steve Singer
2011-12-13 08:42:04 UTC
Created attachment 138 [details]
Proposed fix
9.1 to avoid pivot conflicts.
specify SERIALIZABLE for read only deferred transactions.
Make remote_worker calls to the provider read-only deferred
Make remote_worker calls on the local con READ COMMITTED.
Make the remote listener run in a READ ONLY DEFERRED transaction on
Based on a patch by Simon Riggs.
http://git.postgresql.org/gitweb?p=slony1-engine.git;a=commitdiff;h=c94cd25269f45a614f6bf3b77c7b759d1de71bed http://git.postgresql.org/gitweb?p=slony1-engine.git;a=commitdiff;h=44aa04906a195b90a9e5fd6552d6fe097bc5a50d http://git.postgresql.org/gitweb?p=slony1-engine.git;a=commitdiff;h=e689d4fa5f1b4b0eeb9e3f2061b8ba29e5729bb7 Applied against 2.0 2.1 and master(2.2) |