subsidiaries. For more information, go to https://www.broadcom.com. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies. Copyright and trademark Availability Service 383 Prerequisites 383 Installing the Greenplum Virtual Service RPM 383 Initializing the greenplum-postmaster Service 384 Next Steps 384 Managing the High Availability Service for Mirrorless Postmaster Service 385 Managing the greenplum-postmaster Service 385 Troubleshooting 385 Upgrading the High Availability Service for Mirrorless Greenplum 386 About the Postmaster Service 386 Upgrading

Preparing the Virtual Machine 372 Performing System Configuration 373 Adding Greenplum Database Service 381 Installing the Greenplum Database Software 382 Validating the Base Virtual Machine 384 Verifying Functions 484 Backing Up and Restoring a Database 485 Completing the Migration 485 Working With Hash Operator Classes in Greenplum 6 486 Migrating from Open Source Greenplum Database to VMware Greenplum 487 Declaring Distribution Keys 558 Custom Distribution Key Hash Functions 558 Example Custom Hash Operator Class 559 Choosing the Table Storage Model 561 Heap Storage 561 Append-Optimized Storage 561

Configuration 359 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 15 Adding Greenplum Database Service 367 Installing the Greenplum Database Software 368 Validating the Base Virtual Machine 370 Verifying Functions 464 Backing Up and Restoring a Database 465 Completing the Migration 466 Working With Hash Operator Classes in Greenplum 6 466 Enabling iptables (Optional) 468 How to Enable iptables 468 Example Declaring Distribution Keys 535 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 538 Append-Optimized Storage 538

Availability Service for Greenplum Deployed With Multiple Segments Per Virtual Machine 373 Requirements 373 Adding the Greenplum Database Service 373 Managing Greenplum High Availability Service 376 Installing Functions 459 Backing Up and Restoring a Database 460 Completing the Migration 461 Working With Hash Operator Classes in Greenplum 6 461 Migrating from Open Source Greenplum Database to VMware Greenplum 463 Declaring Distribution Keys 534 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 537 Append-Optimized Storage 538

Preparing the Virtual Machine 362 Performing System Configuration 363 Adding Greenplum Database Service 371 Installing the Greenplum Database Software 372 Validating the Base Virtual Machine 374 Verifying Functions 467 Backing Up and Restoring a Database 468 Completing the Migration 468 Working With Hash Operator Classes in Greenplum 6 469 Enabling iptables (Optional) 470 How to Enable iptables 471 Example Declaring Distribution Keys 537 Custom Distribution Key Hash Functions 538 Example Custom Hash Operator Class 538 Choosing the Table Storage Model 540 Heap Storage 541 Append-Optimized Storage 541

Functions 392 Backing Up and Restoring a Database 393 Completing the Migration 394 Working With Hash Operator Classes in Greenplum 6 394 Enabling iptables (Optional) 396 How to Enable iptables 396 Example Declaring Distribution Keys 455 Custom Distribution Key Hash Functions 456 Example Custom Hash Operator Class 456 Choosing the Table Storage Model 458 Heap Storage 458 Append-Optimized Storage 458 Expressions 653 Column References 654 Positional Parameters 654 Subscripts 655 Field Selection 655 Operator Invocations 655 Function Calls 656 Aggregate Expressions 656 Limitations of Aggregate Expressions

Upgrade 301 Backing Up and Restoring a Database 305 Completing the Migration 306 Working With Hash Operator Classes in Greenplum 6 307 Enabling iptables (Optional) 308 Enabling iptables (Optional) 0 How Declaring Distribution Keys 735 Custom Distribution Key Hash Functions 736 Example Custom Hash Operator Class 736 Choosing the Table Storage Model 738 VMware Greenplum v6.19 Documentation VMware, Inc Expressions 882 Column References 883 Positional Parameters 883 Subscripts 884 Field Selection 884 Operator Invocations 885 Function Calls 885 Aggregate Expressions 885 Limitations of Aggregate Expressions

Upgrade 292 Backing Up and Restoring a Database 296 Completing the Migration 297 Working With Hash Operator Classes in Greenplum 6 297 Enabling iptables (Optional) 299 Enabling iptables (Optional) 0 How Declaring Distribution Keys 726 Custom Distribution Key Hash Functions 727 Example Custom Hash Operator Class 727 Choosing the Table Storage Model 729 VMware Greenplum v6.18 Documentation VMware, Inc Expressions 873 Column References 874 Positional Parameters 874 Subscripts 875 Field Selection 875 Operator Invocations 876 Function Calls 876 Aggregate Expressions 876 Limitations of Aggregate Expressions

Backup 297 Backing Up and Restoring a Database 300 Completing the Migration 301 Working With Hash Operator Classes in Greenplum 6 301 Enabling iptables (Optional) 303 How to Enable iptables 303 Example Declaring Distribution Keys 724 Custom Distribution Key Hash Functions 725 Example Custom Hash Operator Class 725 Choosing the Table Storage Model 727 Heap Storage 727 Append-Optimized Storage 727 Expressions 874 Column References 875 Positional Parameters 875 Subscripts 876 Field Selection 876 Operator Invocations 877 Function Calls 877 Aggregate Expressions 877 Limitations of Aggregate Expressions

Upgrade 226 Backing Up and Restoring a Database 229 Completing the Migration 230 Working With Hash Operator Classes in Greenplum 6 231 Enabling iptables (Optional) 232 Enabling iptables (Optional) 0 How Declaring Distribution Keys 658 Custom Distribution Key Hash Functions 659 Example Custom Hash Operator Class 659 Choosing the Table Storage Model 661 VMware Greenplum v6.17 Documentation VMware, Inc Expressions 805 Column References 806 Positional Parameters 806 Subscripts 807 Field Selection 807 Operator Invocations 808 Function Calls 808 Aggregate Expressions 808 Limitations of Aggregate Expressions