★第1章、安装postgresql # yum install postgresql-server -y # EL8安装光盘AppSteam里自带有10.x 版本的软件包 # postgresql-setup --initdb --unit postgresql # systemctl enable postgresql # systemctl start ------------------------------------------------------------- PostgreSQL 13.13 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18)... postgres=# select usename from pg_user;

2018年PostgreSQL中国技术大会 为什么我们抛弃MongoDB和 MySQL，选择PgSQL 张启程 qc@aochuang.cn 奥创软件研究院（上海）研发中心 2018年PostgreSQL中国技术大会 任何数据库都很好用 • 我不是一个专业的DBA ，对数据库的理解不够深入，也不 一定准确，在此抛砖引玉，只是结合我们团队业务场景来 分享下我们选择数据库的过程。 •

Postgres Conference China 2016 中国用户大会 PostgreSQL WAL日志解析与应用 王硕 山东瀚高基础软件股份有限公司 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 CONTENTS Part 01 Part 02 Part 03 WAL 日志简介

clause was also added. • A new program (psql) was provided for interactive SQL queries, which used GNU Readline. This largely superseded the old monitor program. • A new front-end library, libpgtcl, supported introducing regular SQL features as well as those of Postgres95 was distributed with the source code • GNU make (instead of BSD make) was used for the build. Also, Postgres95 could be compiled with an unpatched ---------------------------------------------------------------- PostgreSQL 8.1.11 on i586-pc-linux-gnu, compiled by GCC 2.96 (1 row) mydb=> SELECT current_date; date ------------ 2002-08-31 (1 row) mydb=>

clause was also added. • A new program (psql) was provided for interactive SQL queries, which used GNU Readline. This largely superseded the old monitor program. • A new front-end library, libpgtcl, supported introducing regular SQL features as well as those of Postgres95 was distributed with the source code • GNU make (instead of BSD make) was used for the build. Also, Postgres95 could be compiled with an unpatched ---------------------------------------------------------------- PostgreSQL 8.1.0 on i586-pc-linux-gnu, compiled by GCC 2.96 (1 row) mydb=> SELECT current_date; date ------------ 2002-08-31 (1 row) mydb=>

clause was also added. • A new program (psql) was provided for interactive SQL queries, which used GNU Readline. This largely superseded the old monitor program. • A new front-end library, libpgtcl, supported introducing regular SQL features as well as those of Postgres95 was distributed with the source code • GNU make (instead of BSD make) was used for the build. Also, Postgres95 could be compiled with an unpatched ---------------------------------------------------------------- PostgreSQL 8.0.0 on i586-pc-linux-gnu, compiled by GCC 2.96 (1 row) mydb=> SELECT current_date; date ------------ 2002-08-31 (1 row) mydb=>

clause was also added. • A new program (psql) was provided for interactive SQL queries, which used GNU Readline. This largely superseded the old monitor program. • A new front-end library, libpgtcl, supported introducing regular SQL features as well as those of Postgres95 was distributed with the source code • GNU make (instead of BSD make) was used for the build. Also, Postgres95 could be compiled with an unpatched ---------------------------------------------------------------- PostgreSQL 8.0.0 on i586-pc-linux-gnu, compiled by GCC 2.96 (1 row) mydb=> SELECT current_date; date ------------ 2002-08-31 (1 row) mydb=>

clause was also added. • A new program (psql) was provided for interactive SQL queries, which used GNU Readline. This largely superseded the old monitor program. • A new front-end library, libpgtcl, supported introducing regular SQL features as well as those of Postgres95 was distributed with the source code • GNU make (instead of BSD make) was used for the build. Also, Postgres95 could be compiled with an unpatched ---------------------------------------------------------------- PostgreSQL 8.2.22 on i586-pc-linux-gnu, compiled by GCC 2.96 (1 row) mydb=> SELECT current_date; date ------------ 2002-08-31 (1 row) mydb=>

clause was also added. • A new program (psql) was provided for interactive SQL queries, which used GNU Readline. This largely superseded the old monitor program. • A new front-end library, libpgtcl, supported introducing regular SQL features as well as those of Postgres95 was distributed with the source code • GNU make (instead of BSD make) was used for the build. Also, Postgres95 could be compiled with an unpatched ---------------------------------------------------------------- PostgreSQL 8.2.13 on i586-pc-linux-gnu, compiled by GCC 2.96 (1 row) mydb=> SELECT current_date; date ------------ 2002-08-31 (1 row) mydb=>

Skunkware...................................................................................355 15.8.6.2. GNU Make ..................................................................................355 15.8.6.3 clause was also added. • A new program (psql) was provided for interactive SQL queries, which used GNU Readline. This largely superseded the old monitor program. • A new front-end library, libpgtcl, supported introducing regular SQL features as well as those of Postgres95 was distributed with the source code • GNU make (instead of BSD make) was used for the build. Also, Postgres95 could be compiled with an unpatched