gp_san_configuration
The gp_san_configuration table contains mount-point information for SAN failover.
| 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 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 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 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. |