Обсуждение: 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=

Re: BUG #14333: Remote connections for members of role in pg_hba.conf

От
Tom Lane
Дата:
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