gp_san_configuration

gp_san_configuration

The gp_san_configuration table contains mount-point information for SAN failover.

Table 1. pg_catalog.gp_san_configuration
column type references description
mountid smallint   A value that identifies the mountpoint for the primary and mirror hosts. This is the primary key which is referred to by the value that appears in the san_mounts structure in gp_segment_ configuration.
active_host char   The current active host. p indidcates primary, and m indicates mirror.
san_type char   The type of shared storage in use. n indidcates NFS, and e indicates Dell EMC SAN.
primary_host text   The name of the primary host system
primary_mountpoint text   The mount point for the primary host.
primary_device text   A string specifying the device to mount on the primary mountpoint.

For NFS, this string is similar to: nfs-server:/exported/fs.

For Dell EMC this is a larger string that includes the WWN for the storage processor, the storage-processor IP, and the storage-group name.

The primary_device field is identical to the mirror_device field.

mirror_host text   The name or the mirror/backup host system.
mirror_mountpoint text   The mount point for the mirror/backup host.
mirror_device text   A string specifying the device to mount on the mirror mountpoint.

For NFS, this string is similar to: nfs-server:/exported/fs.

For Dell EMC this is a larger string that includes the WWN for the storage processor, the storage-processor IP, and the storage-group name.

The mirror_device field is identical to the primary_device field.