Layer 340 Infrastructure Layer 340 Virtual Machine Cluster Layer 340 Greenplum Layer 341 High Availability 341 Planning VMware vSphere with Greenplum 342 The Functional Unit 342 Deploying VMware Greenplum Greenplum High 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 385 Managing the greenplum-postmaster Service 385 Troubleshooting 385 Upgrading the High Availability Service for Mirrorless Greenplum 386 About the Postmaster Service 386 Upgrading the Service

372 High 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 Interconnect Proxies for the System 1062 Enabling High Availability and Data Consistency Features 1062 Overview of Greenplum Database High Availability 1063 Hardware level RAID 1063 Data storage checksums VMware, Inc. 56 ANALYZE 1201 Vacuum 1202 Loading 1202 Security 1202 Encryption 1203 High Availability 1203 System Configuration 1204 Configuring the Timezone 1204 File System 1205 Port Configuration

Interconnect Proxies for the System 1079 Enabling High Availability and Data Consistency Features 1080 Overview of Greenplum Database High Availability 1080 Hardware level RAID 1081 Data storage checksums Maintenance 1216 ANALYZE 1216 Vacuum 1217 Loading 1217 Security 1217 Encryption 1218 High Availability 1218 System Configuration 1219 Configuring the Timezone 1219 File System 1220 Port Configuration Optimizing Greenplum Queries 1269 Greenplum Grouping Extensions 1270 Window Functions 1270 High Availability 1270 Disk Storage 1271 Best Practices 1271 Master Mirroring 1271 Best Practices 1272 Segment

Interconnect Proxies for the System 1042 Enabling High Availability and Data Consistency Features 1042 Overview of Greenplum Database High Availability 1043 Hardware level RAID 1043 Data storage checksums VMware, Inc. 54 ANALYZE 1172 Vacuum 1173 Loading 1173 Security 1173 Encryption 1174 High Availability 1174 System Configuration 1175 Configuring the Timezone 1175 File System 1176 Port Configuration Optimizing Greenplum Queries 1224 Greenplum Grouping Extensions 1225 Window Functions 1226 High Availability 1226 Disk Storage 1226 Best Practices 1227 Master Mirroring 1227 Best Practices 1227 Segment

Interconnect Proxies for the System 1047 Enabling High Availability and Data Consistency Features 1047 Overview of Greenplum Database High Availability 1048 Hardware level RAID 1048 Data storage checksums Maintenance 1177 ANALYZE 1177 Vacuum 1178 Loading 1178 Security 1178 Encryption 1179 High Availability 1179 System Configuration 1180 Configuring the Timezone 1180 File System 1181 Port Configuration Optimizing Greenplum Queries 1229 Greenplum Grouping Extensions 1230 Window Functions 1230 High Availability 1230 Disk Storage 1231 Best Practices 1231 Master Mirroring 1231 Best Practices 1232 Segment

System 873 Enabling High Availability and Data Consistency Features 873 VMware Greenplum 7 Documentation VMware by Broadcom 37 Overview of Greenplum Database High Availability 874 Hardware level RAID Documentation VMware by Broadcom 45 Vacuum 1015 Loading 1015 Security 1015 Encryption 1016 High Availability 1016 System Configuration 1017 Configuring the Timezone 1017 File System 1018 Port Configuration Optimizing Greenplum Queries 1067 Greenplum Grouping Extensions 1068 Window Functions 1068 High Availability 1069 Disk Storage 1069 Best Practices 1069 Coordinator Mirroring 1070 Best Practices 1070

Monitoring and Maintenance 328 ANALYZE 328 Vacuum 329 Loading 329 Security 329 Encryption 330 High Availability 330 System Configuration 331 System Configuration 0 Configuring the Timezone 332 File System Greenplum Queries 380 Greenplum Grouping Extensions 381 Window Functions 381 High Availability 382 High Availability 0 Disk Storage 382 Best Practices 383 Master Mirroring 383 Best Practices 383 System 520 Enabling High Availability and Data Consistency Features 521 Enabling High Availability and Data Consistency Features 0 Overview of Greenplum Database High Availability 521 Overview of Greenplum

Monitoring and Maintenance 319 ANALYZE 319 Vacuum 320 Loading 320 Security 320 Encryption 321 High Availability 321 System Configuration 322 VMware Greenplum v6.18 Documentation VMware, Inc. 14 System Greenplum Queries 371 Greenplum Grouping Extensions 372 Window Functions 373 High Availability 373 High Availability 0 Disk Storage 373 Best Practices 374 Master Mirroring 374 VMware Greenplum System 511 Enabling High Availability and Data Consistency Features 512 Enabling High Availability and Data Consistency Features 0 Overview of Greenplum Database High Availability 512 Overview of Greenplum

Monitoring and Maintenance 252 ANALYZE 252 Vacuum 253 Loading 253 Security 253 Encryption 254 High Availability 254 System Configuration 255 System Configuration 0 Configuring the Timezone 256 File System Greenplum Queries 306 Greenplum Grouping Extensions 307 Window Functions 308 High Availability 308 High Availability 0 Disk Storage 308 Best Practices 309 Master Mirroring 309 Best Practices 309 System 446 Enabling High Availability and Data Consistency Features 447 Enabling High Availability and Data Consistency Features 0 Overview of Greenplum Database High Availability 447 VMware Greenplum

Monitoring and Maintenance 323 ANALYZE 323 Vacuum 324 Loading 324 Security 324 Encryption 325 High Availability 325 System Configuration 326 Configuring the Timezone 327 File System 327 Port Configuration Optimizing Greenplum Queries 375 Greenplum Grouping Extensions 376 Window Functions 376 High Availability 377 Disk Storage 377 Best Practices 377 Master Mirroring 378 Best Practices 378 Segment Interconnect Proxies for the System 514 Enabling High Availability and Data Consistency Features 514 Overview of Greenplum Database High Availability 514 Hardware level RAID 515 Data storage checksums