postgresql 9.2 - postgres dblink behavior difference between 9.2.3 and 9.2.4 -


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