Assignment 352 Using Four 100GbE Links 353 Enabling VMware vSphere Distributed Switch (vDS) Health Check 354 Next Steps 355 Setting Up VMware vSphere DRS and HA 355 Enabling DRS 355 Enabling HA 356 Copy Utility 487 Greenplum Backup and Restore 488 Simultaneous, In-Place Upgrade 489 Run the Pre-Check Script 489 Perform the Upgrade 492 Fix the Impacted Data 492 Indexes 492 Range-Partitioned Tables Creating a Table 560 Choosing Column Data Types 560 Setting Table and Column Constraints 560 Check Constraints 561 Not-Null Constraints 561 Unique Constraints 561 Primary Keys 562 Foreign Keys

Greenplum 7 252 pg_partition_columns 253 Composing a Similar View in Greenplum 7 254 pg_partition_rule 254 pg_partition 255 pg_partition_templates 256 pg_partition_encoding 257 Composing a Similar Creating a Table 326 Choosing Column Data Types 326 Setting Table and Column Constraints 327 Check Constraints 327 Not-Null Constraints 328 Unique Constraints 328 Primary Keys 328 VMware Greenplum 882 Enabling Coordinator Mirroring 882 To add a standby coordinator to an existing system 883 To check the status of the coordinator mirroring process (optional) 883 How Greenplum Database Detects a Failed

Assignment 336 Using Four 100GbE Links 336 Enabling VMware vSphere Distributed Switch (vDS) Health Check 337 Next Steps 338 Setting Up VMware vSphere DRS and HA 338 Enabling DRS 338 Enabling HA 339 Creating a Table 531 Choosing Column Data Types 531 Setting Table and Column Constraints 531 Check Constraints 532 Not-Null Constraints 532 Unique Constraints 532 Primary Keys 533 Foreign Keys primaries) 1071 Enabling Master Mirroring 1071 To add a standby master to an existing system 1072 To check the status of the master mirroring process (optional) 1072 How Greenplum Database Detects a Failed

Assignment 302 Using Four 100GbE Links 302 Enabling VMware vSphere Distributed Switch (vDS) Health Check 303 Next Steps 304 Setting Up VMware vSphere DRS and HA 304 Enabling DRS 304 Enabling HA 305 Creating a Table 531 Choosing Column Data Types 532 Setting Table and Column Constraints 532 Check Constraints 532 Not-Null Constraints 533 Unique Constraints 533 Primary Keys 533 Foreign Keys primaries) 1050 Enabling Master Mirroring 1051 To add a standby master to an existing system 1051 To check the status of the master mirroring process (optional) 1052 How Greenplum Database Detects a Failed

Assignment 317 Using Four 100GbE Links 317 Enabling VMware vSphere Distributed Switch (vDS) Health Check 318 Next Steps 319 Setting Up VMware vSphere DRS and HA 319 Enabling DRS 319 Enabling HA 320 Creating a Table 554 Choosing Column Data Types 555 Setting Table and Column Constraints 555 Check Constraints 556 Not-Null Constraints 556 Unique Constraints 556 Primary Keys 556 Foreign Keys primaries) 1088 Enabling Master Mirroring 1088 To add a standby master to an existing system 1089 To check the status of the master mirroring process (optional) 1089 How Greenplum Database Detects a Failed

Assignment 306 Using Four 100GbE Links 307 Enabling VMware vSphere Distributed Switch (vDS) Health Check 308 Next Steps 308 VMware Tanzu Greenplum 6 Documentation VMware, Inc 13 Setting Up VMware vSphere Creating a Table 534 Choosing Column Data Types 534 Setting Table and Column Constraints 535 Check Constraints 535 Not-Null Constraints 536 Unique Constraints 536 Primary Keys 536 Foreign Keys primaries) 1055 Enabling Master Mirroring 1056 To add a standby master to an existing system 1056 To check the status of the master mirroring process (optional) 1057 How Greenplum Database Detects a Failed

Mirroring 521 Enabling Master Mirroring 0 To add a standby master to an existing system 521 To check the status of the master mirroring process (optional) 521 How Greenplum Database Detects a Failed Segments 1757 Check for failed segments using gpstate 523 Check for failed segments using the gp_segment_configuration table 524 Check for failed segments by examining log files 524 To check the log files a recovery 533 To restore the master and standby instances on original hosts (optional) 533 To check the status of the master mirroring process (optional) 534 Backing Up and Restoring Databases 534

Mirroring 530 Enabling Master Mirroring 0 To add a standby master to an existing system 530 To check the status of the master mirroring process (optional) 530 How Greenplum Database Detects a Failed Segments 1770 Check for failed segments using gpstate 532 Check for failed segments using the gp_segment_configuration table 533 Check for failed segments by examining log files 533 To check the log files a recovery 542 To restore the master and standby instances on original hosts (optional) 542 To check the status of the master mirroring process (optional) 543 Backing Up and Restoring Databases 543

Mirroring 456 Enabling Master Mirroring 0 To add a standby master to an existing system 456 To check the status of the master mirroring process (optional) 456 Detecting a Failed Segment 457 Detecting 459 VMware Greenplum v6.17 Documentation VMware, Inc. 24 Checking for Failed Segments 1691 To check for failed segments 460 Recovering From Segment Failures 460 Recovering From Segment Failures 0 a recovery 464 To restore the master and standby instances on original hosts (optional) 465 To check the status of the master mirroring process (optional) 466 Backing Up and Restoring Databases 466

Assignment 274 Using Four 100GbE Links 275 Enabling VMware Vsphere Distributed Switch (vDS) Health Check 275 Next Steps 276 Setting Up VMware vSphere DRS and HA 276 Enabling DRS 276 Enabling HA 277 Creating a Table 452 Choosing Column Data Types 453 Setting Table and Column Constraints 453 Check Constraints 453 Not-Null Constraints 454 Unique Constraints 454 Primary Keys 454 Foreign Keys primaries) 919 Enabling Master Mirroring 920 To add a standby master to an existing system 920 To check the status of the master mirroring process (optional) 920 How Greenplum Database Detects a Failed