Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ycvoj-0003Fj-KM for pgsql-admin@arkaria.postgresql.org; Tue, 31 Mar 2015 13:02:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Ycvoi-0002g7-Ss for pgsql-admin@arkaria.postgresql.org; Tue, 31 Mar 2015 13:02:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Ycvoi-0002g1-17 for pgsql-admin@postgresql.org; Tue, 31 Mar 2015 13:02:52 +0000 Received: from mgap1a-mgmt.jacksonnational.com ([12.148.227.39]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YcvoW-00057U-2F for pgsql-admin@postgresql.org; Tue, 31 Mar 2015 13:02:50 +0000 X-IronPort-AV: E=Sophos;i="5.11,501,1422939600"; d="scan'208";a="221325010" Received: from vtunpep1a.jacksonnational.com (HELO usprhcp03a.pgdsresource.local) ([10.8.111.30]) by mgap1a-mgmt.jacksonnational.com with ESMTP; 31 Mar 2015 09:02:35 -0400 Received: from USPRMBP01C.pgdsresource.local ([10.11.103.11]) by usprhcp03a.pgdsresource.local ([fe80::c5d8:ddaa:1c5b:9f3b%15]) with mapi id 14.03.0195.001; Tue, 31 Mar 2015 09:02:33 -0400 From: "Rossi, Maria" To: 'Jerry Sievers' , Scott Whitney CC: Scott Ribe , "pgsql-admin@postgresql.org" Subject: Re: Suppress 'duplicate key' at errorlog? Thread-Topic: [ADMIN] Suppress 'duplicate key' at errorlog? Thread-Index: AQHQa008AwEuMmThSCWoZy0EakUst502ic0A Date: Tue, 31 Mar 2015 13:02:32 +0000 Message-ID: <33A4D5087BF0D44DA69C5EEF666BC1D7426436CD@usprmbp01c> References: <33A4D5087BF0D44DA69C5EEF666BC1D74263DD2C@usprmbp01c> <1162433235.755302.1427760768118.JavaMail.zimbra@zimbra.int.journyx.com> <86oana3s1o.fsf@jerry.enova.com> In-Reply-To: <86oana3s1o.fsf@jerry.enova.com> Accept-Language: en-US, en-GB Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.8.96.1] x-tm-as-product-ver: SMEX-11.0.0.1251-7.500.1018-21436.007 x-tm-as-result: No--52.966300-0.000000-31 x-tm-as-user-approved-sender: Yes x-tm-as-user-blocked-sender: No Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-DLP-JNL: Passed X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org VGhhbmtzIGZvciBhbGwgdGhlIGNvbW1lbnRzL3N1Z2dlc3Rpb25zLg0KDQpB cyBJIG1lbnRpb25lZCwgdGhpcyBpcyBhIDNyZC1wYXJ0eSBzb2Z0d2FyZSBz byB3aGF0IEkgY2FuIGRvIHRvIGl0IGlzIG5vbmUgb3IgbGltaXRlZCBhdCBi ZXN0LiAgICAgSSB3aWxsIHRyeSB0byBmaWx0ZXIgdGhlIGVycm9ybG9nLiAg QW5vdGhlciBvcHRpb24gaXMgdG8gc2V0IHRoZSBsb2dfbWluX21lc3NhZ2Vz IGFuZCBsb2dfbWluX2Vycm9yX3N0YXRlbWVudCB0byBsb2cuDQoNCk1hcmlh IA0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogSmVycnkg U2lldmVycyBbbWFpbHRvOmdzaWV2ZXJzMTlAY29tY2FzdC5uZXRdIA0KU2Vu dDogTW9uZGF5LCBNYXJjaCAzMCwgMjAxNSA4OjU0IFBNDQpUbzogU2NvdHQg V2hpdG5leQ0KQ2M6IFNjb3R0IFJpYmU7IFJvc3NpLCBNYXJpYTsgcGdzcWwt YWRtaW5AcG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBbQURNSU5dIFN1 cHByZXNzICdkdXBsaWNhdGUga2V5JyBhdCBlcnJvcmxvZz8NCg0KU2NvdHQg V2hpdG5leSA8c2NvdHRAam91cm55eC5jb20+IHdyaXRlczoNCg0KPiBBbSBJ IHRoZSBvbmx5IG9uZSBjb25jZXJuZWQgYWJvdXQgYSBwcm9kdWN0IHRyeWlu ZyB0byBkdXBsaWNhdGUgYSANCj4gcGtleT8gVGhpcyBpcyBub3QgdXN1YWxs eSB0aGUgTEFTVCBzdGVwLiBJdCdzIGVhcmx5IG9uIGluIHRoZSBsb2dpY2Fs IHByb2Nlc3MuIFlvdSBoYXZlIHRvIGZpbmQgYW5kIHNvbHZlIHRoZSB1bmRl cmx5aW5nIGNhdXNlLg0KDQpJJ3ZlIHNlZW4gbGF6eSBkZXZlbG9wZXJzIHVz ZSBhIHRyeSBpbnNlcnQvdXBkYXRlIGlmIGZhaWwgdG8gaW1wbGVtZW50IGEg cG9vciBtYW4ncyB1cHNlcnQuLi4gIGEgZmVhdHVyZSBtdWNoIHNvdWdodCBh ZnRlciBhbmQgb25seSBub3cgYmVpbmcgc2VyaW91c2x5IGRldmVsb3BlZCBm b3IgUG9zdGdyZXMuDQoNClNvLi4uIHdoZXRoZXIgb3Igbm90IGl0J3MgYSBi dWcgaXMgYXBwbGljYXRpb24gZGVwZW5kZW50Lg0KDQpZZXMgSSdkIHF1ZXN0 aW9uIGEgM3JkIHBhcnR5IGFib3V0IHRoaXMgaWYgdGhlIHByb2R1Y3Qgd2Fz bid0IGRldmVsb3BlZCBpbiBob3VzZSBhbmQvb3IgZnVsbHkgb3BlbiB0byBj b2RlIHJldmlldyB0byBoYXZlIHRoZW0gdGVsbCBtZSAid2UgZGlkIGl0IHRo YXQgd2F5IG9uIHB1cnBvc2UiIHRob3VnaCByYXRoZXIgdGhhbiBqdXN0IGRl Y2xhcmluZyBpdCBhIG51aXNhbmNlLg0KDQpGV0lXDQoNCg0KPiBPbiBNb24s IE1hciAzMCwgMjAxNSBhdCA2OjE3IFBNLCBTY290dCBSaWJlIDxzY290dF9y aWJlQGVsZXZhdGVkLWRldi5jb20+IHdyb3RlOg0KPg0KPiAgICAgT24gTWFy IDMwLCAyMDE1LCBhdCAzOjAzIFBNLCBSb3NzaSwgTWFyaWEgPG1hcmlhLnJv c3NpQHVzLnBnZHMuY29tPiB3cm90ZToNCj4gICAgID4NCj4gICAgID4gSGks DQo+ICAgICA+IA0KPiAgICAgPiBJcyB0aGVyZSBhIHdheSB0byBzdXBwcmVz cyBhIMOi4oKsy5xkdXBsaWNhdGUga2V5w6LigqzihKIgbXNnICBmcm9tIHRo ZSBlcnJvcmxvZz8gIER1ZSB0byBhIGJ1ZyBpbiBhIDNyZCBwYXJ0eSBhcHBs aWNhdGlvbiwgIHRoaXMga2VlcHMgb24gYXBwZWFyaW5nIGFuZCBJIGFtIGNv bmNlcm5lZCB0aGF0IGl0DQo+ICAgICB3aWxsIGZpbGwgdXAgdGhlIGZpbGVz eXN0ZW0uICAgIEkgY2FuIGRlbGV0ZSAgdGhlIG9sZCBlcnJvcmxvZywgIGJ1 dCBpZiB0aGVyZSBpcyBhbnkgb3RoZXIgbWVhbmluZ2Z1bCBtc2dzIG91dCB0 aGVyZSwgSSB3b3VsZCBsb3NlIHRoYXQgdG9vLg0KPiAgICANCj4gICAgIE5v IHdheSB0byB0dXJuIG9mZiB0aGF0IHNwZWNpZmljIGVycm9yIG1lc3NhZ2Us IGJ1dCB5b3UgY291bGQgZmlsdGVyIHRoZW0gb3V0IG9mIHRoZSBsb2csIGJl aW5nIGNhcmVmdWwgb2YgY291cnNlIG5vdCB0byBmaWx0ZXIgYW55IG1lc3Nh Z2VzIHdoaWNoIG1pZ2h0IGJlIG1vcmUNCj4gICAgIG1lYW5pbmdmdWwuIFlv dSBjb3VsZCBhbHNvIHByZXZlbnQgdGhlIGVycm9ycyBmcm9tIGJlaW5nIHJh aXNlZCBieSB1c2luZyBhIHRyaWdnZXIsIGJ1dCBJIGRvbid0IGxpa2UgdGhh dCBpZGVhIHZlcnkgbXVjaCBhdCBhbGwuDQo+DQo+ICAgICAtLQ0KPiAgICAg U2NvdHQgUmliZQ0KPiAgICAgc2NvdHRfcmliZUBlbGV2YXRlZC1kZXYuY29t DQo+ICAgICBodHRwOi8vd3d3LmVsZXZhdGVkLWRldi5jb20vDQo+ICAgICBo dHRwczovL3d3dy5saW5rZWRpbi5jb20vaW4vc2NvdHRyaWJlLw0KPiAgICAg KDMwMykgNzIyLTA1Njcgdm9pY2UNCj4NCj4gICAgIC0tDQo+ICAgICBTZW50 IHZpYSBwZ3NxbC1hZG1pbiBtYWlsaW5nIGxpc3QgKHBnc3FsLWFkbWluQHBv c3RncmVzcWwub3JnKQ0KPiAgICAgVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIg c3Vic2NyaXB0aW9uOg0KPiAgICAgaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9y Zy9tYWlscHJlZi9wZ3NxbC1hZG1pbg0KPg0KDQotLQ0KSmVycnkgU2lldmVy cw0KUG9zdGdyZXMgREJBL0RldmVsb3BtZW50IENvbnN1bHRpbmcNCmU6IHBv c3RncmVzLmNvbnN1bHRpbmdAY29tY2FzdC5uZXQNCnA6IDMxMi4yNDEuNzgw MA0KCi0tIApTZW50IHZpYSBwZ3NxbC1hZG1pbiBtYWlsaW5nIGxpc3QgKHBn c3FsLWFkbWluQHBvc3RncmVzcWwub3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8g eW91ciBzdWJzY3JpcHRpb246Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcv bWFpbHByZWYvcGdzcWwtYWRtaW4K