• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PGXC_NODE_ENV

PGXC_NODE_ENV

PGXC_NODE_ENV provides the environmental variables information about all nodes in a cluster.

Table 1 PGXC_NODE_ENV columns

Name

Type

Description

node_name

text

All the node names in the cluster

host

text

Host names of all the nodes in the cluster

process

integer

Process IDs of all the nodes in the cluster

port

integer

Port numbers of all the nodes in the cluster

installpath

text

Installation directory of all the nodes in the cluster

datapath

text

Data directory of all the nodes in the cluster

log_directory

text

Log directory of all the nodes in the cluster