AW: Disable TRUST authentication by using ClientAuthentication_hook

2018-07-13 Thread kpi6288
> -Ursprüngliche Nachricht- > Von: Tom Lane > > > If you're an server admin you can disable the extension (editing > > shared_pre_load_libraries GUC), change password and then enable the > > extension again... I am aware of this and all the other points. > Or more to the point:

Re: Disable TRUST authentication by using ClientAuthentication_hook

2018-07-13 Thread Guillaume Lelarge
2018-07-13 15:19 GMT+02:00 Fabrízio de Royes Mello : > > 2018-07-13 9:01 GMT-03:00 Guillaume Lelarge : > >> 2018-07-13 13:57 GMT+02:00 : >> >>> I’d like to disable the TRUST authentication method for certain servers >>> where modification of pg_hba.conf and restarting a service is fairly easy

Re: Disable TRUST authentication by using ClientAuthentication_hook

2018-07-13 Thread Fabrízio de Royes Mello
2018-07-13 9:01 GMT-03:00 Guillaume Lelarge : > 2018-07-13 13:57 GMT+02:00 : > >> I’d like to disable the TRUST authentication method for certain servers >> where modification of pg_hba.conf and restarting a service is fairly easy >> for a number of users. >> >> >> >> I looked at this example

AW: Disable TRUST authentication by using ClientAuthentication_hook

2018-07-13 Thread kpi6288
> I'm not sure this is such a good idea. You may need the trust authentication > method, > for example if you forgot the superuser password. Otherwise, there's good > chance > you might use the ClientAuthentication hook to do what you want. Thanks for your feedback. Klaus

Re: Disable TRUST authentication by using ClientAuthentication_hook

2018-07-13 Thread Guillaume Lelarge
2018-07-13 13:57 GMT+02:00 : > I’d like to disable the TRUST authentication method for certain servers > where modification of pg_hba.conf and restarting a service is fairly easy > for a number of users. > > > > I looked at this example https://wiki.postgresql.org/images/e/e3/Hooks_in_ >

Disable TRUST authentication by using ClientAuthentication_hook

2018-07-13 Thread kpi6288
I'd like to disable the TRUST authentication method for certain servers where modification of pg_hba.conf and restarting a service is fairly easy for a number of users. I looked at this example https://wiki.postgresql.org/images/e/e3/Hooks_in_postgresql.pdf It appears that creating a