Help Center/GaussDB/Developer Guide(Distributed_V2.0-2.x)/System Catalogs and System Views/System Views/PGXC_NODE_ENV
Updated on 2025-08-19 GMT+08:00
View PDF

PGXC_NODE_ENV

PGXC_NODE_ENV displays environmental variables of all nodes in a cluster. This view can be viewed only by the users with SYSADMIN or MONADMIN permission.

Table 1 PGXC_NODE_ENV columns

Name

Type

Description

node_name1

text

Name of a node in a cluster.

host1

text

Host names of the nodes in the cluster.

process1

integer

Process IDs of the nodes in the cluster.

port1

integer

Port numbers of the nodes in the cluster.

installpath1

text

Installation directory of the nodes in the cluster.

datapath1

text

Data directory of the nodes in the cluster.

log_directory1

text

Log directory of the nodes in the cluster.

Parent topic:System Views