i observing difference in behavior of dblink between 9.2.3 , 9.2.4. have 2 servers identical postgres.conf , pg_hba.conf. 1 on version 9.2.3 , 1 on 9.2.4
9.2.3
pg_hba.conf has
local dblinkuser trust
then connect database using ordinary user
theater_map=# select dblink_connect('dbname=theaterdb user=dblinkuser password=dbl123'); dblink_connect ---------------- ok (1 row)
success in connection.
9.2.4
my pg_hba.conf has same entry above
theater_map=> select dblink_connect('dbname=theaterdb user=dblinkuser password=dbl123'); error: password required detail: non-superuser cannot connect if server not request password. hint: target server's authentication method must changed.
now change pg_hba.conf on 9.2.4 below
local dblinkuser md5
and restart postgres
theater_map=> select dblink_connect('dbname=theaterdb user=dblinkuser password=dbl123'); dblink_connect ---------------- ok (1 row)
i checked change log between versions 9.2.3 , 9.2.4 not find details.
note: changing auth method trust md5 on 9.2.3 not make difference , still works.
Comments
Post a Comment