2018年PostgreSQL中国技术大会 PostgreSQL和Greenplum 数据库故障排查 赵振平 zzp@taryartar.com 北京太阳塔信息科技有限责任公司 2018年PostgreSQL中国技术大会 自我介绍 微信号：laohouzi999 2018年PostgreSQL中国技术大会 • 赵振平，太阳塔技术总监 • 电子工业出版社签约作家 • 腾讯最具价值专家（TVP） 出版了技术专著《IT架构实录》 微信号：laohouzi999 2018年PostgreSQL中国技术大会 微信号：laohouzi999 2018年PostgreSQL中国技术大会 PG故障排查 微信号：laohouzi999 2018年PostgreSQL中国技术大会 微信号：laohouzi999 1.安装时候的问题排查 2018年PostgreSQL中国技术大会 微信号：laohouzi999 1)关闭防火墙 chkconfig --level 0123456 iptables off 2)临时目录/tmp（安装日志） 3)服务器日志（PostgreSQL server error log） 2018年PostgreSQL中国技术大会 微信号：laohouzi999 服务器日志（PostgreSQL server error log） -bash-4.1$ locate pg_ctl /usr/pgsql-10/bin/pg_ctl

Resolved Issues 215 Release 6.0.0 216 New Features 217 PostgreSQL Core Features 217 INTERVAL Data Type Handling 217 Additional PostgreSQL Features 218 Zstandard Compression Algorithm 218 Relaxed Storage Plugin with gpbackup and gprestore 569 Using the S3 Storage Plugin with gpbackup and gprestore 0 Prerequisites 569 Installing the S3 Storage Plugin 569 Using the S3 Storage Plugin 569 S3 Storage Storage Plugin Configuration File Format 571 VMware Greenplum v6.19 Documentation VMware, Inc. 31 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager 573 Using the DD Boost

Resolved Issues 207 Release 6.0.0 209 New Features 209 PostgreSQL Core Features 209 INTERVAL Data Type Handling 209 Additional PostgreSQL Features 210 Zstandard Compression Algorithm 210 Relaxed Storage Plugin with gpbackup and gprestore 560 Using the S3 Storage Plugin with gpbackup and gprestore 0 Prerequisites 560 Installing the S3 Storage Plugin 560 Using the S3 Storage Plugin 560 S3 Storage Storage Plugin Configuration File Format 562 VMware Greenplum v6.18 Documentation VMware, Inc. 30 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager 564 Using the DD Boost

Resolved Issues 212 Release 6.0.0 213 New Features 214 PostgreSQL Core Features 214 INTERVAL Data Type Handling 214 Additional PostgreSQL Features 215 Zstandard Compression Algorithm 215 Relaxed 561 Using the S3 Storage Plugin with gpbackup and gprestore 561 Prerequisites 561 Installing the S3 Storage Plugin 561 Using the S3 Storage Plugin 562 S3 Storage Plugin Configuration File Format 563 563 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup\_manager 565 DD Boost Storage Plugin Configuration File Format 565 Examples 567 Notes 568 Replicating Backups 569 Replicate

Storage Plugin with gpbackup and gprestore 492 Using the S3 Storage Plugin with gpbackup and gprestore 0 Prerequisites 492 Installing the S3 Storage Plugin 492 Using the S3 Storage Plugin 492 S3 Storage Storage Plugin Configuration File Format 494 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager 496 VMware Greenplum v6.17 Documentation VMware, Inc. 26 Using the DD Boost Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager 0 DD Boost Storage Plugin Configuration File Format 496 Examples 499 Notes 500 Replicating Backups 500 Replicating Backups 0 Replicate

Resolved Issues 267 Release 6.0.0 269 New Features 269 PostgreSQL Core Features 269 INTERVAL Data Type Handling 269 Additional PostgreSQL Features 270 Zstandard Compression Algorithm 271 Relaxed Parameters 518 OpenSSL Configuration 518 Creating a Self-Signed Certificate 518 Configuring postgresql.conf for SSL Authentication 519 Configuring the SSL Client Connection 520 PAM-Based Authentication Registering the Module 1853 Greenplum Database Limitations 1853 Additional Module Documentation 1854 postgresql-hll 1854 Installing and Registering the Module 1854 Module Documentation 1854 sslinfo 1854

Resolved Issues 254 Release 6.0.0 255 New Features 256 PostgreSQL Core Features 256 INTERVAL Data Type Handling 256 Additional PostgreSQL Features 257 Zstandard Compression Algorithm 257 Relaxed Parameters 488 OpenSSL Configuration 489 Creating a Self-Signed Certificate 489 Configuring postgresql.conf for SSL Authentication 490 Configuring the SSL Client Connection 490 PAM-Based Authentication Registering the Module 1813 Greenplum Database Limitations 1813 Additional Module Documentation 1813 postgresql-hll 1813 Installing and Registering the Module 1813 Module Documentation 1813 sslinfo 1814

Resolved Issues 228 Release 6.0.0 229 New Features 230 PostgreSQL Core Features 230 INTERVAL Data Type Handling 230 Additional PostgreSQL Features 231 Zstandard Compression Algorithm 231 Relaxed Parameters 493 OpenSSL Configuration 493 Creating a Self-Signed Certificate 494 Configuring postgresql.conf for SSL Authentication 494 Configuring the SSL Client Connection 495 VMware Tanzu Greenplum Transforms a one dimensional array into rows. Returns a set of anyelement, a polymorphic pseudo-type in PostgreSQL. 785 Working with JSON Data 785 About JSON Data 786 About Unicode Characters in JSON Data 786

Resolved Issues 235 Release 6.0.0 237 New Features 237 PostgreSQL Core Features 237 INTERVAL Data Type Handling 237 Additional PostgreSQL Features 238 Zstandard Compression Algorithm 238 Relaxed Parameters 512 OpenSSL Configuration 513 Creating a Self-Signed Certificate 513 Configuring postgresql.conf for SSL Authentication 514 Configuring the SSL Client Connection 514 PAM-Based Authentication Registering the Module 1820 Greenplum Database Limitations 1820 Additional Module Documentation 1821 postgresql-hll 1821 Installing and Registering the Module 1821 Module Documentation 1821 sslinfo 1821

Resolved Issues 224 Release 6.0.0 226 New Features 226 PostgreSQL Core Features 227 INTERVAL Data Type Handling 227 Additional PostgreSQL Features 227 Zstandard Compression Algorithm 228 Relaxed Parameters 491 OpenSSL Configuration 491 Creating a Self-Signed Certificate 491 Configuring postgresql.conf for SSL Authentication 492 Configuring the SSL Client Connection 493 PAM-Based Authentication Registering the Module 1764 Greenplum Database Limitations 1764 Additional Module Documentation 1764 postgresql-hll 1764 Installing and Registering the Module 1764 Module Documentation 1765 sslinfo 1765