Help Center> GaussDB> Distributed_2.x> System Catalogs and System Views> System Views> PGXC_NODE_ENV
Updated on 2023-10-23 GMT+08:00
View PDF

PGXC_NODE_ENV

PGXC_NODE_ENV provides environmental variables of all nodes in a cluster. This view can be viewed only by the monitor admin and sysadmin users.

Table 1 PGXC_NODE_ENV columns

Name

Type

Description

node_name1

text

All node names in the cluster

host1

text

Host names of all the nodes in the cluster

process1

integer

Process IDs of all the nodes in the cluster

port1

integer

Port numbers of all the nodes in the cluster

installpath1

text

Installation directory of all the nodes in the cluster

datapath1

text

Data directory of all the nodes in the cluster

log_directory1

text

Log directory of all the nodes in the cluster
Parent topic: System Views