ALTER REMOTE SERVER ​

Make changes to an existing remote server that is used for replication.

ALTER REMOTE SERVER name
WITH ([HOST remote_host_name] [,] [SQL_PORT number] )

You can change the remote host name or the SQL port number. You cannot change the NOHOSTNAMECHECK option; use CREATE OR REPLACE REMOTE SERVER to modify that setting.

Examples ​

premdb_rep=# alter remote server ybd_repl_svr 
with(sql_port 5432);
ALTER REMOTE SERVER

premdb_rep=# alter remote server ybd_repl_svr 
with(host 'yb100');
ALTER REMOTE SERVER

You cannot specify an IP address for the HOST value. See also CREATE REMOTE SERVER.

Parent topic:SQL Commands