Fri May 22 07:09:57 PDT 2009
- Previous message: [Slony1-general] serialization problem related to log shipping?
- Next message: [Slony1-general] sl_nodelock values ("pg_catalog".pg_backend_pid()); " - ERROR: duplicate key value
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
SGVsbG8uCgpJIGFtIHdvcnJ5IGFib3V0IHRoZSBidWcgaHR0cDovL3d3dy5zbG9ueS5pbmZvL2J1 Z3ppbGxhL3Nob3dfYnVnLmNnaT9pZD03NQp3aGljaCBJIHJlcG9ydGVkIHNvbWUgdGltZSBhZ28u CgpDb3VsZCB5b3UgcGxlYXNlIHByb3ZpZGUgYSBmZWVkYmFjayBhYm91dCBpdCAtIGlmIHlvdSBo YXZlIHNvbWUgdGltZT8KCkkgYXR0YWNoZWQgdHdvIHBhdGNoZXMgdG8gdGhlIGJ1Z3JlcG9ydDsg dGhleSBzZWVtIHRvIHNvbHZlIHRoZSBwcm9ibGVtLgpJIGR1cGxpY2F0ZSBiZWxvdyB0aGUgYnVn IGRlc2NyaXB0aW9uICYgY29tbWVudHMuIFRoYW5rIHlvdSEKCj09PT09PT09PT09PT09PT09PT0K CkZpcnN0LCBhIGxpdHRsZSBwYXRjaCAoMSkKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQoKLS0t IHNsb255MS0yLjAuMS1vcmlnL3NyYy9iYWNrZW5kL3Nsb255MV9mdW5jcy5jICAgICAgICAyMDA5 LTAyLTIzCjIyOjA5OjQwLjAwMDAwMDAwMCArMDMwMAorKysgc2xvbnkxLTIuMC4xL3NyYy9iYWNr ZW5kL3Nsb255MV9mdW5jcy5jICAgICAyMDA5LTAzLTA4IDIxOjU4OjM4LjAwMDAwMDAwMAorMDMw MApAQCAtMzMyLDUgKzMzMiw1IEBACiAgICAgICAgICogRG8gdGhlIGZvbGxvd2luZyBvbmx5IG9u Y2UgcGVyIHRyYW5zYWN0aW9uLgogICAgICAgICAqLwotICAgICAgIGlmICghVHJhbnNhY3Rpb25J ZEVxdWFscyhjcy0+Y3VycmVudFhpZCwgbmV3WGlkKSkKKyAgICAgICBpZiAoIVRyYW5zYWN0aW9u SWRFcXVhbHMoY3MtPmN1cnJlbnRYaWQsIG5ld1hpZCkgfHwKIWNzLT5wbGFuX2FjdGl2ZV9sb2cp CiAgICAgICAgewogICAgICAgICAgICAgICAgaW50MzIgICAgICAgICAgIGxvZ19zdGF0dXM7CgpU aGUgcGF0Y2gganVzdCBhZGRzIGxvZ2ljYWwgY29uc2lzdGVuY2U6IHRoZSBjb2RlIGluc2lkZSB0 aGlzICJpZiIgaW5pdGlhbGl6ZXMKYm90aCBjcy0+Y3VycmVudFhpZCBhbmQgcGxhbl9hY3RpdmVf bG9nIG9uY2UgcGVyIHRyYW5zYWN0aW9uLCBidXQgY2hlY2tzIG9ubHkKY3MtPmN1cnJlbnRYaWQu IEFkZGl0aW9uYWwgY2hlY2sgZm9yIGNzLT5jdXJyZW50WGlkIGlzIHNhZmUgYW5kIHNlZW1zIHRv IGJlCnJlYXNvbmFibGUgYW55d2F5LgoKKE5vdGUgdGhhdCB0aGlzIGlzc3VlIGNvcnJlbGF0ZSB3 aXRoIHRoZSBzZWNvbmQgb25lLCBzbyBpdCB3aWxsIGJyZWFrIHNsb255IGlmCnlvdSB3aWxsIG5v dCBhcHBseSB0aGUgc2Vjb25kIHBhdGNoIHRvby4gVGhlIGVmZmVjdCBvZiB0aGUgc2Vjb25kIGJ1 ZyBpcwpkZXN0cm95ZWQgYnkgdGhlIGZpcnN0IGJ1Zy4pCgoKU2Vjb25kLCBidWcgd2l0aCBuZXcg c2Vzc2lvbl9yZXBsaWNhdGlvbl9yb2xlIGFuZCAiU0VUIGRhdGVzdHlsZSBUTyAnSVNPJyIgKDIp Ci0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQoKSSBkZXRlY3RlZCB0aGF0IGxvZ1RyaWdnZXIgaXMgTk9U IHR1cm5lZCBvZmYgZHVyaW5nIHRoZSBFWEVDVVRFIFFVRVJZIGluClNsb255LUkgdjIuMC4xLgpU YWtlIGEgbG9vayBhdCB0aGUgZm9sbG93aW5nIHF1ZXJ5IGxvZyBwcm9kdWNlZCBieSBzbG9uaWs6 CgpbcG9zdGdyZXNAc2xvbm9wb3RhbV9tIDE2MjNdIExPRzogIMvPzcHOxME6IGJlZ2luIHRyYW5z YWN0aW9uOwpbcG9zdGdyZXNAc2xvbm9wb3RhbV9tIDE2MjNdIExPRzogIMvPzcHOxME6IFNFVCBk YXRlc3R5bGUgVE8gJ0lTTyc7IFNFVApzZXNzaW9uX3JlcGxpY2F0aW9uX3JvbGUgVE8gbG9jYWw7 Cltwb3N0Z3Jlc0BzbG9ub3BvdGFtX20gMTYyM10gTE9HOiAgy8/Nwc7EwTogc2VsZWN0IHZlcnNp b24oKTsKW3Bvc3RncmVzQHNsb25vcG90YW1fbSAxNjIzXSBMT0c6ICDLz83BzsTBOiByb2xsYmFj ayB0cmFuc2FjdGlvbjsKLi4uCltwb3N0Z3Jlc0BzbG9ub3BvdGFtX20gMTYyM10gTE9HOiAgy8/N wc7EwTogYmVnaW4gdHJhbnNhY3Rpb247Cltwb3N0Z3Jlc0BzbG9ub3BvdGFtX20gMTYyM10gTE9H OiAgy8/Nwc7EwTogc2VsZWN0CiJfc2xvbmNsdXN0ZXIiLmRkbFNjcmlwdF9wcmVwYXJlKDQ3MjUs IDI3MzYpOwpbcG9zdGdyZXNAc2xvbm9wb3RhbV9tIDE2MjNdIExPRzogIMvPzcHOxME6IFVQREFU RSBhIFNFVCBpZF9jb3B5ID0gaWQ7Cltwb3N0Z3Jlc0BzbG9ub3BvdGFtX20gMTYyM10gTE9HOiAg ZXhlY3V0ZSA8dW5uYW1lZD46IHNlbGVjdAoiX3Nsb25jbHVzdGVyIi5kZGxTY3JpcHRfY29tcGxl dGUoNDcyNSwgJDE6OnRleHQsIDI3MzYpOwpbcG9zdGdyZXNAc2xvbm9wb3RhbV9tIDE2MjNdIExP RzogIMvPzcHOxME6IGNvbW1pdCB0cmFuc2FjdGlvbjsKLi4uCgpZb3Ugc2VlLCB0aGUgZWZmZWN0 IG9mICJTRVQgc2Vzc2lvbl9yZXBsaWNhdGlvbl9yb2xlIFRPIGxvY2FsIiBpcyBOT1QgdmlzaWJs ZQp3aXRoaW4gYSBuZXh0IHRyYW5zYWN0aW9uLCBiZWNhdXNlIGl0IGlzIHJvbGxlZCBiYWNrLiBU aGlzIGlzIGJlY2F1c2UKZGJfY29ubmVjdCgpIGV4ZWN1dGVzIGl0IG9uIGEgY29ubmVjdGlvbiBz dGFydCAoY29ycmVjdCksIGJ1dCB2aWEKZGJfZXhlY19jb21tYW5kICh3cm9uZyksIGFuZCBkYl9l eGVjX2NvbW1hbmQgYmVnaW5zIGEgdHJhbnNhY3Rpb24gYXQgaXRzIGZpcnN0CnJ1bi4KCihGcmFu a2x5LCB0aGFua3MgdG8gKDEpIGl0IGlzIG5vdCB2aXNpYmxlLCBiZWNhdXNlIGNzLT5wbGFuX2Fj dGl2ZV9sb2cgaXMKc3VycHJpc2VseSBudWxsIHdpdGhpbiBhIGxvZ1RyaWdnZXIgY2FsbC4gU28s IGxvZ1RyaWdnZXIgSVMgQ0FMTEVELCBidXQKZXhlY3V0ZXMgYSBOVUxMIHF1ZXJ5IHdoaWNoIGlz IGlnbm9yZWQgYnkgUG9zdGdyZXMuKQoKVGhlIHNvbHV0aW9uIGlzIHRvIHBlcmZvcm0gY29ubmVj dGlvbiBpbml0aWFsaXphdGlvbiBvdXRzaWRlIGEgdHJhbnNhY3Rpb24sIHZpYQpkaXJlY3QgUFFl eGVjIGNhbGwsIG5vdCB2aWEgZGJfYmVnaW5feGFjdCgpLgpIZXJlIGlzIHRoZSBwYXRjaDoKCmRp ZmYgLVUyIHNsb255MS0yLjAuMS1vcmlnL3NyYy9zbG9uaWsvZGJ1dGlsLmMgc2xvbnkxLTIuMC4x L3NyYy9zbG9uaWsvZGJ1dGlsLmMKLS0tIHNsb255MS0yLjAuMS1vcmlnL3NyYy9zbG9uaWsvZGJ1 dGlsLmMgICAgICAgMjAwOC0wNC0yNCAwMDozNDoyMS4wMDAwMDAwMDAKKzA0MDAKKysrIHNsb255 MS0yLjAuMS9zcmMvc2xvbmlrL2RidXRpbC5jICAgIDIwMDktMDMtMDggMjM6MjY6MTguMDAwMDAw MDAwICswMzAwCkBAIC0xMTMsNCArMTEzLDUgQEAKICAgICAgICBQR2Nvbm4gICAgICpkYmNvbm47 CiAgICAgICAgU2xvbkRTdHJpbmcgICAgIHF1ZXJ5OworICAgICAgIFBHcmVzdWx0ICAgKnJlczsK CiAgICAgICAgZGJfbm90aWNlX3N0bXQgPSBzdG10OwpAQCAtMTQ0LDEwICsxNDUsMjAgQEAKCiAg ICAgICAgYWRtaW5mby0+ZGJjb25uID0gZGJjb25uOwotICAgICAgIGlmIChkYl9leGVjX2NvbW1h bmQoc3RtdCwgYWRtaW5mbywgJnF1ZXJ5KSA8IDApCisKKyAgICAgICByZXMgPSBQUWV4ZWMoYWRt aW5mby0+ZGJjb25uLCBkc3RyaW5nX2RhdGEoJnF1ZXJ5KSk7CisgICAgICAgaWYgKFBRcmVzdWx0 U3RhdHVzKHJlcykgIT0gUEdSRVNfQ09NTUFORF9PSyAmJgorICAgICAgICAgICAgICAgUFFyZXN1 bHRTdGF0dXMocmVzKSAhPSBQR1JFU19UVVBMRVNfT0sgJiYKKyAgICAgICAgICAgICAgIFBRcmVz dWx0U3RhdHVzKHJlcykgIT0gUEdSRVNfRU1QVFlfUVVFUlkpCiAgICAgICAgeworICAgICAgICAg ICAgICAgZnByaW50ZihzdGRlcnIsICIlczolZDogJXMgJXMgLSAlcyIsCisgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgc3RtdC0+c3RtdF9maWxlbmFtZSwgc3RtdC0+c3RtdF9sbm8sCisg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUFFyZXNTdGF0dXMoUFFyZXN1bHRTdGF0dXMo cmVzKSksCisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgZHN0cmluZ19kYXRhKCZxdWVy eSksClBRcmVzdWx0RXJyb3JNZXNzYWdlKHJlcykpOwogICAgICAgICAgICAgICAgcHJpbnRmKCJV bmFibGUgdG8gc2V0IGRhdGVzdHlsZVxuIik7CisgICAgICAgICAgICAgICBQUWNsZWFyKHJlcyk7 CiAgICAgICAgICAgICAgICBkc3RyaW5nX2ZyZWUoJnF1ZXJ5KTsKICAgICAgICAgICAgICAgIHJl dHVybiAtMTsKICAgICAgICB9CisgICAgICAgUFFjbGVhcihyZXMpOwogICAgICAgIGRzdHJpbmdf ZnJlZSgmcXVlcnkpOwogICAgICAgIHJldHVybiAwOwoKCgoKUC5TLgpXaHkgcG9zdGdyZXMgcm9s bHMgYmFjayBzZXNzaW9uIHZhcmlhYmxlIGFzc2lnbmVkIHZpYSAiU0VUCnNlc3Npb25fcmVwbGlj YXRpb25fcm9sZSBUTyBsb2NhbCI/IEJlY2F1c2UgaXQgaXMgdGhlIHN0YW5kYXJkIGJlaGF2aW91 ciwgYW5kCmhlcmUgaXMgYW4gaWxsdXN0cmF0aW9uOgoKcG9zdGdyZXM9IyBzaG93IHNlc3Npb25f cmVwbGljYXRpb25fcm9sZTsKLS0+IG9yaWdpbgpwb3N0Z3Jlcz0jIGJlZ2luOwotLT4gQkVHSU4K cG9zdGdyZXM9IyBzZXQgc2Vzc2lvbl9yZXBsaWNhdGlvbl9yb2xlIHRvIHJlcGxpY2E7Ci0tPiBT RVQKcG9zdGdyZXM9IyBzaG93IHNlc3Npb25fcmVwbGljYXRpb25fcm9sZTsKLS0+IHJlcGxpY2EK cG9zdGdyZXM9IyByb2xsYmFjazsKLS0+IFJPTExCQUNLCnBvc3RncmVzPSMgc2hvdyBzZSBzc2lv bl9yZXBsaWNhdGlvbl9yb2xlOwotLT4gb3JpZ2luCi0tLS0tLS0tLS0tLS0tIG5leHQgcGFydCAt LS0tLS0tLS0tLS0tLQpBbiBIVE1MIGF0dGFjaG1lbnQgd2FzIHNjcnViYmVkLi4uClVSTDogaHR0 cDovL2xpc3RzLnNsb255LmluZm8vcGlwZXJtYWlsL3Nsb255MS1nZW5lcmFsL2F0dGFjaG1lbnRz LzIwMDkwNTIyLzJlMmYxMThiL2F0dGFjaG1lbnQuaHRtCg==
- Previous message: [Slony1-general] serialization problem related to log shipping?
- Next message: [Slony1-general] sl_nodelock values ("pg_catalog".pg_backend_pid()); " - ERROR: duplicate key value
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list