Updated on 2024-05-07 GMT+08:00

PG_NODE_ENV

PG_NODE_ENV displays the environment variable information of the current node. This view can be viewed only by the users with monitor admin and sysadmin permission.

Table 1 PG_NODE_ENV columns

Name

Type

Description

node_name

text

Current node name.

host

text

Host name of the node.

process

integer

Number of the node process.

port

integer

Port ID of the node.

installpath

text

Installation directory of the node.

datapath

text

Data directory of the node.

log_directory

text

Log directory of the node.