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 Science Library Package 446 Uninstalling the R Data Science Library Package 447 Greenplum Platform Extension Framework (PXF) 447 Installing Additional Supplied Modules 447 Configuring Timezone and Localization 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

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 Science Library Package 427 Uninstalling the R Data Science Library Package 428 Greenplum Platform Extension Framework (PXF) 428 Installing Additional Supplied Modules 428 Configuring Timezone and Localization 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

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 Science Library Package 451 Uninstalling the R Data Science Library Package 452 Greenplum Platform Extension Framework (PXF) 453 Installing Additional Supplied Modules 453 Configuring Timezone and Localization 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

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 Science Library Package 436 Uninstalling the R Data Science Library Package 437 Greenplum Platform Extension Framework (PXF) 437 Installing Additional Supplied Modules 438 Configuring Timezone and Localization 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

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 Science Library Package 434 Uninstalling the R Data Science Library Package 434 Greenplum Platform Extension Framework (PXF) 435 Installing Additional Supplied Modules 435 VMware Tanzu Greenplum 6 Documentation 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

Science Library Package 234 Uninstalling the R Data Science Library Package 234 Greenplum Platform Extension Framework (PXF) 235 Installing Additional Supplied Modules 235 Configuring Timezone and Localization 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 Wrapper Helper Functions 414 Greenplum Database Considerations 415 Building a Foreign Data Wrapper Extension with PGXS 416 Deployment Considerations 418 Accessing External Data with External Tables 418

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 Science Library Package 364 Uninstalling the R Data Science Library Package 365 Greenplum Platform Extension Framework (PXF) 366 Installing Additional Supplied Modules 366 Configuring Timezone and Localization 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

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 Uninstalling the R Data Science Library Package 286 Greenplum Platform Extension Framework (PXF) 286 Greenplum Platform Extension Framework (PXF) 0 Installing Additional Supplied Modules 286 Installing Greenplum PostGIS Extension 413 Enabling and Removing PostGIS Support 415 Enabling PostGIS Support 415 Installing the Greenplum PostGIS Extension Package 415 Using the CREATE EXTENSION Command 415 Enabling

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 Uninstalling the R Data Science Library Package 276 Greenplum Platform Extension Framework (PXF) 277 Greenplum Platform Extension Framework (PXF) 0 Installing Additional Supplied Modules 277 Installing Greenplum PostGIS Extension 404 Enabling and Removing PostGIS Support 406 Enabling PostGIS Support 406 Installing the Greenplum PostGIS Extension Package 406 Using the CREATE EXTENSION Command 406 Enabling