阿里云 AnalyticDB for PostgreSQL - 打造更简单易用的Cloud SQL Data Warehouse 个人介绍 缪长风 ⚫ 2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 ⚫ 有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 RDS 关系型数据 库D ECS自建 自建大数据计算平台 Hadoop Spark EMR Dataphi n OSS海量云存储 Data Lake Store DTS 实时同步 Dump Data Dump Data 数据集成 按需回流 数据仓库应用 在线数据仓库 数据 查询 数据集成 批量同步 1 3 4 2 云化在线数仓 ： 简化、敏捷、一栈式构筑数据仓库

Expression Evaluation Rules .....................................................................37 5. Data Definition....................................................................................... Default Value............................................................52 5.6.6. Changing a Column’s Data Type .................................................................52 5.6.7. Renaming a Column ................58 6. Data Manipulation.................................................................................................................60 6.1. Inserting Data .......................

Evaluation Rules ............................................................................38 5. Data Definition....................................................................................... Value...................................................................55 5.6.6. Changing a Column’s Data Type ........................................................................55 5.6.7. Renaming a .........61 iv 6. Data Manipulation........................................................................................................................63 6.1. Inserting Data ...................

Evaluation Rules ............................................................................39 5. Data Definition....................................................................................... Value...................................................................52 5.5.6. Changing a Column’s Data Type ........................................................................53 5.5.7. Renaming a .............68 6. Data Manipulation........................................................................................................................70 6.1. Inserting Data ...................

Evaluation Rules ............................................................................39 5. Data Definition....................................................................................... Value...................................................................52 5.5.6. Changing a Column’s Data Type ........................................................................53 5.5.7. Renaming a .............68 6. Data Manipulation........................................................................................................................70 6.1. Inserting Data ...................

Evaluation Rules ............................................................................40 5. Data Definition....................................................................................... Value...................................................................54 5.5.6. Changing a Column’s Data Type ........................................................................54 5.5.7. Renaming a .............70 6. Data Manipulation........................................................................................................................72 6.1. Inserting Data ...................

Evaluation Rules ............................................................................40 5. Data Definition....................................................................................... Value...................................................................54 5.5.6. Changing a Column’s Data Type ........................................................................54 5.5.7. Renaming a .............70 6. Data Manipulation........................................................................................................................72 6.1. Inserting Data ...................

Functions ........................................................................................ 54 5. Data Definition ...................................................................................... ................................................................................ 86 5.11. Foreign Data ............................................................................................ 98 5 ........................ 99 6. Data Manipulation ............................................................................................... 101 6.1. Inserting Data ...............................

Functions .................................................................................. 51 5. Data Definition ...................................................................................... ................................................................................ 81 5.11. Foreign Data ....................................................................................... 93 5.12. Other PostgreSQL 10.23 Documentation 6. Data Manipulation ............................................................................................ 96 6.1. Inserting Data .................................

sql/13/ 现在想修改为/data_pg/ 目录 ★PG-13版本 # systemctl stop postgresql-13 #先停止服务 # mkdir /data_pg # chown postgres:postgres /data_pg # vi /var/lib/pgsql/13/data/postgresql.conf #pg-13版本，添加或修改以下配 置 data_directory = '/data_pg/data/' # mv /var/lib/pgsql/13/* /data_pg/ #将原数据目录下所有内容移动到新 数据目录下 # vi /usr/lib/systemd/system/postgresql-13.service #pg-13版本，修改systemd服 #pg-13版本，修改systemd服 务文件，指定数据目录 #修改这行：Environment=PGDATA=/var/lib/pgsql/13/data/ 改为新的路径，如 下： Environment=PGDATA=/data_pg/data/ # systemctl daemon-reload # systemctl restart postgresql-13 ★PG-10版本