4.1 Database

We do not recommend placing a firewall between nodes (all nodes should be behind a firewall), but if you must use a firewall between nodes, ensure the following ports are available.

For more information about database ports, see Vertica Documentation.

Ports

Protocol

Node

Description

22

TCP

All database nodes

Used by the Administration Tools and the Management Console Cluster installation wizard.

5433

TCP

All database nodes

Used by database clients, such as vsql, ODBC, JDBC, and so on

All cluster nodes with label fusion:yes and all remote database clients should be able to access this port.

5434

TCP

All database nodes

Used for intra-cluster and inter-cluster communication.

Database opens the database client port +1 (5434 by default) for intra-cluster communication. If the default database client port +1 is not available, then database opens a random port for intra-cluster communication

All database nodes should be able to access this port.

5438

TCP

All database nodes

Used for Management Console-to-node and node-to-node (agent) communication.

For more information, see Changing Management Console or Agent Ports.

All database nodes should be able to access this port.

5450

TCP

All database nodes

Used to connect to the Management Console from a web browser and allow communication from nodes to the Management Console application/web server.

For more information, see Connecting to Management Console.

All database nodes and web clients should be able to access this port.

4803

TCP

All database nodes

Used for spread client connections.

All database nodes should be able to access this port.

5433

UDP

All database nodes

Used for database spread monitoring.

All database nodes should be able to access this port.

4804

UDP

All database nodes

Used for spread daemon to daemon connections.

All database nodes should be able to access this port.

6543

UDP

All database nodes

Used to monitor spread daemon connections.

All database nodes should be able to access this port.

4803

UDP

All database nodes

Used for spread daemon to daemon connection.

All database nodes should be able to access this port.