Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hWjv1-0005el-PW for pgsql-bugs@arkaria.postgresql.org; Fri, 31 May 2019 15:58:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hWjv0-0002ze-9g for pgsql-bugs@arkaria.postgresql.org; Fri, 31 May 2019 15:58:10 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1hWjv0-0002zX-1d for pgsql-bugs@lists.postgresql.org; Fri, 31 May 2019 15:58:10 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hWjuv-0001I1-LP for pgsql-bugs@lists.postgresql.org; Fri, 31 May 2019 15:58:09 +0000 Content-Type: multipart/mixed; boundary="===============4659522879670973707==" MIME-Version: 1.0 Subject: BUG #15827: Unable to connect on Windows using pg_services.conf using Python psycopg2 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jgr@geomaster.pt Reply-To: jgr@geomaster.pt, pgsql-bugs@lists.postgresql.org Date: Fri, 31 May 2019 15:57:40 +0000 Message-ID: <15827-e6ba53a3a7ed543c@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4659522879670973707== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTgyNwpMb2dnZWQgYnk6ICAgICAgICAgIEpvcmdlIEd1c3Rhdm8gUm9j aGEKRW1haWwgYWRkcmVzczogICAgICBqZ3JAZ2VvbWFzdGVyLnB0ClBvc3RncmVTUUwgdmVyc2lv bjogMTAuOApPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MKRGVzY3JpcHRpb246ICAgICAgICAK CkhpLA0KDQpJdCBpcyBteSBmaXN0IHJlcG9ydCwgc28gcGxlYXNlIGJlIGdlbnRsZS4gSSBuZWVk IHNvbWUgaGVscCB0byBpZGVudGlmeSB0aGUKcHJvYmxlbSBwcm9wZXJseS4NCg0KMS4gRGVzY3Jp cHRpb24NCg0KSSdtIHVzaW5nIGBwZ19zZXJ2aWNlcy5jb25mYCB0byBwcm92aWRlIGFjY2VzcyB0 byBhIFBvc3RncmVzcWwgZGF0YWJhc2UuDQoNClRoZSBwZ19zZXJ2aWNlcy5jb25mIGZpbGUgaXM6 DQoNCltwZ190cmFiYWxob10NCmhvc3Q9MTkyLjE2OC4xLjI0DQpwb3J0PTU0MzINCmRibmFtZT10 cmFiYWxobw0KDQpUaGUgc2VydmljZXMgYXJlIHdvcmtpbmcgd2VsbCwgZWl0aGVyIG9uIFVidW50 dSBhbmQgb24gV2luZG93cy4gSSdtIHVzaW5nClFHSVMgdG8gYWNjZXNzIHRoZSBkYXRhYmFzZSBh bmQgaXQgd29ya3Mgd2VsbC4gUUdJUyBpcyB1c2luZyBjcHAgY29kZSB0bwphY2Nlc3MgdGhlIGRh dGFiYXNlLg0KDQpJIGNhbiBhbHNvIGNvbm5lY3Qgb24gdGhlIGNvbW1hbmQgbGluZSwgdXNpbmc6 DQpwc3FsIHNlcnZpY2U9cGdfdHJhYmFsaG8gDQphcyBpbiB0aGUgZm9sbG93aW5nIGV4YW1wbGU6 DQoNCmpnckB6b2U6fiQgcHNxbCBzZXJ2aWNlPXBnX3RyYWJhbGhvDQpwc3FsICgxMC44IChVYnVu dHUgMTAuOC0wdWJ1bnR1MC4xOC4xMC4xKSkNClNTTCBjb25uZWN0aW9uIChwcm90b2NvbDogVExT djEuMiwgY2lwaGVyOiBFQ0RIRS1SU0EtQUVTMjU2LUdDTS1TSEEzODQsCmJpdHM6IDI1NiwgY29t cHJlc3Npb246IG9mZikNClR5cGUgImhlbHAiIGZvciBoZWxwLg0KDQp0cmFiYWxobz0+IA0KDQpT bywgSSB0aGluayB0aGUgcGdfc2VydmljZXMgYXJlIHByb3Blcmx5IGNvbmZpZ3VyZWQgYW5kIHdv cmtpbmcuDQoNCjIuIFByb2JsZW0NCg0KSW4gV2luZG93cywgSSdtIG5vdCBhYmxlIHRvIGNvbm5l Y3QgdXNpbmcgcHN5Y29wZzIuIFRoZSBmb2xsb3dpbmcgY29kZSBkb2VzCm5vdCB3b3JrIG9uIFdp bmRvd3MuDQoNCmltcG9ydCBwc3ljb3BnMg0KDQpwcmludCAocHN5Y29wZzIuX192ZXJzaW9uX18p DQpjb25uZWN0aW9uID0gcHN5Y29wZzIuY29ubmVjdChzZXJ2aWNlPSdwZ190cmFiYWxobycpDQoj IGNvbm5lY3Rpb24gPSBwc3ljb3BnMi5jb25uZWN0KHVzZXIgPSAiY21iLnVzZXIiLCBwYXNzd29y ZCA9ICJ4eHh4eHh4IiwKaG9zdCA9ICIxOTIuMTY4LjEuMjQiLCBwb3J0ID0gIjU0MzIiLCBkYXRh YmFzZSA9ICJ0cmFiYWxobyIpDQpjdXJzb3IgPSBjb25uZWN0aW9uLmN1cnNvcigpDQpwcmludCAo IGNvbm5lY3Rpb24uZ2V0X2Rzbl9wYXJhbWV0ZXJzKCksIlxuIikNCmN1cnNvci5leGVjdXRlKCJT RUxFQ1QgdmVyc2lvbigpOyIpDQpyZWNvcmQgPSBjdXJzb3IuZmV0Y2hvbmUoKQ0KcHJpbnQoIkNv bm5lY3RlZCB0byAtICIsIHJlY29yZCwiXG4iKQ0KDQpJdCB3b3JrcyB3ZWxsIGluIFVidW50dSwg YnV0IG5vdCBvbiBXaW5kb3dzLiBCb3RoIHdvcmtzIHdlbGwgaWYgcGdfc2VydmljZXMKYXJlIG5v dCB1c2VkLCBhbmQgdGhlIGNvbm5lY3Rpb24gaXMgbWFkZSB1c2luZyBgY29ubmVjdCh1c2VyID0g ImNtYi51c2VyIiwKcGFzc3dvcmQgPSAieHh4eHh4eCIsIGhvc3QgPSAiMTkyLjE2OC4xLjI0Iiwg cG9ydCA9ICI1NDMyIiwgZGF0YWJhc2UgPQoidHJhYmFsaG8iKS4NCg0KMy4gRXJyb3Igb24gV2lu ZG93cw0KDQpUaGlzIGlzIHRoZSBlcnJvciByZXBvcnRlZCBpbiBXaW5kb3dzOg0KDQoyLjcuNSAo ZHQgZGVjIHBxMyBleHQgbG82NCkNClRyYWNlYmFjayAobW9zdCByZWNlbnQgY2FsbCBsYXN0KToN CiAgRmlsZSAiQzpcT1NHRU80fjFcYXBwc1xQeXRob24zN1xsaWJcY29kZS5weSIsIGxpbmUgOTAs IGluIHJ1bmNvZGUNCiAgICBleGVjKGNvZGUsIHNlbGYubG9jYWxzKQ0KICBGaWxlICI8aW5wdXQ+ IiwgbGluZSAxLCBpbiA8bW9kdWxlPg0KICBGaWxlICI8c3RyaW5nPiIsIGxpbmUgNCwgaW4gPG1v ZHVsZT4NCiAgRmlsZSAiQzpcT1NHRU80fjFcYXBwc1xQeXRob24zN1xsaWJcc2l0ZS1wYWNrYWdl c1xwc3ljb3BnMlxfX2luaXRfXy5weSIsCmxpbmUgMTMwLCBpbiBjb25uZWN0DQogICAgY29ubiA9 IF9jb25uZWN0KGRzbiwgY29ubmVjdGlvbl9mYWN0b3J5PWNvbm5lY3Rpb25fZmFjdG9yeSwgKipr d2FzeW5jKQ0KcHN5Y29wZzIuT3BlcmF0aW9uYWxFcnJvcjogY291bGQgbm90IHRyYW5zbGF0ZSBo b3N0IG5hbWUgIjE5Mi4xNjguMS4yNA0KIiB0byBhZGRyZXNzOiBVbmtub3duIGhvc3QNCg0KNC4g V2hhdCBJIGhhdmUgdHJpZWQNCg0KSSByZXBvcnQgdGhpcyBhcyBhIFFHSVMgcHJvYmxlbSBbMV0s IGJ1dCBzb29uIEkndmUgcmVhbGl6ZSB0aGF0IGl0IHdhcyBhCnBzeWNvcGcyIHByb2JsZW0uDQoN CkkgcmVwb3J0IHRoaXMgYXMgYSBwc3ljb3BnMiBwcm9ibGVtIFsyXSwgYnV0IHBzeWNvcGcyIGp1 c3QgcGFzc2VzIHRoZQpwYXJhbWV0ZXJzIGRvd24gdG8gbGlicHEgbGlicmFyeSBhbmQgdGhlIGlz c3VlIHdhcyBjbG9zZWQuDQoNCkZyb20gb3RoZXIncyBmZWVkYmFjaywgSSd2ZSB0cmllZCB0byB1 c2UgdGhlIGxpbmUgc2VwYXJhdG9ycyBpbgpwZ19zZXJ2aWNlcy5jb25mIHdpdGggXG4gYW5kIFxy XG4sIGJ1dCB0aGUgcmVzdWx0IGlzIHRoZSBzYW1lIChiZWNhdXNlIHRoZXJlCmlzIHN0cmFuZ2Ug bmV3bGluZSBhZnRlciB0aGUgaG9zdCBhZGRyZXNzKS4NCg0KSSd2ZSB0cmllZCB3aXRoIHRoZSBo b3N0bmFtZSBhbmQgSVAgYWRkcmVzcy4NCg0KRGVmaW5pdGVseSwgaXQgaXMgbm90IGEgcGdfc2Vy dmljZXMuY29uZiBzeW50YXgsIGJlY2F1c2UgcHNxbCBhbHNvIHJ1bnMgZmluZQpvbiBXaW5kb3dz IFszXS4gUHJpbnQgc2NyZWVuIGlzIGF0dGFjaGVkLg0KDQpJJ20gdXNpbmcgcHN5Y29wZzIgMi43 LjUsIG9uIFdpbmRvd3MgMTAuDQoNCldobyBzaG91bGQgSSBkbyB0byBoZWxwIGJldHRlciBpZGVu dGlmeSB0aGUgcHJvYmxlbT8gDQoNClsxXSBodHRwczovL2dpdGh1Yi5jb20vcWdpcy9RR0lTL2lz c3Vlcy8zMDAyNw0KWzJdIGh0dHBzOi8vZ2l0aHViLmNvbS9wc3ljb3BnL3BzeWNvcGcyL2lzc3Vl cy85MjYNClszXSBodHRwczovL2dpc3QuZ2l0aHViLmNvbS9qZ3JvY2hhL2EzYThiYzJkMjQ3NjM4 NjQ1MGVkNGQ4ZDM2MjlmZTMyCgo= --===============4659522879670973707==--