with Greenplum 342 The Functional Unit 342 Deploying VMware Greenplum to an Existing vSphere Environment 342 Determining the RAID Type 343 vSAN ESA 343 vSAN OSA 343 Planning for a Deployment 343 Script 430 Setting the Greenplum Database Timezone 430 Setting Greenplum Environment Variables 431 To set up the gpadmin environment for Greenplum Database 431 Next Steps 432 Allowing Client Connections Utilities 497 Greenplum Environment Variables 497 Required Environment Variables 497 GPHOME 498 PATH 498 LD_LIBRARY_PATH 498 MASTER_DATA_DIRECTORY 498 Optional Environment Variables 498 PGAPPNAME

Script 266 Setting the Greenplum Database Timezone 267 Setting Greenplum Environment Variables 267 To set up the gpadmin environment for Greenplum Database 267 Next Steps 268 Allowing Client Connections Greenplum Environment Variables 302 Greenplum Environment Variables 0 Required Environment Variables 302 GPHOME 303 PATH 303 LD_LIBRARY_PATH 303 MASTER_DATA_DIRECTORY 303 Optional Environment Variables Preparing and Adding Hosts 594 Preparing and Adding Hosts 0 Adding New Hosts to the Trusted Host Environment 594 To exchange SSH keys as root 595 To create the gpadmin user 595 To exchange SSH keys as

Script 274 Setting the Greenplum Database Timezone 275 Setting Greenplum Environment Variables 275 To set up the gpadmin environment for Greenplum Database 276 Next Steps 276 Allowing Client Connections Greenplum Environment Variables 312 Greenplum Environment Variables 0 Required Environment Variables 312 GPHOME 312 PATH 312 LD_LIBRARY_PATH 312 MASTER_DATA_DIRECTORY 313 Optional Environment Variables Preparing and Adding Hosts 603 Preparing and Adding Hosts 0 Adding New Hosts to the Trusted Host Environment 603 To exchange SSH keys as root 604 To create the gpadmin user 604 To exchange SSH keys as

Script 411 Setting the Greenplum Database Timezone 412 Setting Greenplum Environment Variables 412 To set up the gpadmin environment for Greenplum Database 413 Next Steps 413 Allowing Client Connections Utilities 468 Greenplum Environment Variables 468 Required Environment Variables 469 GPHOME 469 PATH 469 LD_LIBRARY_PATH 469 MASTER_DATA_DIRECTORY 469 Optional Environment Variables 470 PGAPPNAME Client and Loader Tools 633 Prerequisites 633 Setting Up Your Greenplum Database Clients Runtime Environment 634 Running the Client and Loader Programs 634 Greenplum Database Documentation References 635

Tanzu Greenplum v6.20 Documentation VMware, Inc. 11 Setting Greenplum Environment Variables 272 To set up the gpadmin environment for Greenplum Database 272 Next Steps 273 Allowing Client Connections Utilities 306 Greenplum Environment Variables 306 Required Environment Variables 306 GPHOME 307 PATH 307 LD_LIBRARY_PATH 307 MASTER_DATA_DIRECTORY 307 Optional Environment Variables 307 PGAPPNAME Redistributing Indexed Tables 594 Preparing and Adding Hosts 594 Adding New Hosts to the Trusted Host Environment 594 To exchange SSH keys as root 594 To create the gpadmin user 595 To exchange SSH keys as

Script 436 Setting the Greenplum Database Timezone 437 Setting Greenplum Environment Variables 437 To set up the gpadmin environment for Greenplum Database 438 Next Steps 438 Allowing Client Connections Utilities 493 Greenplum Environment Variables 493 Required Environment Variables 493 GPHOME 493 PATH 494 LD_LIBRARY_PATH 494 MASTER_DATA_DIRECTORY 494 Optional Environment Variables 494 PGAPPNAME Client and Loader Tools 655 Prerequisites 655 Setting Up Your Greenplum Database Clients Runtime Environment 655 Running the Client and Loader Programs 656 Greenplum Database Documentation References 656

Greenplum Database Timezone 422 Setting Greenplum Environment Variables 422 VMware Tanzu Greenplum 6 Documentation VMware, Inc 17 To set up the gpadmin environment for Greenplum Database 423 Next Steps 423 Segment Host iptables Rules 473 Installation Management Utilities 473 Greenplum Environment Variables 474 Required Environment Variables 474 GPHOME 474 PATH 474 VMware Tanzu Greenplum 6 Documentation VMware, Inc 19 LD_LIBRARY_PATH 474 MASTER_DATA_DIRECTORY 475 Optional Environment Variables 475 PGAPPNAME 475 PGDATABASE 475 PGHOST 475 PGHOSTADDR 475 PGPASSWORD 475 PGPASSFILE 475 PGOPTIONS

Script 419 Setting the Greenplum Database Timezone 419 Setting Greenplum Environment Variables 420 To set up the gpadmin environment for Greenplum Database 420 Next Steps 421 Allowing Client Connections Utilities 471 Greenplum Environment Variables 471 Required Environment Variables 471 GPHOME 471 PATH 472 LD_LIBRARY_PATH 472 MASTER_DATA_DIRECTORY 472 Optional Environment Variables 472 PGAPPNAME Client and Loader Tools 629 Prerequisites 629 Setting Up Your Greenplum Database Clients Runtime Environment 630 Running the Client and Loader Programs 630 Greenplum Database Documentation References 631

Script 356 Setting the Greenplum Database Timezone 356 Setting Greenplum Environment Variables 357 To set up the gpadmin environment for Greenplum Database 357 Next Steps 358 Allowing Client Connections Utilities 398 Greenplum Environment Variables 399 Required Environment Variables 399 GPHOME 399 PATH 399 LD_LIBRARY_PATH 399 MASTER_DATA_DIRECTORY 399 Optional Environment Variables 400 PGAPPNAME Client and Loader Tools 539 Prerequisites 539 Setting Up Your Greenplum Database Clients Runtime Environment 539 Running the Client and Loader Programs 540 VMware Tanzu Greenplum 6 Documentation VMware

Script 200 Setting the Greenplum Database Timezone 200 Setting Greenplum Environment Variables 200 To set up the gpadmin environment for Greenplum Database 201 Next Steps 202 Allowing Client Connections Greenplum Environment Variables 236 Greenplum Environment Variables 0 Required Environment Variables 236 GPHOME 236 PATH 236 LD_LIBRARY_PATH 236 MASTER_DATA_DIRECTORY 237 Optional Environment Variables Preparing and Adding Hosts 526 Preparing and Adding Hosts 0 Adding New Hosts to the Trusted Host Environment 526 To exchange SSH keys as root 527 To create the gpadmin user 527 To exchange SSH keys as