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 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

Resolved Issues 204 Release 6.0.0 205 New Features 205 PostgreSQL Core Features 206 INTERVAL Data Type Handling 206 Additional PostgreSQL Features 206 Zstandard Compression Algorithm 207 Relaxed Parameters 416 OpenSSL Configuration 416 Creating a Self-Signed Certificate 417 Configuring postgresql.conf for SSL Authentication 417 Configuring the SSL Client Connection 418 PAM-Based Authentication Transforms a one dimensional array into rows. Returns a set of anyelement, a polymorphic pseudo-type in PostgreSQL. 678 Working with JSON Data 678 About JSON Data 679 About Unicode Characters in JSON Data 679

Parameters 284 OpenSSL Configuration 284 Creating a Self-Signed Certificate 284 Configuring postgresql.conf for SSL Authentication 285 Configuring the SSL Client Connection 286 PAM-Based Authentication 1669 Installing and Registering the Module 1669 Using postgres_fdw to Access Multiple Remote PostgreSQL Servers 1670 About Aggregate Pushdown Support 1670 About Limit Pushdown Support 1671 Distributed postgres_fdw Limitations 1671 Greenplum Database Limitations 1671 Additional Module Documentation 1671 postgresql-hll 1672 Installing and Registering the Module 1672 Module Documentation 1672 sslinfo 1672

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 Parameters 688 OpenSSL Configuration 688 Creating a Self-Signed Certificate 689 Configuring postgresql.conf for SSL Authentication 689 Configuring the SSL Client Connection 690 PAM-Based Authentication Parameters 1562 Append-Optimized Table Parameters 1562 Past Version Compatibility Parameters 1562 PostgreSQL 1563 Greenplum Database 1563 Greenplum Database Array Configuration Parameters 1563 Interconnect

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 Parameters 679 OpenSSL Configuration 679 Creating a Self-Signed Certificate 680 Configuring postgresql.conf for SSL Authentication 680 Configuring the SSL Client Connection 681 PAM-Based Authentication Parameters 1553 Append-Optimized Table Parameters 1553 Past Version Compatibility Parameters 1553 PostgreSQL 1554 Greenplum Database 1554 Greenplum Database Array Configuration Parameters 1554 Interconnect