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 Database 288 Locale Behavior 289 Troubleshooting Locales 290 Character Set Support 290 Setting the Character Set 292 Character Set Conversion Between Server and Client 292 Upgrading to Greenplum 6 294 Logging 452 Security 0 Installation 452 Trusted Language 453 Some PL/Java Issues and Solutions 453 Multi-threading 453 Solution 453 Exception Handling 453 Solution 454 Java Garbage Collector Versus palloc()

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 Database 279 Locale Behavior 280 Troubleshooting Locales 281 Character Set Support 281 Setting the Character Set 283 Character Set Conversion Between Server and Client 283 Upgrading to Greenplum 6 285 Logging 442 Security 0 Installation 443 Trusted Language 443 Some PL/Java Issues and Solutions 444 Multi-threading 444 Solution 444 Exception Handling 444 Solution 444 Java Garbage Collector Versus palloc()

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 Database 213 Locale Behavior 214 Troubleshooting Locales 215 Character Set Support 215 Setting the Character Set 217 Character Set Conversion Between Server and Client 217 Upgrading to Greenplum 6 219 Logging 377 Security 0 Installation 378 Trusted Language 378 Some PL/Java Issues and Solutions 379 Multi-threading 379 Solution 379 Exception Handling 379 Solution 379 Java Garbage Collector Versus palloc()

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 Database 284 Locale Behavior 285 Troubleshooting Locales 286 Character Set Support 286 Setting the Character Set 288 Character Set Conversion Between Server and Client 288 Upgrading to Greenplum 6 290 446 Security 447 Installation 447 Trusted Language 447 Some PL/Java Issues and Solutions 448 Multi-threading 448 Solution 448 Exception Handling 448 Solution 448 Java Garbage Collector Versus palloc()

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 Database 449 Locale Behavior 451 Troubleshooting Locales 451 Character Set Support 451 Setting the Character Set 453 Character Set Conversion Between Server and Client 453 Upgrading to Greenplum 6 456 Partitions 582 Defining Numeric Range Table Partitions 583 Defining List Table Partitions 584 Defining Multi-level Partitions 584 Partitioning an Existing Table 585 Limitations of Partitioned Tables 585 Loading

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 Database 430 Locale Behavior 432 Troubleshooting Locales 432 Character Set Support 432 Setting the Character Set 434 Character Set Conversion Between Server and Client 434 Upgrading to Greenplum 6 437 Partitions 553 Defining Numeric Range Table Partitions 554 Defining List Table Partitions 554 Defining Multi-level Partitions 555 Partitioning an Existing Table 556 Limitations of Partitioned Tables 556 Loading

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 Database 455 Locale Behavior 456 Troubleshooting Locales 457 Character Set Support 457 Setting the Character Set 459 Character Set Conversion Between Server and Client 459 Upgrading to Greenplum 6 462 Partitions 577 Defining Numeric Range Table Partitions 578 Defining List Table Partitions 578 Defining Multi-level Partitions 578 Partitioning an Existing Table 579 Limitations of Partitioned Tables 580 Loading

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 Allowing Client Connections Database 439 Locale Behavior 441 Troubleshooting Locales 441 Character Set Support 441 Setting the Character Set 443 Character Set Conversion Between Server and Client 444 Upgrading to Greenplum 6 446 Partitions 556 Defining Numeric Range Table Partitions 557 Defining List Table Partitions 557 Defining Multi-level Partitions 557 Partitioning an Existing Table 558 Limitations of Partitioned Tables 559 Loading

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 Database 437 Locale Behavior 438 Troubleshooting Locales 439 Character Set Support 439 Setting the Character Set 441 Character Set Conversion Between Server and Client 441 Upgrading to Greenplum 6 443 Partitions 553 Defining Numeric Range Table Partitions 554 Defining List Table Partitions 554 Defining Multi-level Partitions 554 Partitioning an Existing Table 555 Limitations of Partitioned Tables 556 Loading

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 Database 367 Locale Behavior 369 Troubleshooting Locales 369 Character Set Support 369 Setting the Character Set 371 Character Set Conversion Between Server and Client 371 Upgrading to Greenplum 6 373 Partitions 472 Defining Numeric Range Table Partitions 472 Defining List Table Partitions 473 Defining Multi-level Partitions 473 Partitioning an Existing Table 474 Limitations of Partitioned Tables 474 Loading