Обсуждение: BUG #14333: Remote connections for members of role in pg_hba.conf
BUG #14333: Remote connections for members of role in pg_hba.conf
От
brodgers3@oreillyauto.com
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDMzMwpMb2dnZWQgYnk6ICAg ICAgICAgIEIuIFJvZGdlcnMKRW1haWwgYWRkcmVzczogICAgICBicm9kZ2Vy czNAb3JlaWxseWF1dG8uY29tClBvc3RncmVTUUwgdmVyc2lvbjogOS4zLjEz Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDE0LjA0LjQgTFRTCkRlc2Ny aXB0aW9uOiAgICAgICAgCgotLS0gY3JlYXRlIGEgcm9sZSAicmVhZF9ncm91 cCIgd2l0aCBwZXJtaXNzaW9ucyB0byBjb25uZWN0IGFuZCBzZWxlY3Qgb24g YWxsCm9iamVjdHMNCg0KLS0tIFNpbWlsYXIsIGNyZWF0ZSBuZXcgdXNlciB0 byBiZSBtYW5hZ2VkIGJ5ICJyZWFkX2dyb3VwIiBwZXJtaXNzaW9ucyAtLS0N CkNSRUFURSBST0xFIG15dXNlciBMT0dJTiBDT05ORUNUSU9OIExJTUlUIDU7 DQpHUkFOVCByZWFkX2dyb3VwIFRPIG15dXNlcjsNCg0KDQotLS0gVmVyaWZ5 IHVzZXIgZXhpc3RzIGFuZCBpcyBtZW1iZXIgb2YgZ3JvdXAgInJlYWRfZ3Jv dXAiIC0tLQ0KbXlkYj0+IFxkZyBteXVzZXINCiAgICAgICAgICAgICAgICBM aXN0IG9mIHJvbGVzDQogUm9sZSBuYW1lIHwgIEF0dHJpYnV0ZXMgICB8ICAg IE1lbWJlciBvZg0KLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tKy0tLS0t LS0tLS0tLS0tLS0tLQ0KICBteXVzZXIgICB8IDUgY29ubmVjdGlvbnMgfCB7 cmVhZF9ncm91cH0NCg0KDQotLS0gcGdfaGJhLmNvbmYgZW50cnkgaW50ZW5k ZWQgdG8gYWxsb3cgbWVtYmVycyBvZiAicmVhZF9ncm91cCIgdG8gY29ubmVj dAotLS0NCmhvc3QgbXlkYiArcmVhZF9ncm91cCAxNzIuWFguWVkuMC8yNCBt ZDUNCg0KICANCi0tLSBFcnJvciByZWNlaXZlZCB1cG9uIGF0dGVtcHRpbmcg cmVtb3RlIGNvbm5lY3Rpb24gLS0tDQpGQVRBTDogbm8gcGdfaGJhLmNvbmYg ZW50cnkgZm9yIGhvc3QgIjE3Mi5YWC5ZWS5aWiIsIHVzZXIgIm15dXNlciIs IGRhdGFiYXNlCiJteWRiIiwgU1NMIG9mZg0KDQoNCg0KRXhwZWN0ZWQgZWl0 aGVyIHZhbGlkIGNvbm5lY3Rpb24gb3IgcGFzc3dvcmQgZXJyb3IuDQoNCg0K TG9va2luZyB0byBjb250cm9sIGFyYml0cmFyeSBsYXJnZSBsaXN0IG9mIHVz ZXJzIHdpdGgganVzdCBhIGNvdXBsZSBtYW5hZ2VkCnJvbGVzIHN1Y2ggYXMg InJlYWQiIG9yICJ3cml0ZSIgZ3JvdXBzIHN1Y2ggdGhhdCBvbmx5IHRoZSAi cmVhZCIgYW5kICJ3cml0ZSIKZ3JvdXBzIGFyZSBzcGVjaWZpZWQgaW4gcGxh Y2VzIGxpa2UgcGdfaGJhLmNvbmYuCgo=
brodgers3@oreillyauto.com writes: > --- Error received upon attempting remote connection --- > FATAL: no pg_hba.conf entry for host "172.XX.YY.ZZ", user "myuser", database > "mydb", SSL off > Expected either valid connection or password error. This example works for me (after suitable adjustment of the IP addresses). Only theory that comes to mind offhand is that you forgot to tell the postmaster to reload the pg_hba.conf file after you edited it (via pg_ctl reload, SIGHUP, etc). regards, tom lane