Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aQnAT-0000oz-17 for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Feb 2016 02:27:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aQnAS-0001HL-2J for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Feb 2016 02:27:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aQn96-0008Eq-3O for pgsql-hackers@postgresql.org; Wed, 03 Feb 2016 02:26:16 +0000 Received: from mahout.postgresql.org ([2001:4800:1501:1::227]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aQn8w-0008Af-5o for pgsql-hackers@postgresql.org; Wed, 03 Feb 2016 02:26:14 +0000 Received: from coridan.postgresql.org ([2001:4800:1501:1::213]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aQn8t-0002IZ-6T for pgsql-hackers@postgresql.org; Wed, 03 Feb 2016 02:26:03 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aQn8s-0007sY-6p for pgsql-hackers@postgresql.org; Wed, 03 Feb 2016 02:26:02 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: pglogical - logical replication contrib module To: pgsql-hackers@postgresql.org From: Steve Singer Date: Wed, 03 Feb 2016 02:25:35 +0000 User-Agent: pgcommitfest X-cfsender: ssinger In-Reply-To: <20160123031740.21436.54292.pgcf@coridan.postgresql.org> References: <5685BB86.5010901@2ndquadrant.com> <20160123031740.21436.54292.pgcf@coridan.postgresql.org> Message-ID: <20160203022535.1291.78876.pgcf@coridan.postgresql.org> X-Pg-Spam-Score: -6.2 (------) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2gg dGhlIGNvbW1pdGZlc3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNr LXdvcmxkOiAgdGVzdGVkLCBmYWlsZWQKSW1wbGVtZW50cyBmZWF0dXJlOiAg ICAgICB0ZXN0ZWQsIGZhaWxlZApTcGVjIGNvbXBsaWFudDogICAgICAgICAg IG5vdCB0ZXN0ZWQKRG9jdW1lbnRhdGlvbjogICAgICAgICAgICB0ZXN0ZWQs IGZhaWxlZAoKSGVyZSBpcyBzb21lIG1vcmUgcmV2aWV3DQoNCistIGBwZ2xv Z2ljYWwucmVwbGljYXRpb25fc2V0X2FkZF90YWJsZShzZXRfbmFtZSBuYW1l LCB0YWJsZV9uYW1lIHJlZ2NsYXNzLCBzeW5jaHJvbml6ZSBib29sZWFuKWAN CisgIEFkZHMgYSB0YWJsZSB0byByZXBsaWNhdGlvbiBzZXQuDQorDQorICBQ YXJhbWV0ZXJzOg0KKyAgLSBgc2V0X25hbWVgIC0gbmFtZSBvZiB0aGUgZXhp c3RpbmcgcmVwbGljYXRpb24gc2V0DQorICAtIGB0YWJsZV9uYW1lYCAtIG5h bWUgb3IgT0lEIG9mIHRoZSB0YWJsZSB0byBiZSBhZGRlZCB0byB0aGUgc2V0 DQorICAtIGBzeW5jaHJvbml6ZWAgLSBpZiB0cnVlLCB0aGUgdGFibGUgZGF0 YSBpcyBzeW5jaHJvbml6ZWQgb24gYWxsIHN1YnNjcmliZXJzDQorICAgIHdo aWNoIGFyZSBzdWJzY3JpYmVkIHRvIGdpdmVuIHJlcGxpY2F0aW9uIHNldCwg ZGVmYXVsdCBmYWxzZQ0KKw0KDQpUaGUgYXJndW1lbnQgdG8gdGhpcyBmdW5j dGlvbiBpcyBhY3R1YWxseSBuYW1lZCAicmVsYXRpb24iIG5vdCAidGFibGVf bmFtZSIgdGhvdWdoIHdlIG1pZ2h0IHdhbnQgdG8gdXBkYXRlIHRoZSBmdW5j dGlvbiB0byBuYW1lIHRoZSBhcmd1bWVudCB0YWJsZV9uYW1lLg0KDQpBbHNv IHdlIGRvbid0IGV4cGxhaW4gd2hhdCAnc3luY2hyb25pemUnIG1lYW5zIEkg Zmlyc3QgdGhvdWdodCB0aGF0IGEgdmFsdWUgb2YgZmFsc2Ugd291bGQgbWVh biB0aGF0IGV4aXN0aW5nIGRhdGEgd29uJ3QgYmUgY29waWVkIGJ1dCBhbnkg bmV3IGNoYW5nZXMgd2lsbCBiZS4NCkEgdmFsdWUgb2YgZmFsc2UgYWN0dWFs bHkgc2VlbXMgdG8gbWVhbiB0aGF0IG5vdGhpbmcgd2lsbCBoYXBwZW4gd2l0 aCB0aGUgdGFibGUgdW50aWwgdGhlIHN5bmNocm9uaXplIGZ1bmN0aW9uIGlz IG1hbnVhbGx5IGNhbGxlZC4gV2Ugc2VlbSB0byBiZSB1c2luZyB0aGUgd29y ZCAnc3luY2hyb25pemUnIGluIGRpZmZlcmVudCBzZW5zZSBpbiBkaWZmZXJl bnQgcGxhY2VzIEkgZmluZCBpdCBjb25mdXNpbmcgKGllIHN5bmNocm9uaXpl X2RhdGEgYW5kIHN5bmNyb25pemVfc3RydWN0dXJlIGluIGNyZWF0ZV9zdWJz Y3JpcHRpb24pLg0KDQoNCg0KDQoNCioqKiBhL2NvbnRyaWIvcGdsb2dpY2Fs L3BnbG9naWNhbF9zeW5jLmMNCi0tLSBiL2NvbnRyaWIvcGdsb2dpY2FsL3Bn bG9naWNhbF9zeW5jLmMNCisgc3RhdGljIHZvaWQNCisgZHVtcF9zdHJ1Y3R1 cmUoUEdMb2dpY2FsU3Vic2NyaXB0aW9uICpzdWIsIGNvbnN0IGNoYXIgKnNu YXBzaG90KQ0KKyB7DQorICAgY2hhciAgICAgICAgcGdfZHVtcFtNQVhQR1BB VEhdOw0KKyAgIHVpbnQzMiAgICAgIHZlcnNpb247DQorICAgaW50ICAgICAg ICAgcmVzOw0KKyAgIFN0cmluZ0luZm9EYXRhICBjb21tYW5kOw0KKw0KKyAg IGlmIChmaW5kX290aGVyX2V4ZWNfdmVyc2lvbihteV9leGVjX3BhdGgsIFBH RFVNUF9CSU5BUlksICZ2ZXJzaW9uLCBwZ19kdW1wKSkNCisgICAgICAgZWxv ZyhFUlJPUiwgInBnbG9naWNhbCBzdWJzY3JpYmVyIGluaXQgZmFpbGVkIHRv IGZpbmQgcGdfZHVtcCByZWxhdGl2ZSB0byBiaW5hcnkgJXMiLA0KKyAgICAg ICAgICAgIG15X2V4ZWNfcGF0aCk7DQorDQorICAgaWYgKHZlcnNpb24gLyAx MDAgIT0gUEdfVkVSU0lPTl9OVU0gLyAxMDApDQorICAgICAgIGVsb2coRVJS T1IsICJwZ2xvZ2ljYWwgc3Vic2NyaWJlciBpbml0IGZvdW5kIHBnX2R1bXAg d2l0aCB3cm9uZyBtYWpvciB2ZXJzaW9uICVkLiVkLCBleHBlY3RlZCAlZC4l ZCIsDQorICAgICAgICAgICAgdmVyc2lvbiAvIDEwMCAvIDEwMCwgdmVyc2lv biAvIDEwMCAlIDEwMCwNCisgICAgICAgICAgICBQR19WRVJTSU9OX05VTSAv IDEwMCAvIDEwMCwgUEdfVkVSU0lPTl9OVU0gLyAxMDAgJSAxMDApOw0KKw0K KyAgIGluaXRTdHJpbmdJbmZvKCZjb21tYW5kKTsNCisgI2lmIFBHX1ZFUlNJ T05fTlVNIDwgOTA1MDANCisgICBhcHBlbmRTdHJpbmdJbmZvKCZjb21tYW5k LCAiJXMgLS1zbmFwc2hvdD1cIiVzXCIgLXMgLU4gJXMgLU4gcGdsb2dpY2Fs X29yaWdpbiAtRiBjIC1mIFwiL3RtcC9wZ2xvZ2ljYWwtJWQuZHVtcFwiIFwi JXNcIiIsDQorICNlbHNlDQorICAgYXBwZW5kU3RyaW5nSW5mbygmY29tbWFu ZCwgIiVzIC0tc25hcHNob3Q9XCIlc1wiIC1zIC1OICVzIC1GIGMgLWYgXCIv dG1wL3BnbG9naWNhbC0lZC5kdW1wXCIgXCIlc1wiIiwNCg0KMSkgSSBhbSBu b3Qgc3VyZSB3ZSBjYW4gYXNzdW1lL3JlcXVpcmUgdGhhdCB0aGUgcGdfZHVt cCBiaW5hcnkgYmUgaW4gdGhlIHNhbWUgbG9jYXRpb24gYXMgdGhlIHBvc3Rn cmVzIGJpbmFyeS4gIEkgZG9uJ3Qga25vdyB0aGluayB3ZSd2ZSBldmVyIHJl cXVpcmVkIHRoYXQgY2xpZW50IGJpbmFyaWVzIChpZSBwc3FsLCBwZ19kdW1w LCBwZ19yZXN0b3JlIC4uLikgYmUgaW4gdGhlIHNhbWUgZGlyZWN0b3J5IGFz IHBvc3RncmVzLiAgcGdfdXBncmFkZSBkb2VzIHJlcXVpcmUgdGhpcyBzbyBt YXliZSB0aGlzIGlzbid0IGEgcHJvYmxlbSBpbiBwcmFjdGljZSBidXQgSSB0 aG91Z2h0IEknZCBwb2ludCBpdCBvdXQuIElkZWFsbHkgd291bGRuJ3QgbmVl ZCB0byBjYWxsIGFuIGV4dGVybmFsIHByb2dyYW0gdG8gZ2V0IGEgc2NoZW1h IGR1bXAgYnV0IHR1cm5pbmcgcGdfZHVtcCBpbnRvIGEgbGlicmFyeSBpcyBi ZXlvbmQgdGhlIHNjb3BlIG9mIHRoaXMgcGF0Y2guDQoNCg0KMikgSSBkb24n dCB0aGluayB3ZSBjYW4gaGFyZC1jb2RlZCAvdG1wIGFzIHRoZSBkaXJlY3Rv cnkgZm9yIHRoZSBzY2hlbWEgZHVtcC4gIEkgZG9uJ3QgdGhpbmsgd2lsbCB3 b3JrIG9uIG1vc3Qgd2luZG93cyBzeXN0ZW1zIGFuZCBldmVuIG9uIGEgdW5p eCBzeXN0ZW0gJFRNUERJUiBtaWdodCBiZSBzZXQgdG8gc29tZXRoaW5nIGVs c2UuICBNYXliZSB3cml0aW5nIHRoaXMgaW50byBwZ3NxbF90bXAgd291bGQg YmUgYSBiZXR0ZXIgY2hvaWNlLiAgDQoNCkZ1cnRoZXJkb3duIGluDQpwZ2xv Z2ljYWxfc3luY19zdWJzY3JpcHRpb24oUEdMb2dpY2FsU3Vic2NyaXB0aW9u ICpzdWIpDQorICAgc3dpdGNoIChzdGF0dXMpDQorICAgew0KKyAgICAgICAv KiBBbHJlYWR5IHN5bmNlZCwgbm90aGluZyB0byBkbyBleGNlcHQgY2xlYW51 cC4gKi8NCisgICAgICAgY2FzZSBTWU5DX1NUQVRVU19SRUFEWToNCisgICAg ICAgICAgIE1lbW9yeUNvbnRleHREZWxldGUobXljdHgpOw0KKyAgICAgICAg ICAgcmV0dXJuOw0KKyAgICAgICAvKiBXZSBjYW4gcmVjb3ZlciBmcm9tIGNy YXNoZXMgZHVyaW5nIHRoZXNlLiAqLw0KKyAgICAgICBjYXNlIFNZTkNfU1RB VFVTX0lOSVQ6DQorICAgICAgIGNhc2UgU1lOQ19TVEFUVVNfQ0FUQ0hVUDoN CisgICAgICAgICAgIGJyZWFrOw0KKyAgICAgICBkZWZhdWx0Og0KKyAgICAg ICAgICAgZWxvZyhFUlJPUiwNCisgICAgICAgICAgICAgICAgInN1YnNjcmli ZXIgJXMgaW5pdGlhbGl6YXRpb24gZmFpbGVkIGR1cmluZyBub25yZWNvdmVy YWJsZSBzdGVwICglYyksIHBsZWFzZSB0cnkgdGhlIHNldHVwIGFnYWluIiwN CisgICAgICAgICAgICAgICAgc3ViLT5uYW1lLCBzdGF0dXMpOw0KKyAgICAg ICAgICAgYnJlYWs7DQorICAgfQ0KDQpJIHRoaW5rIHRoZSBkZWZhdWx0IGNh c2UgbmVlZHMgdG8gZG8gc29tZXRoaW5nIHRvIHVucmVnaXN0ZXIgdGhlIGJh Y2tncm91bmQgd29ya2VyLiAgV2UgYWxyZWFkeSBkaXNjdXNzZWQgdHJ5aW5n IHRvIGdldCB0aGUgZXJyb3IgbWVzc2FnZSB0byBhIHVzZXIgaW4gYSBiZXR0 ZXIgd2F5IGVpdGhlciB3YXkgdGhlcmUgaXNuJ3QgYW55IHNlbnNlIGluIHRo aXMgYmFja2dyb3VuZCB3b3JrZXIgYmVpbmcgbGF1bmNoZWQgYWdhaW4gaWYg dGhlIGVycm9yIGlzIG5vbnJlY292ZXJhYmxlLg0KDQoNCisNCisgICAgICAg ICAgICAgICB0YWJsZXMgPSBjb3B5X3JlcGxpY2F0aW9uX3NldHNfZGF0YShz dWItPm9yaWdpbl9pZi0+ZHNuLA0KKyAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIHN1Yi0+dGFyZ2V0X2lmLT5k c24sDQorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgc25hcHNob3QsDQorICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgc3ViLT5yZXBsaWNhdGlv bl9zZXRzKTsNCisNCisgICAgICAgICAgICAgICAvKiBTdG9yZSBpbmZvIGFi b3V0IGFsbCB0aGUgc3luY2hyb25pemVkIHRhYmxlcy4gKi8NCisgICAgICAg ICAgICAgICBTdGFydFRyYW5zYWN0aW9uQ29tbWFuZCgpOw0KKyAgICAgICAg ICAgICAgIGZvcmVhY2ggKGxjLCB0YWJsZXMpDQoNClNob3VsZG4ndCB3ZSBi ZSBzdG9yaW5nIHRoZSBpbmZvIGFib3V0IHRoZSBzeW5jaHJvbml6ZWQgdGFi bGVzIGFzIHBhcnQgb2YgdGhlIHNhbWUgdHJhbnNhY3Rpb24gdGhhdCBkb2Vz IHRoZSBzeW5jPyAgDQoNCg0KSSdsbCBrZWVwaW5nIGdvaW5nIHRocm91Z2gg dGhlIGNvZGUgYXMgSSBoYXZlIHRpbWUuICAgSSB0aGluayBpdCBpcyBhcHBy b3ByaWF0ZSB0byBtb3ZlIHRoaXMgdG8gdGhlIG5leHQgQ0Ygc2luY2UgdGhl IENGIGlzIHBhc3QgdGhlIGVuZCBkYXRlIGFuZCB0aGUgcGF0Y2ggaGFzIHJl Y2VpdmVkIHNvbWUgcmV2aWV3LiAgIFdoZW4geW91IGhhdmUgYW4gdXBkYXRl ZCB2ZXJzaW9uIG9mIHRoZSBwYXRjaCBwb3N0IGl0LCBkb24ndCB3YWl0IHVu dGlsIE1hcmNoLgotLSAKU2VudCB2aWEgcGdzcWwtaGFja2VycyBtYWlsaW5n IGxpc3QgKHBnc3FsLWhhY2tlcnNAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2Ug Y2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0 Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1oYWNrZXJzCg==