Pivotal Greenplum 最佳实践分享作 恢复可选表清单,可指定条件恢复部分数据,可恢复到指定增备日期 ## Greenplum集群之间数据传输 ## Transfer命令 基于gpfdist和外部表实现,比基于命名管道的gptransfer更稳定高效 • 两个集群之间必须互相网络连通 集群之间无需ssh互信 • 源端与目标端对象名称可不一致 • 条件源端过滤,降低带条件场景的网络压力 • 源端可以是视图,自动识别是否使用快速模式 命令可部署在可在集群外执行 自动识别低速模式,快速模式和全速模式 • 可指定并发数(同时多张表传输),可指定编码Encoding,解决特殊的乱码问题 命令简单易用——单命令无需部署,参数基本保持与gptransfer一致,自动完成全部必要的准备工作0 码力 | 41 页 | 1.42 MB | 2 年前3
VMware Greenplum v6.25 DocumentationInstalling the Greenplum Database Software. - The gptransfer utility is no longer included; use gpcopy for all functionality that was provided with gptransfer. - The gp_fault_strategy system table is no longer0 码力 | 2400 页 | 18.02 MB | 2 年前3
VMware Tanzu Greenplum v6.20 DocumentationInstalling the Greenplum Database Software. - The gptransfer utility is no longer included; use gpcopy for all functionality that was provided with gptransfer. - The gp_fault_strategy system table is no longer0 码力 | 1988 页 | 20.25 MB | 2 年前3
VMware Greenplum v6.18 DocumentationInstalling the Greenplum Database Software. - The gptransfer utility is no longer included; use gpcopy for all functionality that was provided with gptransfer. - The gp_fault_strategy system table is no longer0 码力 | 1959 页 | 19.73 MB | 2 年前3
VMware Greenplum v6.19 DocumentationInstalling the Greenplum Database Software. - The gptransfer utility is no longer included; use gpcopy for all functionality that was provided with gptransfer. - The gp_fault_strategy system table is no longer0 码力 | 1972 页 | 20.05 MB | 2 年前3
VMware Tanzu Greenplum v6.21 DocumentationInstalling the Greenplum Database Software. - The gptransfer utility is no longer included; use gpcopy for all functionality that was provided with gptransfer. - The gp_fault_strategy system table is no longer0 码力 | 2025 页 | 33.54 MB | 2 年前3
Greenplum Database 管理员指南 6.2.1如果要关闭转义功能,可以使用`ESCAPE 'OFF'`,这样,文本中的所有字符就表现为原本的值,不过,建议不要这么做,尤其是中文环境,没有转义根本无法正常工作,最早的`gptransfer`工具就是这么做的,根本用不了。 ## 字符编码 字符编码系统,是将字符集中的符号和一堆数字进行一对一映射,以便于传输和存储。GP服务端,虽然也支持多种编码集,比如ISO8859系列的单 the writable # gpfdist side. Need a better way to coordinate this. time.sleep(self.__wait_time) 在gptransfer的Python代码中,充斥着各种sleep操作,因为无法精确控制命名管道的状态,导致的结果是,一个表中哪怕只有几条记录,也需要花费至少十多秒来完成数据的传输。在不追求极致性能的场景,很多时候0 码力 | 416 页 | 6.08 MB | 2 年前3
VMware Tanzu Greenplum v6.23 DocumentationInstalling the Greenplum Database Software. The gptransfer utility is no longer included; use gpcopy for all functionality that was provided with gptransfer. The gp_fault_strategy system table is no longer0 码力 | 2298 页 | 40.94 MB | 2 年前3
VMware Tanzu Greenplum 6 DocumentationInstalling the Greenplum Database Software. The gptransfer utility is no longer included; use gpcopy for all functionality that was provided with gptransfer. The gp_fault_strategy system table is no longer0 码力 | 2311 页 | 17.58 MB | 2 年前3
VMware Greenplum 6 DocumentationInstalling the Greenplum Database Software. The gptransfer utility is no longer included; use gpcopy for all functionality that was provided with gptransfer. The gp_fault_strategy system table is no longer0 码力 | 2374 页 | 44.90 MB | 2 年前3
共 11 条
- 1
- 2
相关搜索词
GreenplumgpcrondumpgpfdistgptransfergpcheckperfGreenplum Databasedifferential segment recoverypg_auditgprecoversegPXFMassively Parallel ProcessingData WarehousingResource GroupsGPORCAgpstate命令optimizer_xform_bind_thresholdgp_autostats_allow_nonownergp_legacy_string_agglicence文件Massively Parallel Processing (MPP)Query Optimizer (GPORCA)Resource QueuesGreenplum Command CenterTanzu GreenplumMPP数据库contrib模块vSAN升级安装架构管理节点SQL标准兼容性新功能改进PostgreSQLSegment MirroringAppend-Optimized StorageHigh Availability













