# 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 #先停止服务

• 逻辑复制 • 误操作恢复 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会  Logminter • 利用多版本特性，尽可能恢复数据。 • 打开pg_log，查找误操作信息，进行还原。 • 利用pg_xlogdump查看wal日志信息，确定时 间点，然后恢复。 2016Postgres中国用户大会

务 5.检索分析 1.注册特征提取服务 3.写入url 4.生成特征 2.写入非 结构化数 OSS 音频 图片 文本 向量 ①GPU的计算性能加速 ②支持Greenplum 6.0版本 其他演进规划： 更快性能 敬请期待！

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce contain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 207 Chapter 9. Functions and Operators 9 subdirectories in the list below. OpenJade 1.3.1-2 Download from http://sourceforge.net/project/downloading.php?groupname=openjade&filename=openjade- 1_3_1-2-bin.zip and uncompress in the subdirectory openjade-1

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce con- tain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text|no subdirectories in the list below. OpenJade 1.3.1-2 Download from http://sourceforge.net/project/downloading.php?groupname=openjade&filename=openjade- 1_3_1-2-bin.zip and uncompress in the subdirectory openjade-1

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce con- tain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text interesting references such as \set :foo ’something’ and get “soft links” or “variable variables” of Perl or PHP fame, respectively. Unfortunately (or fortunately?), there is no way to do anything useful with these

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce contain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text interesting references such as \set :foo ’something’ and get “soft links” or “variable variables” of Perl or PHP fame, respectively. Unfortunately (or fortunately?), there is no way to do anything useful with these

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce contain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text interesting references such as \set :foo ’something’ and get “soft links” or “variable variables” of Perl or PHP fame, respectively. Unfortunately (or fortunately?), there is no way to do anything useful with these

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce Example: 248 Chapter 9. Functions and Operators SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text interesting references such as \set :foo ’something’ and get “soft links” or “variable variables” of Perl or PHP fame, respectively. Unfortunately (or fortunately?), there is no way to do anything useful with these

reproducible, we will find it either way. If your application uses some other client interface, such as PHP, then please try to isolate the offending queries. We will probably not set up a web server to reproduce con- tain the character sequence ?>. Example: SELECT xmlpi(name php, ’echo "hello world";’); xmlpi ----------------------------- php echo "hello world";?> 9.14.1.6. xmlroot xmlroot(xml, version text interesting references such as \set :foo ’something’ and get “soft links” or “variable variables” of Perl or PHP fame, respectively. Unfortunately (or fortunately?), there is no way to do anything useful with these