crondump一致，自动完成全部必要的准备工作 恢复可选表清单，可指定条件恢复部分数据，可恢复到指定增备日期 ## Greenplum集群之间数据传输 ## Transfer命令 基于gpfdist和外部表实现，比基于命名管道的gptransfer更稳定高效 • 两个集群之间必须互相网络连通 集群之间无需ssh互信 • 源端与目标端对象名称可不一致 • 条件源端过滤，降低带条件场景的网络压力

Viewing the Database Server Log Files 505 Encrypting Data and Database Connections 508 Encrypting gpfdist Connections 508 Encrypting Data at Rest with pgcrypto 509 Creating PGP Keys 511 Encrypting Data in Data 583 Accessing External Data with PXF 584 Defining External Tables 584 file:// Protocol 587 gpfdist:// Protocol 588 gpfdists:// Protocol 588 pxf:// Protocol 590 s3:// Protocol 590 Configuring the s3 Tables 604 Example 1—Single gpfdist instance on single-NIC machine 605 Example 2—Multiple gpfdist instances 605 Example 3—Multiple gpfdists instances 605 Example 4—Single gpfdist instance with error logging

Viewing the Database Server Log Files 527 Encrypting Data and Database Connections 530 Encrypting gpfdist Connections 531 Encrypting Data at Rest with pgcrypto 532 Creating PGP Keys 533 Encrypting Data in Data 607 Accessing External Data with PXF 608 Defining External Tables 609 file:// Protocol 612 gpfdist:// Protocol 612 gpfdists:// Protocol 613 pxf:// Protocol 614 s3:// Protocol 615 Configuring the s3 Tables 629 Example 1—Single gpfdist instance on single-NIC machine 630 Example 2—Multiple gpfdist instances 630 Example 3—Multiple gpfdists instances 631 Example 4—Single gpfdist instance with error logging

Viewing the Database Server Log Files 507 Encrypting Data and Database Connections 510 Encrypting gpfdist Connections 511 Encrypting Data at Rest with pgcrypto 512 Creating PGP Keys 513 Encrypting Data in Data 586 Accessing External Data with PXF 587 Defining External Tables 587 file:// Protocol 590 gpfdist:// Protocol 590 gpfdists:// Protocol 591 VMware Tanzu Greenplum 6 Documentation VMware, Inc 25 Tables 607 Example 1—Single gpfdist instance on single-NIC machine 608 Example 2—Multiple gpfdist instances 608 Example 3—Multiple gpfdists instances 608 Example 4—Single gpfdist instance with error logging

the Database Server Log Files 532 Encrypting Data and Database Connections 535 Encrypting gpfdist Connections 536 Encrypting Data at Rest with pgcrypto 537 Creating PGP Keys 538 Encrypting Accessing External Data with PXF 615 Defining External Tables 615 file:// Protocol 618 gpfdist:// Protocol 619 gpfdists:// Protocol 619 pxf:// Protocol 621 s3:// Protocol 621 Configuring 636 Example 1—Single gpfdist instance on single-NIC machine 637 Example 2—Multiple gpfdist instances 637 Example 3—Multiple gpfdists instances 637 Example 4—Single gpfdist instance with error logging

Statement with Column Values 287 COPY Statement 287 External Tables 287 External Tables with Gpfdist 288 Gpload 289 Best Practices 289 Additional Information 290 Security 290 Security 378 with pgcrypto 295 Creating PGP Keys 296 Encrypting Data in Tables using PGP 298 Encrypting gpfdist Connections 301 Tuning SQL Queries 303 Tuning SQL Queries 0 How to Generate Explain Plans 303 Encrypting Data and Database Connections 0 Encrypting Data and Database Connections 0 Encrypting gpfdist Connections 632 Encrypting Data at Rest with pgcrypto 633 Creating PGP Keys 634 Encrypting

- 241 外部表协议..... - 244 错误记录处理..... - 250 gpfdist 服务..... - 252 使用外部表导入数据..... - 257 使用外部表导出数据..... - 258 使用 gpfdist 协议外部表导出数据..... - 258 使用基于命令的 WEB 型外部表导出数据..... - 259 的并行文件分发服务 (gpfdist)，管理员可以实现最大化的利用网络带宽资源以实现高速并行装载。  上图展示了 GP 外部表和 gpfdist 是如何配合，以实现高速数据装载的，该模式的性能是完全线性扩展的，数据直接在 gpfdist 和 Primary 1、要确保外部表用到的协议在 GP 数据库中已经具备。 目前的例子，我们选择用 gpfdist 协议，例如，我们在 192.168.88.66 机器上启动 gpfdist 服务。 $ hohup gpfdist -p 8080 -d /../>/dev/null 2>&1 & 此处说明一下，gpfdist 不允许直接在/目录上启动服务，因此可以通过/../的方式间接的从/上启动服务。

INSERT Statement with Column Values 361 COPY Statement 361 External Tables 361 External Tables with Gpfdist 362 Gpload 363 Best Practices 363 Additional Information 364 Security 364 Security 452 Basic Rest with pgcrypto 369 Creating PGP Keys 370 Encrypting Data in Tables using PGP 372 Encrypting gpfdist Connections 375 Tuning SQL Queries 377 Tuning SQL Queries 0 How to Generate Explain Plans 377 Encrypting Data and Database Connections 0 Encrypting Data and Database Connections 0 Encrypting gpfdist Connections 709 Encrypting Data at Rest with pgcrypto 710 Creating PGP Keys 711 Encrypting Data

Statement with Column Values 352 COPY Statement 352 External Tables 352 External Tables with Gpfdist 353 Gpload 354 Best Practices 354 Additional Information 355 Security 355 Security 443 Basic Rest with pgcrypto 360 Creating PGP Keys 361 Encrypting Data in Tables using PGP 363 Encrypting gpfdist Connections 366 Tuning SQL Queries 368 Tuning SQL Queries 0 How to Generate Explain Plans 368 Encrypting Data and Database Connections 0 Encrypting Data and Database Connections 0 Encrypting gpfdist Connections 700 Encrypting Data at Rest with pgcrypto 701 Creating PGP Keys 702 Encrypting Data

Statement with Column Values 355 COPY Statement 355 External Tables 356 External Tables with Gpfdist 356 Gpload 357 Best Practices 358 Additional Information 359 Security 359 Basic Security Best Rest with pgcrypto 364 Creating PGP Keys 365 Encrypting Data in Tables using PGP 367 Encrypting gpfdist Connections 370 Tuning SQL Queries 372 How to Generate Explain Plans 372 How to Read Explain Plans Encrypting Data and Database Connections 697 Encrypting Data and Database Connections 0 Encrypting gpfdist Connections 698 Encrypting Data at Rest with pgcrypto 699 Creating PGP Keys 700 Encrypting Data