Product Documentationsys.remote_server
This view captures information about remote servers that have been created for database replication. See also CREATE REMOTE SERVER.
| Column Name | Data Type | Description |
|---|---|---|
| remote_server_id | bigint | Unique ID for the remote server. |
| name | varchar(256) | User-defined name for the remote server object. |
| host | varchar(256) | Host name of the remote server (the target system). |
| port | integer | Database port on the remote server. Default is 5432. |
| control_port | integer | NULL. (Refers to JDBC control port on the remote server.) |
| no_hostname_check | boolean | Whether strict checking of host names is disabled (true) or enabled (false). The default is false. |
For information about Yellowbrick ports, see Opening Network Ports for Clients.
For example:
premdb=# select * from sys.remote_server;
remote_server_id | name | host | port | control_port | no_hostname_check
------------------+-------------------+----------------------+------+--------------+-------------------
16417 | yb100 | yb100.yellowbrick.io | 5432 | [NULL] | t
16418 | br_yb_io | 10.30.22.203 | 5432 | [NULL] | t
16419 | yblocal_checkhost | localhost | 5432 | [NULL] | f
(3 rows)Parent topic:System Views