★第1章、安装postgresql # yum install postgresql-server -y # EL8安装光盘AppSteam里自带有10.x 版本的软件包 # postgresql-setup --initdb --unit postgresql # systemctl enable postgresql # systemctl systemctl enable postgresql-13 # systemctl start postgresql-13 ★第2章、设置数据存储路径 PostgreSQL 初始化数据库之后， 10版本的默认的数据目录是/var/lib/pgsql/ 13版本的默认的数据目录是/var/lib/pgsql/13/ 现在想修改为/data_pg/ 目录 ★PG-13版本 # systemctl data_directory = '/data_pg/data/' # mv /var/lib/pgsql/13/* /data_pg/ #将原数据目录下所有内容移动到新 数据目录下 # vi /usr/lib/systemd/system/postgresql-13.service #pg-13版本，修改systemd服 务文件，指定数据目录 #修

Querying a Table ........................................................................................ 10 2.6. Joins Between Tables ........................................................................ Statistics Information Functions .................................................................. 423 10. Type Conversion ................................................................................. ...................................................................... 2583 73.1. Backup Manifest Top-level Object ............................................................ 2583 73.2. Backup Manifest

Statistics Information Functions ............................................................ 401 10. Type Conversion ................................................................................. ...................................................................... 2445 73.1. Backup Manifest Top-level Object ....................................................... 2445 73.2. Backup Manifest File Release 14.2 ..................................................................................... 2554 E.10. Release 14.1 ....................................................................................

Querying a Table ........................................................................................ 10 2.6. Joins Between Tables ........................................................................ Statistics Information Functions .................................................................. 458 10. Type Conversion ................................................................................. ...................................................................... 2756 69.1. Backup Manifest Top-level Object ............................................................ 2756 69.2. Backup Manifest

Statistics Information Functions ............................................................ 432 10. Type Conversion ................................................................................. ...................................................................... 2604 69.1. Backup Manifest Top-level Object ....................................................... 2604 69.2. Backup Manifest File 9. citext — a case-insensitive character string type ...................................... 2714 F.10. cube — a multi-dimensional cube data type .......................................... 2717 F.11. dblink

Querying a Table ........................................................................................ 10 2.6. Joins Between Tables ........................................................................ Statistics Information Functions .................................................................. 438 10. Type Conversion ................................................................................. ...................................................................... 2685 77.1. Backup Manifest Top-level Object ............................................................ 2685 77.2. Backup Manifest

Querying a Table ........................................................................................ 10 2.6. Joins Between Tables ........................................................................ Statistics Information Functions .................................................................. 409 10. Type Conversion ................................................................................. ...................................................................... 2484 72.1. Backup Manifest Top-level Object ............................................................ 2484 72.2. Backup Manifest

Statistics Information Functions ............................................................ 414 10. Type Conversion ................................................................................. ...................................................................... 2546 77.1. Backup Manifest Top-level Object ....................................................... 2546 77.2. Backup Manifest File 2669 F.9. btree_gist — GiST operator classes with B-tree behavior ........................... 2670 F.10. citext — a case-insensitive character string type ..................................... 2672 F.11

Statistics Information Functions ............................................................ 387 10. Type Conversion ................................................................................. ...................................................................... 2348 72.1. Backup Manifest Top-level Object ....................................................... 2348 72.2. Backup Manifest File Release 13.5 ..................................................................................... 2454 E.10. Release 13.4 ....................................................................................

...................................................................................................10 2.7. Aggregate Functions.......................................................................... Handling a Table Rewrite Event .....................................................................356 10. Type Conversion.................................................................................. ...........................................................................................2358 E.10. Release 9.5.16 ..................................................................................