About Migrating Views Created with lag()/lead() Functions 478 Backing Up and Restoring a Database 479 Completing the Migration 480 Working With Hash Operator Classes in Greenplum 6 480 Migrating from Password Hash Algorithm System-wide 526 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 526 Using SHA-256 Password Encryption 527 Setting the SHA-256 Password Hash Algorithm Algorithm System-wide 527 Setting the SHA-256 Password Hash Algorithm for an Individual Session 527 VMware Greenplum 6 Documentation VMware by Broadcom 25 Example 528 Restricting Access by Time 529 Example

and Upgrade 301 Backing Up and Restoring a Database 305 Completing the Migration 306 Working With Hash Operator Classes in Greenplum 6 307 Enabling iptables (Optional) 308 Enabling iptables (Optional) Explain Plans 378 Optimizing Greenplum Queries 380 Greenplum Grouping Extensions 381 Window Functions 381 High Availability 382 High Availability 0 Disk Storage 382 Best Practices 383 Master Mirroring Greenplum Database MADlib Package 397 Adding MADlib Functions to a Database 397 Upgrading MADlib 397 Upgrading a MADlib Package 398 Upgrading MADlib Functions 398 Uninstalling MADlib 398 Remove MADlib objects

About Migrating Views Created with lag()/lead() Functions 459 Backing Up and Restoring a Database 460 Completing the Migration 461 Working With Hash Operator Classes in Greenplum 6 461 Migrating from Password Hash Algorithm System-wide 497 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 497 Using SHA-256 Password Encryption 498 Setting the SHA-256 Password Hash Algorithm Algorithm System-wide 498 Setting the SHA-256 Password Hash Algorithm for an Individual Session 498 Example 499 Restricting Access by Time 499 Example 1 – Create a New Role with Time-based Constraints 501

About Migrating Views Created with lag()/lead() Functions 484 Backing Up and Restoring a Database 485 Completing the Migration 485 Working With Hash Operator Classes in Greenplum 6 486 Migrating from Password Hash Algorithm System-wide 521 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 521 Using SHA-256 Password Encryption 522 Setting the SHA-256 Password Hash Algorithm Algorithm System-wide 522 Setting the SHA-256 Password Hash Algorithm for an Individual Session 522 Example 523 Restricting Access by Time 523 Example 1 – Create a New Role with Time-based Constraints 525

and Upgrade 292 Backing Up and Restoring a Database 296 Completing the Migration 297 Working With Hash Operator Classes in Greenplum 6 297 Enabling iptables (Optional) 299 Enabling iptables (Optional) Explain Plans 369 Optimizing Greenplum Queries 371 Greenplum Grouping Extensions 372 Window Functions 373 High Availability 373 High Availability 0 Disk Storage 373 Best Practices 374 Master Mirroring Greenplum Database MADlib Package 388 Adding MADlib Functions to a Database 388 Upgrading MADlib 388 Upgrading a MADlib Package 389 Upgrading MADlib Functions 389 Uninstalling MADlib 389 VMware Greenplum

About Migrating Views Created with lag()/lead() Functions 467 Backing Up and Restoring a Database 468 Completing the Migration 468 Working With Hash Operator Classes in Greenplum 6 469 Enabling iptables Password Hash Algorithm System-wide 501 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 501 Using SHA-256 Password Encryption 502 Setting the SHA-256 Password Hash Algorithm Algorithm System-wide 502 Setting the SHA-256 Password Hash Algorithm for an Individual Session 502 Example 503 Restricting Access by Time 503 Example 1 – Create a New Role with Time-based Constraints 505

About Migrating Views Created with lag()/lead() Functions 464 Backing Up and Restoring a Database 465 Completing the Migration 466 Working With Hash Operator Classes in Greenplum 6 466 Enabling iptables Password Hash Algorithm System-wide 499 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 499 Using SHA-256 Password Encryption 500 Setting the SHA-256 Password Hash Algorithm Algorithm System-wide 500 Setting the SHA-256 Password Hash Algorithm for an Individual Session 500 Example 501 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 21 Restricting Access by Time 501 Example

About Migrating Views Created with lag()/lead() Functions 392 Backing Up and Restoring a Database 393 Completing the Migration 394 Working With Hash Operator Classes in Greenplum 6 394 Enabling iptables Password Hash Algorithm System-wide 423 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 424 Using SHA-256 Password Encryption 424 Setting the SHA-256 Password Hash Algorithm Algorithm System-wide 424 Setting the SHA-256 Password Hash Algorithm for an Individual Session 425 Example 425 Restricting Access by Time 426 Example 1 – Create a New Role with Time-based Constraints 427

for Backup 297 Backing Up and Restoring a Database 300 Completing the Migration 301 Working With Hash Operator Classes in Greenplum 6 301 Enabling iptables (Optional) 303 How to Enable iptables 303 Explain Plans 373 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 Greenplum Database MADlib Package 391 Adding MADlib Functions to a Database 392 Upgrading MADlib 392 Upgrading a MADlib Package 392 Upgrading MADlib Functions 393 Uninstalling MADlib 393 Remove MADlib objects

and Upgrade 226 Backing Up and Restoring a Database 229 Completing the Migration 230 Working With Hash Operator Classes in Greenplum 6 231 Enabling iptables (Optional) 232 Enabling iptables (Optional) Explain Plans 304 Optimizing Greenplum Queries 306 Greenplum Grouping Extensions 307 Window Functions 308 High Availability 308 High Availability 0 Disk Storage 308 Best Practices 309 Master Mirroring Greenplum Database MADlib Package 323 Adding MADlib Functions to a Database 323 Upgrading MADlib 323 Upgrading a MADlib Package 324 Upgrading MADlib Functions 324 Uninstalling MADlib 324 Remove MADlib objects