itpub.net]Greenplum管理实践

《itpub.net]Greenplum管理实践》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Practicehttp://weibo.com/viadea2011.07.24商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办Allofthesearemyownopinion,notforanycompany.FeelfreetocorrectmeifIamwrong.商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办Architecture–sharenothing(MPP)商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办Que

2、ryWorkerProcesses商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办ResourceQueue商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办DataMirror商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办MasterMirror商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办ParallelBackup商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办Non-ParallelRestore商业智能研讨沙龙－上海站ITPUBChinaUnixIXP

3、UB主办Non-ParallelRestore商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办Q&ABeforegoingfurther,herecomesQ&A商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办1.ManagingRolesandPrivilegesRole=User+Group商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办2.ConfiguringClientAuthenticationpg_hba.conflocalallgpadmintrusthostallgpadmin12

4、7.0.0.1/32password商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办3.ManagingWorkloadandResourcesResourcequeueCREATERESOURCEQUEUEexecutiveWITH(ACTIVE_STATEMENTS=3,PRIORITY=MAX);商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办4.DefiningDatabaseObjectsMulti-levelPartitionDesignCheckconstraint商业智能研讨沙龙－上海站ITPUBCh

5、inaUnixIXPUB主办5.ManagingDataVacuumingtheDatabase商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办6.LoadingandUnloadingDatagploadYAMLfile商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办7.HighAvailabilitySegmentfailuregprecoversegMasterfailuregpactivatestandbyStandbymasteroutofsyncgpinitstandby商业智能研讨沙龙－上海站ITPUB

6、ChinaUnixIXPUB主办8.Backupandrestoregp_dumpandgp_restorepg_dump商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办9.ExpandingaGreenplumSystemgpexpandTointeractivelycreateanexpansioninputfile:gpexpand-fhosts_fileToinitializesegmentsandcreateexpansionschema:gpexpand-iinput_file-Ddatabase_nameToredist

7、ributetables:gpexpand-ddurationToremovetheexpansionschema:gpexpand-c商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办Q&ABeforegoingfurtherandfurther,herecomesQ&A商业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办Troubleshooting(1)SIGSEGVsgp_reraise_signalIfenabled,willattempttodumpcoreifafatalservererroroccurs.商

8、业智能研讨沙龙－上海站ITPUBChinaUnixIXPUB主办Troubleshooting