The Segments 237 Segment Redundancy 238 Segment Failover and Recovery 238 Example Segment Host Hardware Stack 239 Example Segment Disk Layout 239 The Interconnect 240 Interconnect Redundancy 240 Enabling iptables (Optional) 0 How to Enable iptables 308 Example iptables Rules 309 Example Master and Standby Master iptables Rules 310 Example Segment Host iptables Rules 311 Installation Management PGOPTIONS 314 PGPORT 314 PGUSER 314 PGDATESTYLE 314 PGTZ 314 PGCLIENTENCODING 314 Example Ansible Playbook 314 Example Ansible Playbook 0 Ansible Playbook - Greenplum Database Installation for CentOS

The Segments 230 Segment Redundancy 230 Segment Failover and Recovery 231 Example Segment Host Hardware Stack 231 Example Segment Disk Layout 232 The Interconnect 232 VMware Greenplum v6.18 Documentation Enabling iptables (Optional) 0 How to Enable iptables 299 Example iptables Rules 300 Example Master and Standby Master iptables Rules 301 Example Segment Host iptables Rules 301 Installation Management PGOPTIONS 304 PGPORT 304 PGUSER 304 PGDATESTYLE 304 PGTZ 304 PGCLIENTENCODING 304 Example Ansible Playbook 304 Example Ansible Playbook 0 Ansible Playbook - Greenplum Database Installation for CentOS

The Segments 164 Segment Redundancy 164 Segment Failover and Recovery 165 Example Segment Host Hardware Stack 165 Example Segment Disk Layout 166 The Interconnect 166 Interconnect Redundancy 167 How to Enable iptables 233 Example iptables Rules 233 Example Master and Standby Master iptables Rules 234 VMware Greenplum v6.17 Documentation VMware, Inc. 8 Example Segment Host iptables Rules 235 PGOPTIONS 238 PGPORT 238 PGUSER 238 PGDATESTYLE 238 PGTZ 238 PGCLIENTENCODING 238 Example Ansible Playbook 238 Example Ansible Playbook 0 Ansible Playbook - Greenplum Database Installation for CentOS

Greenplum Segments 305 Segment Redundancy 306 Segment Failover and Recovery 306 Example Segment Host Hardware Stack 307 Example Segment Disk Layout 308 About the Greenplum Interconnect 309 Interconnect Dead Rows from Tables 321 Example of Managing Transaction IDs 322 Simple MVCC Example 322 Managing Simultaneous Transactions 323 Managing XIDs and the Frozen XID 324 Example of XID Modulo Calculations Creating a PXF External Table 468 Mapping the LOCATION Clause 468 Mapping the FORMAT Options 469 Example gphdfs to pxf External Table Mapping for an HDFS Text File 470 Verifying Access with PXF 470 Removing

Greenplum Segments 265 Segment Redundancy 266 Segment Failover and Recovery 266 Example Segment Host Hardware Stack 267 Example Segment Disk Layout 268 About the Greenplum Interconnect 269 Interconnect Dead Rows from Tables 278 Example of Managing Transaction IDs 279 Simple MVCC Example 280 Managing Simultaneous Transactions 280 Managing XIDs and the Frozen XID 281 Example of XID Modulo Calculations Creating a PXF External Table 457 Mapping the LOCATION Clause 457 Mapping the FORMAT Options 459 Example gphdfs to pxf External Table Mapping for an HDFS Text File 459 Verifying Access with PXF 460 Removing

Greenplum Segments 291 Segment Redundancy 292 Segment Failover and Recovery 292 Example Segment Host Hardware Stack 293 Example Segment Disk Layout 294 About the Greenplum Interconnect 295 Interconnect Dead Rows from Tables 307 Example of Managing Transaction IDs 308 Simple MVCC Example 308 Managing Simultaneous Transactions 309 Managing XIDs and the Frozen XID 310 Example of XID Modulo Calculations Creating a PXF External Table 449 Mapping the LOCATION Clause 449 Mapping the FORMAT Options 450 Example gphdfs to pxf External Table Mapping for an HDFS Text File 451 Verifying Access with PXF 451 Removing

Greenplum Segments 273 Segment Redundancy 274 Segment Failover and Recovery 274 Example Segment Host Hardware Stack 275 Example Segment Disk Layout 276 About the Greenplum Interconnect 277 Interconnect Dead Rows from Tables 289 Example of Managing Transaction IDs 290 Simple MVCC Example 290 Managing Simultaneous Transactions 291 Managing XIDs and the Frozen XID 292 Example of XID Modulo Calculations Creating a PXF External Table 473 Mapping the LOCATION Clause 474 Mapping the FORMAT Options 475 Example gphdfs to pxf External Table Mapping for an HDFS Text File 475 Verifying Access with PXF 476 Removing

Greenplum Segments 261 Segment Redundancy 262 Segment Failover and Recovery 262 Example Segment Host Hardware Stack 263 Example Segment Disk Layout 264 About the Greenplum Interconnect 265 Interconnect Dead Rows from Tables 274 Example of Managing Transaction IDs 275 Simple MVCC Example 276 Managing Simultaneous Transactions 276 Managing XIDs and the Frozen XID 277 Example of XID Modulo Calculations Creating a PXF External Table 455 Mapping the LOCATION Clause 455 Mapping the FORMAT Options 456 Example gphdfs to pxf External Table Mapping for an HDFS Text File 456 Verifying Access with PXF 457 Removing

Greenplum Segments 157 Segment Redundancy 158 Segment Failover and Recovery 158 Example Segment Host Hardware Stack 158 Example Segment Disk Layout 159 About the Greenplum Interconnect 160 Interconnect Dead Rows from Tables 172 Example of Managing Transaction IDs 173 Simple MVCC Example 173 Managing Simultaneous Transactions 174 Managing XIDs and the Frozen XID 175 Example of XID Modulo Calculations iptables (Optional) 261 How to Enable iptables 261 Example iptables Rules 262 Example Coordinator and Standby Coordinator iptables Rules 263 Example Segment Host iptables Rules 263 Installation Management

Greenplum Segments 237 Segment Redundancy 237 Segment Failover and Recovery 238 Example Segment Host Hardware Stack 238 Example Segment Disk Layout 239 About the Greenplum Interconnect 240 Interconnect Dead Rows from Tables 248 Example of Managing Transaction IDs 249 Simple MVCC Example 250 Managing Simultaneous Transactions 250 Managing XIDs and the Frozen XID 251 Example of XID Modulo Calculations Creating a PXF External Table 383 Mapping the LOCATION Clause 384 Mapping the FORMAT Options 385 Example gphdfs to pxf External Table Mapping for an HDFS Text File 385 Verifying Access with PXF 386 Removing