Top
Enterprise Postgres 16 Cluster Operation Guide(Database Multiplexing)

A.3 Network Configuration File

This section explains the network configuration file (network.conf) to be defined individually for the database servers and the arbitration server. Define the same content on the primary server and standby server.

For database multiplexing mode, define the network configuration for the following in network.conf.

Items to be defined in network.conf

Format:
serverIdentifier hostName[,hostName] portNum[,portNum] [serverType]
Or, 
serverIdentifier ipAddr[,ipAddr] portNum[,portNum] [serverType]

Specify the server identifier, IP address or host name, port number, and server type, using a space as the delimiter.

The items are explained in the table below.

Table A.3 network.conf file

Item

Description

serverIdentifier

Specify any identifier for the server. The maximum length is 64 bytes. Use ASCII characters excluding spaces and number signs (#) to specify this parameter.

ipAddrOrHostName

Specify the IP address or its corresponding host name that will connect to the admin network that performs communication between the database servers, and to the arbitration network that performs communication between a database server and the arbitration server.

When specifying two IP addresses or host names delimited by a comma, do not insert a space after the comma.

Use ASCII characters excluding spaces to specify the host name.

portNum

A port number cannot be specified if it exceeds the range 0 to 65535. Ensure that the port number does not conflict with other software. Do not specify an ephemeral port that may temporarily be assigned by another program. Note that the value specified in this parameter must also be set in the services file.

When specifying two port numbers delimited by a comma, do not insert a space after the comma.

serverType

Specify "server" for a database server ("server" can be omitted), or "arbiter" for the arbitration server.

Content to be defined on the database servers

This section explains the network.conf content to be defined on the database servers.

The content to be defined depends on the operation settings at the time a heartbeat abnormality is detected.

When automatic degradation by the arbitration server is selected
  • Specify definitions related to the admin network and arbitration network.

  • Specify the IP address or host name and port number according to the server type (database server or arbitration server) as shown in the table below.

    Server type

    IP address or host name

    Port number

    First

    Second

    First

    Second

    server

    IP address or host name used as the admin network

    IP address or host name used as the arbitration network (*1)

    Port number used as the admin network

    Port number used as the arbitration network (*1)

    arbiter

    IP address or host name of the arbitration server

    Specify the same value as that specified in the my_address parameter of arbitration.conf on the arbitration server.

    Not required

    Port number on the arbitration server

    Specify the same value as that specified in the port parameter of arbitration.conf on the arbitration server.

    Not required

    *1: This value can be omitted from definitions not related to the local server. If it is omitted, network.conf must be created on both the primary server and standby server.


Example)
IPv4
server1 192.0.2.100,192.0.3.100 27540,27541 server
server2 192.0.2.110,192.0.3.110 27540,27541 server
arbiter 192.0.3.120 27541 arbiter
IPv6
server1 2001:258:8404:1217:250:56ff:fea7:559f,2001:258:8404:1217:250:56ff:fea8:559f 27540,27541 server
server2 2001:258:8404:1217:250:56ff:fea7:55a0,2001:258:8404:1217:250:56ff:fea8:55a0 27540,27541 server
arbiter 2001:258:8404:1217:250:56ff:fea8:55a0 27541 arbiter

When operation other than automatic degradation by the arbitration server is selected
  • Specify definitions related to the admin network.

  • Define the same content on the primary server and standby server.

  • Define lines for database servers only.

  • Specify only one IP address or host name and port number.

    IP address or host name

    Port number

    First

    Second

    First

    Second

    IP address or host name to be used as the admin network

    Not required

    Port number used as the admin network

    Not required


Example)

The literal space represents a space.

IPv4
server1 192.0.2.100 27540
server2 192.0.2.110 27540
IPv6
server1 2001:258:8404:1217:250:56ff:fea7:559f 27540
server2 2001:258:8404:1217:250:56ff:fea7:55a0 27540

Content to be defined on the arbitration server

This section explains the network.conf content to be defined on the arbitration server.

Example)

The literal space represents a space.

IPv4
server1 192.0.3.100 27541
server2 192.0.3.110 27541
IPv6
server1 2001:258:8404:1217:250:56ff:fea8:559f 27541
server2 2001:258:8404:1217:250:56ff:fea8:55a0 27541

Relationship between network-related definitions

Refer to the diagram below for the relationship between the host names and IP addresses or port numbers specified in the network configuration file (network.conf) and arbitration configuration file (arbitration.conf).