pg_dumpall 701 Synopsis 701 Description 701 Options 702 Notes 705 Examples 705 See Also 705 psql 706 Synopsis 706 Description 706 Options 706 Exit Status 709 Usage 709 Meta-Commands 710 Patterns Loading Data with COPY 754 Loading From a File 754 Loading From STDIN 754 Loading Data Using \copy in psql 754 Input Format 755 Running COPY in Single Row Error Isolation Mode 755 Optimizing Data Load and Documentation VMware by Broadcom 40 Dictionary Testing 884 GiST and GIN Indexes for Text Search 885 psql Support 886 Limitations 889 Using Greenplum MapReduce 889 About the Greenplum MapReduce Configuration

pg_dumpall 693 Synopsis 693 Description 693 Options 693 Notes 697 Examples 697 See Also 697 psql 697 Synopsis 698 Description 698 Options 698 Exit Status 701 Usage 701 Meta-Commands 702 Patterns Loading Data with COPY 745 Loading From a File 746 Loading From STDIN 746 Loading Data Using \copy in psql 746 Input Format 746 Running COPY in Single Row Error Isolation Mode 747 Optimizing Data Load and Testing 872 Parser Testing 874 Dictionary Testing 875 GiST and GIN Indexes for Text Search 876 psql Support 877 Limitations 880 Using Greenplum MapReduce 880 About the Greenplum MapReduce Configuration

pg_dumpall 667 Synopsis 668 Description 668 Options 668 Notes 671 Examples 672 See Also 672 psql 672 Synopsis 672 Description 672 Options 672 VMware Tanzu Greenplum 6 Documentation VMware, Inc Loading Data with COPY 719 Loading From a File 719 Loading From STDIN 719 Loading Data Using \copy in psql 719 Input Format 720 Running COPY in Single Row Error Isolation Mode 720 Optimizing Data Load and Testing 843 Parser Testing 845 Dictionary Testing 847 GiST and GIN Indexes for Text Search 847 psql Support 848 Limitations 851 Using Greenplum MapReduce 852 About the Greenplum MapReduce Configuration

pg_dumpall 671 Synopsis 672 Description 672 Options 672 Notes 676 Examples 676 See Also 676 psql 676 Synopsis 676 Description 676 Options 676 Exit Status 679 Usage 680 Meta-Commands 681 Patterns Documentation VMware, Inc. 33 Loading From a File 725 Loading From STDIN 725 Loading Data Using \copy in psql 725 Input Format 725 Running COPY in Single Row Error Isolation Mode 726 Optimizing Data Load and Testing 852 Parser Testing 854 Dictionary Testing 855 GiST and GIN Indexes for Text Search 856 psql Support 857 Limitations 860 Using Greenplum MapReduce 860 VMware Greenplum 6 Documentation VMware

pg_dumpall 666 Synopsis 666 Description 666 Options 666 Notes 670 Examples 670 See Also 670 psql 670 Synopsis 670 Description 670 Options 671 Exit Status 674 Usage 674 Meta-Commands 675 Patterns Loading Data with COPY 717 Loading From a File 718 Loading From STDIN 718 Loading Data Using \copy in psql 718 Input Format 718 Running COPY in Single Row Error Isolation Mode 719 Optimizing Data Load and Documentation VMware, Inc. 36 Dictionary Testing 845 GiST and GIN Indexes for Text Search 845 psql Support 847 Limitations 849 Using Greenplum MapReduce 850 About the Greenplum MapReduce Configuration

pg_dumpall 572 Synopsis 572 Description 572 Options 572 Notes 575 Examples 576 See Also 576 psql 576 Synopsis 576 Description 576 Options 576 Exit Status 579 Usage 579 Meta-Commands 580 Patterns Loading Data with COPY 618 Loading From a File 619 Loading From STDIN 619 Loading Data Using \copy in psql 619 Input Format 619 Running COPY in Single Row Error Isolation Mode 620 Optimizing Data Load and Testing 733 Parser Testing 734 Dictionary Testing 735 GiST and GIN Indexes for Text Search 736 psql Support 737 VMware Tanzu Greenplum 6 Documentation VMware, Inc 35 Limitations 740 Using Greenplum

pg_dumpall 496 Synopsis 496 Description 497 Options 497 Notes 500 Examples 501 See Also 501 psql 501 Synopsis 501 Description 501 Options 501 Exit Status 504 VMware Greenplum 7 Documentation Loading Data with COPY 548 Loading From a File 549 Loading From STDIN 549 Loading Data Using \copy in psql 549 Input Format 549 Running COPY in Single Row Error Isolation Mode 550 Optimizing Data Load and Documentation VMware by Broadcom 27 Dictionary Testing 682 Preferred Index Types for Text Search 682 psql Support 683 Limitations 686 Query Performance 687 Managing Spill Files Generated by Queries 687

Database Client Applications 495 Greenplum Database Client Applications 0 Connecting with psql 496 Connecting with psql 0 Using the PgBouncer Connection Pooler 496 Using the PgBouncer Connection Pooler 0 Machine 651 Setting Up Client System with Kerberos Authentication 652 Running psql 652 To connect to Greenplum Database with psql 652 Running a Java Application 652 Configuring Kerberos For Windows Clients Kerberos For Windows Clients 0 Installing and Configuring Kerberos on a Windows System 653 Running the psql Utility 655 Creating a Kerberos Keytab File 655 Example gpload YAML File 656 Issues and Possible

Database Client Applications 504 Greenplum Database Client Applications 0 Connecting with psql 505 Connecting with psql 0 Using the PgBouncer Connection Pooler 505 Using the PgBouncer Connection Pooler 0 Machine 660 Setting Up Client System with Kerberos Authentication 661 Running psql 661 To connect to Greenplum Database with psql 661 Running a Java Application 661 Configuring Kerberos For Windows Clients Kerberos For Windows Clients 0 Installing and Configuring Kerberos on a Windows System 662 Running the psql Utility 664 Creating a Kerberos Keytab File 664 Example gpload YAML File 665 Issues and Possible

497 Supported Client Applications 497 Greenplum Database Client Applications 497 Connecting with psql 498 Using the PgBouncer Connection Pooler 499 Overview 499 Migrating PgBouncer 500 Configuring Machine 650 Setting Up Client System with Kerberos Authentication 650 Running psql 651 To connect to Greenplum Database with psql 651 Running a Java Application 651 Configuring Kerberos For Windows Clients Clients 652 Installing and Configuring Kerberos on a Windows System 652 Running the psql Utility 654 Creating a Kerberos Keytab File 654 Example gpload YAML File 655 Issues and Possible Solutions 656