listen_addresses = '*' port = 5432 # vi /var/lib/pgsql/13/data/pg_hba.conf #pg-13版本，添加以下一行表示允 许所有客户端ip远程连接 #若修改了存储路径，则在新的路径下/data_pg/data/pg_hba.conf host all all 0.0.0.0/0 listen_addresses = '*' port = 5432 # vi /var/lib/pgsql/data/pg_hba.conf #pg-10版本，添加以下一行表示允许 所有客户端ip远程连接 #若修改了存储路径，则在新的路径下/data_pg/data/pg_hba.conf host all all 0.0.0.0/0 #提示符=>前的db_test表示当前数据库名 用户信息保存在postgres库下面的名为pg_catalg的schema下的pg_user表里： ★第5章、使用客户端连接 ①命令行客户端连接pg数据库 # psql -h 10.99.1.122 -p 5432 -U postgres #连接pg数据库， # -h指定地址，-p指定端口号，-U指

2018年PostgreSQL中国技术大会 主要业务场景 • IM工具+SCRM系统（高并发、低延迟、稳定） • 大量客户需要私有化云服务器部署（云更新） • 需求变更频繁，不适合关系型数据库 2018年PostgreSQL中国技术大会 目前服务器架构 2018年PostgreSQL中国技术大会 MySQL应用史 • 最开始做的站群系统WEB端使用MySQL： • copy简单快速，批量复制，替换修改简单； MongoDB存储，减轻MySQL负担； • 这种方式虽然可以暂时解决问题，我们自己用也没有任何 问题，可以结合各自数据库优点，发挥性能。但是我们有 很多客户是需要私有化部署数据库，让每家客户都接受这 种方式，会为甲方增加很多服务器以及运维成本，可能客 户数据量很少，也需要使用双数据库，更新运维都比较麻 烦。 2018年PostgreSQL中国技术大会 PgSQL≈MySQL+MongoDB • 个人认为，PgSQL结合了MySQL关系型数据库事务处理能力

by adding new • data types • functions • operators • aggregate functions • index methods 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html xlviii Preface • procedural languages And burden, the Berkeley POSTGRES project officially ended with Version 4.2. 2. http://www.informix.com/ 3. http://www.ibm.com/ 4. http://meteora.ucsd.edu/s2k/s2k_home.html xlix Preface 2.2. Postgres95 In guarantee that every part 5. http://wiki.postgresql.org 6. http://wiki.postgresql.org/wiki/Frequently_Asked_Questions 7. http://wiki.postgresql.org/wiki/Todo 8. http://www.postgresql.org li Preface

PostgreSQL can be extended by the user in many ways, for example by adding new • data types 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html lii Preface • functions • operators • aggregate and support was taking up large amounts of time that should have been 2. http://www.informix.com/ 3. http://www.ibm.com/ 4. http://meteora.ucsd.edu/s2k/s2k_home.html liii Preface devoted to database PostgreSQL web site for details. 5. http://wiki.postgresql.org 6. http://wiki.postgresql.org/wiki/Frequently_Asked_Questions 7. http://wiki.postgresql.org/wiki/Todo 8. http://www.postgresql.org lv Preface

PostgreSQL can be extended by the user in many ways, for example by adding new • data types 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html xlviii Preface • functions • operators and support was taking up large amounts of time that should have been 2. http://www.informix.com/ 3. http://www.ibm.com/ 4. http://meteora.ucsd.edu/s2k/s2k_home.html xlix Preface devoted to database tation or through the mailing lists. Consider contributing your knowledge back. Read the mailing 5. http://www.postgresql.org li Preface lists and answer questions. If you learn something which is not

by adding new • data types • functions • operators • aggregate functions • index methods 1. http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/postgres.html xliv Preface • procedural languages And burden, the Berkeley POSTGRES project officially ended with Version 4.2. 2. http://www.informix.com/ 3. http://www.ibm.com/ 4. http://meteora.ucsd.edu/s2k/s2k_home.html xlv Preface 2.2. Postgres95 In effective fashion. No one is required to follow them but doing so tends to be to everyone’s advantage. 5. http://www.postgresql.org xlvii Preface We cannot promise to fix every bug right away. If the bug is

PostgreSQL can be extended by the user in many ways, for example by adding new • data types 1. http://db.cs.berkeley.edu/postgres.html lvi Preface • functions • operators • aggregate functions and support was taking up large amounts of time that should have been 2. http://www.informix.com/ 3. http://www.ibm.com/ 4. http://meteora.ucsd.edu/s2k/s2k_home.html lvii Preface devoted to database PostgreSQL web site for details. 5. http://wiki.postgresql.org 6. http://wiki.postgresql.org/wiki/Frequently_Asked_Questions 7. http://wiki.postgresql.org/wiki/Todo 8. http://www.postgresql.org lix Preface

by adding new • data types • functions • operators • aggregate functions • index methods 1. http://db.cs.berkeley.edu/postgres.html lii Preface • procedural languages And because of the liberal burden, the Berkeley POSTGRES project officially ended with Version 4.2. 2. http://www.informix.com/ 3. http://www.ibm.com/ 4. http://meteora.ucsd.edu/s2k/s2k_home.html liii Preface 2.2. Postgres95 In guarantee that every part 5. http://wiki.postgresql.org 6. http://wiki.postgresql.org/wiki/Frequently_Asked_Questions 7. http://wiki.postgresql.org/wiki/Todo 8. http://www.postgresql.org lv Preface

by adding new • data types • functions • operators • aggregate functions • index methods 1. http://db.cs.berkeley.edu/postgres.html lviii Preface • procedural languages And because of the liberal burden, the Berkeley POSTGRES project officially ended with Version 4.2. 2. http://www.informix.com/ 3. http://www.ibm.com/ 4. http://meteora.ucsd.edu/s2k/s2k_home.html lix Preface 2.2. Postgres95 In guarantee that every part 5. http://wiki.postgresql.org 6. http://wiki.postgresql.org/wiki/Frequently_Asked_Questions 7. http://wiki.postgresql.org/wiki/Todo 8. http://www.postgresql.org lxi Preface

PostgreSQL can be extended by the user in many ways, for example by adding new • data types 1. http://db.cs.berkeley.edu/postgres.html lxii Preface • functions • operators • aggregate functions and support was taking up large amounts of time that should have been 2. http://www.informix.com/ 3. http://www.ibm.com/ 4. http://meteora.ucsd.edu/s2k/s2k_home.html lxiii Preface devoted to database PostgreSQL web site for details. 5. http://wiki.postgresql.org 6. http://wiki.postgresql.org/wiki/Frequently_Asked_Questions 7. http://wiki.postgresql.org/wiki/Todo 8. http://www.postgresql.org lxv Preface