reserved. Copyright and trademark information. VMware Greenplum v6.17 Documentation VMware, Inc. 2 Contents VMware Tanzu™ Greenplum® 6.17 Documentation 134 Welcome to Tanzu Greenplum 6 134 Server Removing the PostGIS 2.1.5 package 349 Upgrade a PostGIS 2.5.4 Package from pivotal.1 or pivotal.2 to pivotal.3 349 Checking the PostGIS Version 350 Notes 351 Text Analytics and Search 351 Text Analytics Uninstall R (Ubuntu) 410 Examples 410 Example 1: Using PL/R for single row operators 410 Example 2: Returning PL/R data.frames in Tabular Form 410 Example 3: Hierarchical Regression using PL/R 411

reserved. Copyright and trademark information. VMware Greenplum v6.19 Documentation VMware, Inc. 2 Contents VMware Tanzu™ Greenplum® 6.19 Documentation 140 Welcome to Tanzu Greenplum 6 140 Differences Removing the PostGIS 2.1.5 package 423 Upgrade a PostGIS 2.5.4 Package from pivotal.1 or pivotal.2 to pivotal.3 423 Checking the PostGIS Version 424 Notes 425 Text Analytics and Search 425 Text Analytics Uninstall R (Ubuntu) 484 Examples 484 Example 1: Using PL/R for single row operators 484 Example 2: Returning PL/R data.frames in Tabular Form 485 Example 3: Hierarchical Regression using PL/R 485

reserved. Copyright and trademark information. VMware Greenplum v6.18 Documentation VMware, Inc. 2 Contents VMware Tanzu™ Greenplum® 6.18 Documentation 139 Welcome to Tanzu Greenplum 6 139 Differences Removing the PostGIS 2.1.5 package 414 Upgrade a PostGIS 2.5.4 Package from pivotal.1 or pivotal.2 to pivotal.3 414 Checking the PostGIS Version 415 Notes 416 Text Analytics and Search 416 Text Analytics Uninstall R (Ubuntu) 475 Examples 475 Example 1: Using PL/R for single row operators 475 Example 2: Returning PL/R data.frames in Tabular Form 475 Example 3: Hierarchical Regression using PL/R 476

reserved. Copyright and trademark information. VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 2 Contents VMware Tanzu™ Greenplum® 6.20 Documentation 131 Welcome to Tanzu Greenplum 6 131 Differences Removing the PostGIS 2.1.5 package 418 Upgrade a PostGIS 2.5.4 Package from pivotal.1 or pivotal.2 to pivotal.3 419 Checking the PostGIS Version 419 Notes 420 Text Analytics and Search 420 Greenplum Uninstall R (Ubuntu) 478 Examples 478 Example 1: Using PL/R for single row operators 478 Example 2: Returning PL/R data.frames in Tabular Form 479 Example 3: Hierarchical Regression using PL/R 479

reserved. Copyright and trademark information. VMware Tanzu Greenplum 6 Documentation VMware, Inc 2 Contents VMware Tanzu™ Greenplum® 6.23 Documentation 130 Welcome to Tanzu Greenplum 130 Differences 319 Option 1: Enabling Virtual Machine Encryption 319 Option 2: Enabling vSAN Encryption 322 Step 1: Enabling vSAN encryption 322 Step 2: Creating the VMware vSphere storage policy 323 Next Steps 326 Monitoring the Greenplum Deployment 340 Setting Up the GPCC Login User 341 Next Steps 341 Option 2: Deploying Mirrored Greenplum Using Your Own Virtual Machine 341 Creating the Base Virtual Machine

reserved. Copyright and trademark information. VMware Tanzu Greenplum 6 Documentation VMware, Inc. 2 Contents VMware Tanzu™ Greenplum® 6.22 Documentation 131 Welcome to Tanzu Greenplum 131 Differences 315 Option 1: Enabling Virtual Machine Encryption 315 Option 2: Enabling vSAN Encryption 318 Step 1: Enabling vSAN encryption 318 Step 2: Creating the VMware vSphere storage policy 319 Next Steps 322 Monitoring the Greenplum Deployment 336 Setting Up the GPCC Login User 337 Next Steps 337 Option 2: Deploying Mirrored Greenplum Using Your Own Virtual Machine 337 Creating the Base Virtual Machine

companies. Copyright and trademark information. VMware Greenplum 6 Documentation VMware by Broadcom 2 Contents VMware Greenplum 6 Documentation 140 Welcome to VMware Greenplum 140 Differences Compared 365 Option 1: Enabling Virtual Machine Encryption 365 Option 2: Enabling vSAN Encryption 368 Step 1: Enabling vSAN encryption 368 Step 2: Creating the VMware vSphere storage policy 369 Next Steps 372 Clocks 412 Option 1: Configure System Clocks with the Coordinator as the Primary Source 413 Option 2: Configure System Clocks with an External Primary Source 413 Creating the Greenplum Administrative

rights reserved. Copyright and trademark information. VMware Greenplum 6 Documentation VMware, Inc 2 Contents VMware Tanzu™ Greenplum® 6.23 Documentation 130 Welcome to Tanzu Greenplum 130 Differences Virtual Machine Encryption 329 Option 2: Enabling vSAN Encryption 332 VMware Greenplum 6 Documentation VMware, Inc 14 Step 1: Enabling vSAN encryption 332 Step 2: Creating the VMware vSphere storage Monitoring the Greenplum Deployment 350 Setting Up the GPCC Login User 351 Next Steps 351 Option 2: Deploying Mirrored Greenplum Using Your Own Virtual Machine 351 Creating the Base Virtual Machine

rights reserved. Copyright and trademark information. VMware Greenplum 6 Documentation VMware, Inc. 2 Contents VMware Greenplum 6.25 Documentation 136 Welcome to VMware Greenplum 136 Differences Compared 348 Option 1: Enabling Virtual Machine Encryption 348 Option 2: Enabling vSAN Encryption 351 Step 1: Enabling vSAN encryption 351 Step 2: Creating the VMware vSphere storage policy 352 Next Steps 355 442 Prerequisites 442 Step 1: Complete PXF Greenplum Database 5.x Pre-Migration Actions 443 Step 2: Migrating PXF to Greenplum 6.x 443 Migrating gphdfs External Tables to PXF 446 Preparing for the

reserved. Copyright and trademark information. VMware Tanzu Greenplum 6 Documentation VMware, Inc 2 Contents VMware Tanzu™ Greenplum® 6.21 Documentation 127 Welcome to Tanzu Greenplum 127 Differences 285 Option 1: Enabling Virtual Machine Encryption 286 Option 2: Enabling vSAN Encryption 288 Step 1: Enabling vSAN encryption 288 Step 2: Creating the VMware vSphere storage policy 289 Next Steps 292 Monitoring the Greenplum Deployment 304 Setting Up the GPCC Login User 304 Next Steps 304 Option 2: Deploying Greenplum Using Your Own Template 304 Creating the Virtual Machine Template 305 Preparing