How to change the authentication's host?

HyeontaeJu

I try to change host of authentication becase server's host is changed..

I used below query but error message is occured

How can i change the authentication's host?

Jim_Knicely

Remove the SET keyword from your command.

Example:

verticademos=> CREATE AUTHENTICATION jim METHOD 'hash' HOST '10.10.10.0';
CREATE AUTHENTICATION

verticademos=> ALTER AUTHENTICATION jim HOST '10.10.10.0/32';
ALTER AUTHENTICATION

See: ALTER AUTHENTICATION