Greenplum Database 管理员指南 版本 V6.2.1 2020 年 09 月 27 日 欢迎关注 Greenplum 官方微信公众号和加入官方社区技术讨论群： ©2020 Esena Chen(陈淼 miaochen@mail.ustc.edu.cn) 编者工作十几年，先 版权所有：Esena(陈淼 +86 18616691889) 编写：陈淼 - 11 - 第一章：GP 数据库架构 目前 GP 数据库已经开源多年，多年来一直由 Pivotal 公司商业运营，在 2020 年，Pivotal 被兄弟公司 VMWare 收购，由 VMWare 继续运营。近年来，Greenplum 在国内建立了一个较大规模的研发团队，越来越多的承担更重要的研发任务，包括 PostgreSQL 管理员指南 V6.2.1 版权所有：Esena(陈淼 +86 18616691889) 编写：陈淼 - 111 - PARTITION BY RANGE (c3)( START ('2020-01-01'::DATE) END ('2100-12-31'::DATE), COLUMN c3 ENCODING (compresstype=zlib) ); 例4

This release backports the following Postgres CVE fixes: CVE-2020-25696 psql’s \gset allows overwriting specially treated variables. CVE-2020-25695/ Multiple features escape “security restricted operation” no longer generates the index scan in this situation. Release 6.13 Release 6.13.0 Release Date: 2020-12-18 VMware Tanzu Greenplum 6.13.0 is a minor release that includes changed features and resolves between 6432 and 61000. This issue has been resolved. Release 6.12 Release 6.12.1 Release Date: 2020-11-20 VMware Tanzu Greenplum 6.12.1 is a maintenance release that resolves several issues. Resolved

This release backports the following Postgres CVE fixes: CVE-2020-25696 psql’s \gset allows overwriting specially treated variables. CVE-2020-25695/ Multiple features escape “security restricted operation” no longer generates the index scan in this situation. Release 6.13 Release 6.13.0 Release Date: 2020-12-18 VMware Tanzu Greenplum 6.13.0 is a minor release that includes changed features and resolves between 6432 and 61000. This issue has been resolved. Release 6.12 Release 6.12.1 Release Date: 2020-11-20 VMware Tanzu Greenplum 6.12.1 is a maintenance release that resolves several issues. Resolved

Options 2017 Examples 2018 See Also 2018 gpmapreduce.yaml 2018 Synopsis 2018 Description 2020 Keys and Values 2020 See Also 2026 gpmemreport 2026 Synopsis 2026 Description 2026 Options 2026 Examples This release backports the following Postgres CVE fixes: CVE-2020-25696 psql’s \gset allows overwriting specially treated variables. CVE-2020-25695/ Multiple features escape “security restricted operation” no longer generates the index scan in this situation. Release 6.13 Release 6.13.0 Release Date: 2020-12-18 VMware Tanzu Greenplum 6.13.0 is a minor release that includes changed features and resolves

pg_restore 2015 Synopsis 2015 Description 2015 Options 2016 Notes 2019 Examples 2019 See Also 2020 pgbouncer 2020 Synopsis 2021 Description 2021 Options 2021 VMware Tanzu Greenplum 6 Documentation VMware This release backports the following Postgres CVE fixes: CVE-2020-25696 psql’s \gset allows overwriting specially treated variables. CVE-2020-25695/ Multiple features escape “security restricted operation” 6 Documentation VMware, Inc 187 in this situation. Release 6.13 Release 6.13.0 Release Date: 2020-12-18 VMware Tanzu Greenplum 6.13.0 is a minor release that includes changed features and resolves

This release backports the following Postgres CVE fixes: CVE-2020-25696 psql’s \gset allows overwriting specially treated variables. CVE-2020-25695/ Multiple features escape “security restricted operation” no longer generates the index scan in this situation. Release 6.13 Release 6.13.0 Release Date: 2020-12-18 VMware Tanzu Greenplum 6.13.0 is a minor release that includes changed features and resolves between 6432 and 61000. This issue has been resolved. Release 6.12 Release 6.12.1 Release Date: 2020-11-20 VMware Tanzu Greenplum 6.12.1 is a maintenance release that resolves several issues. Resolved

Prerequisites 2017 Description 2018 Options 2019 Specifying Hosts using Hostnames or IP Addresses 2020 Using Host Systems with Multiple NICs 2021 Examples 2021 See Also 2021 gpfdist 2022 Synopsis This release backports the following Postgres CVE fixes: CVE-2020-25696 psql's \gset allows overwriting specially treated variables. CVE-2020-25695/ Multiple features escape "security restricted operation" Release 6.13 Release 6.13.0 VMware Greenplum 6 Documentation VMware by Broadcom 226 Release Date: 2020-12-18 VMware Greenplum 6.13.0 is a minor release that includes changed features and resolves several

Deployment Considerations 2017 GPPC Text Function Example 2018 GPPC Set-Returning Function Example 2020 Developing a Background Worker Process 2023 VMware Tanzu Greenplum 6 Documentation VMware, Inc This release backports the following Postgres CVE fixes: CVE-2020-25696 psql’s \gset allows overwriting specially treated variables. CVE-2020-25695/ Multiple features escape “security restricted operation” no longer generates the index scan in this situation. Release 6.13 Release 6.13.0 Release Date: 2020-12-18 VMware Tanzu Greenplum 6.13.0 is a minor release that includes changed features and resolves

This release backports the following Postgres CVE fixes: CVE-2020-25696 psql's \gset allows overwriting specially treated variables. CVE-2020-25695/ Multiple features escape "security restricted operation" no longer generates the index scan in this situation. Release 6.13 Release 6.13.0 Release Date: 2020-12-18 VMware Tanzu Greenplum 6.13.0 is a minor release that includes changed features and resolves between 6432 and 61000. This issue has been resolved. Release 6.12 Release 6.12.1 Release Date: 2020-11-20 VMware Tanzu Greenplum 6.12.1 is a maintenance release that resolves several issues. Resolved

This release backports the following Postgres CVE fixes: CVE-2020-25696 psql's \gset allows overwriting specially treated variables. CVE-2020-25695/ Multiple features escape "security restricted operation" no longer generates the index scan in this situation. Release 6.13 Release 6.13.0 Release Date: 2020-12-18 VMware Greenplum 6.13.0 is a minor release that includes changed features and resolves several between 6432 and 61000. This issue has been resolved. Release 6.12 Release 6.12.1 Release Date: 2020-11-20 VMware Greenplum 6.12.1 is a maintenance release that resolves several issues. Resolved Issues