postgresql操作手册
# EL8安装光盘AppSteam里自带有10.x 版本的软件包 # postgresql-setup --initdb --unit postgresql # systemctl enable postgresql # systemctl start postgresql 如果想安装其他版本,可到官网查询安装方法 h�ps://www.postgresql.o org/download/linux/redhat/ 本文档选择PG-13版本作为讲解,使用el8系列的系统,x86_64平台 # yum install -y h�ps://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat- repo-latest.noarch.rpm #或者直接创建repo文件,内容如下 postgresql-13 ★第2章、设置数据存储路径 PostgreSQL 初始化数据库之后, 10版本的默认的数据目录是/var/lib/pgsql/ 13版本的默认的数据目录是/var/lib/pgsql/13/ 现在想修改为/data_pg/ 目录 ★PG-13版本 # systemctl stop postgresql-13 #先停止服务0 码力 | 17 页 | 445.84 KB | 1 年前3PostgreSQL WAL日志解析与应用
• 逻辑复制 • 误操作恢复 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 Logminter • 利用多版本特性,尽可能恢复数据。 • 打开pg_log,查找误操作信息,进行还原。 • 利用pg_xlogdump查看wal日志信息,确定时 间点,然后恢复。 2016Postgres中国用户大会0 码力 | 16 页 | 705.31 KB | 1 年前3阿里云 AnalyticDB for PostgreSQL - 打造更简单易用的Cloud SQL Data Warehouse
务 5.检索分析 1.注册特征提取服务 3.写入url 4.生成特征 2.写入非 结构化数 OSS 音频 图片 文本 向量 ①GPU的计算性能加速 ②支持Greenplum 6.0版本 其他演进规划: 更快性能 敬请期待!0 码力 | 22 页 | 2.98 MB | 1 年前3PostgreSQL 9.3 Documentation
...............1157 43. PL/Python - Python Procedural Language.............................................................................1158 43.1. Python 2 vs. Python 3........................... .....................................................................1158 43.2. PL/Python Functions .................................................................................................1159 Context Managers ................................................................1171 43.8.2. Older Python Versions ..................................................................................11720 码力 | 3183 页 | 7.53 MB | 1 年前3PostgreSQL 9.3.25 Documentation
...................1089 43. PL/Python - Python Procedural Language......................................................................1090 43.1. Python 2 vs. Python 3.............................. ...........................................................1090 43.2. PL/Python Functions ..........................................................................................1091 43.3. Data Values Subtransaction Context Managers .........................................................1102 43.8.2. Older Python Versions ...........................................................................1103 43.9. Utility0 码力 | 3002 页 | 7.47 MB | 1 年前3PostgreSQL 9.1 Documentation
...............1080 42. PL/Python - Python Procedural Language.............................................................................1081 42.1. Python 2 vs. Python 3........................... .....................................................................1081 42.2. PL/Python Functions .................................................................................................1082 Context Managers ................................................................1092 42.8.2. Older Python Versions ..................................................................................10930 码力 | 2836 页 | 6.62 MB | 1 年前3PostgreSQL 9.1.24 Documentation
...................1019 42. PL/Python - Python Procedural Language......................................................................1020 42.1. Python 2 vs. Python 3.............................. ...........................................................1020 42.2. PL/Python Functions ..........................................................................................1021 42.3. Data Values Subtransaction Context Managers .........................................................1031 42.8.2. Older Python Versions ...........................................................................1031 42.9. Utility0 码力 | 2667 页 | 6.57 MB | 1 年前3PostgreSQL 9.2 Documentation
...............1122 42. PL/Python - Python Procedural Language.............................................................................1123 42.1. Python 2 vs. Python 3........................... .....................................................................1123 42.2. PL/Python Functions .................................................................................................1124 Context Managers ................................................................1136 42.8.2. Older Python Versions ..................................................................................11370 码力 | 3007 页 | 7.07 MB | 1 年前3PostgreSQL 9.2 Documentation
...................1055 42. PL/Python - Python Procedural Language......................................................................1056 42.1. Python 2 vs. Python 3.............................. ...........................................................1056 42.2. PL/Python Functions ..........................................................................................1057 42.3. Data Values Subtransaction Context Managers .........................................................1068 42.8.2. Older Python Versions ...........................................................................1069 42.9. Utility0 码力 | 2829 页 | 7.02 MB | 1 年前3PostgreSQL 9.0 Documentation
................966 42. PL/Python - Python Procedural Language...............................................................................967 42.1. Python 2 vs. Python 3.......................... ........................................................................967 42.2. PL/Python Functions .................................................................................................. 7.2. PL/Perl Server-Side Language ............................................1869 E.23.3.7.3. PL/Python Server-Side Language .......................................1870 E.23.3.8. Client Applications0 码力 | 2561 页 | 5.55 MB | 1 年前3
共 44 条
- 1
- 2
- 3
- 4
- 5