# **Postgre SQL****开启****decocderbufs** #### 安装前的准备工作 ##### 关闭SELinux ``` [root@localhost ~]# setenforce 0 //临时关闭 [root@localhost ~]# getenforce Enforcing [root@localhost ~]# sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/sysconfig/selinux //永久关闭 [root@localhost ~]# cat /etc/sysconfig/selinux # This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: # enforcing - SELinux security policy is enforced. # permissive - SELinux prints warnings instead of enforcing. # disabled - No SELinux policy is loaded. SELINUX=disabled # SELINUXTYPE= can take one of three two values: # targeted - Targeted processes are protected, # minimum - Modification of targeted policy. Only selected processes are protected. # mls - Multi Level Security protection. SELINUXTYPE=targeted ``` ##### 关闭防火墙 ``` [root@localhost ~]# systemctl stop firewalld.service [root@localhost ~]# systemctl disable firewalld.service [root@localhost ~]# firewall-cmd --state not running ``` ##### 升级GCC/G++ ###### 强烈推荐使用devtoolset方式,传统编译方式安装极为耗时且成功率极低. ``` [root@localhost ~]# sudo yum install devtoolset-4-gcc devtoolset-4-gcc++ devtoolset-4-gcc-c++ -y [root@localhost ~]# scl enable devtoolset-4 bash [root@localhost ~]# echo "source /opt/rh/devtoolset-4/enable" >> /etc/profile [root@localhost ~]# source /etc/profile ``` ##### 安装依赖环境 ``` [root@localhost ~]# yum install autoconf automake libtool readline-devel zlib-devel libxslt-devel json-c-devel pcre-devel unzip -y ``` ##### 下载并编译安装一下依赖环境 ``` http://download.osgeo.org/geos/geos-3.6.2.tar.bz2 http://download.osgeo.org/proj/proj-4.9.3.tar.gz http://download.osgeo.org/gdal/2.2.3/gdal-2.2.3.tar.gz https://download.osgeo.org/postgis/source/postgis-2.3.7.tar.gz *.以上四个安装包编译时不需要指定 --prefix= ``` ##### 升级autoconf(版本>=2.6.4) ``` [root@localhost ~]# wget ftp://ftp.gnu.org/gnu/autoconf/autoconf-2.69.tar.gz [root@localhost ~]# tar zxvf autoconf-2.69.tar.gz [root@localhost ~]# cd autoconf-2.69 [root@localhost ~]# ./configure --prefix=/usr/ [root@localhost ~]# make && make install [root@localhost ~]# /usr/bin/autoconf -V autoconf (GNU Autoconf) 2.69 Copyright (C) 2012 Free Software Foundation, Inc. License GPLv3+/Autoconf: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>, <http://gnu.org/licenses/exceptions.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. ``` ##### 在PG中扩展Postgis ``` postgres=# CREATE EXTENSION postgis; postgres=# CREATE EXTENSION postgis_topology; postgres=# CREATE EXTENSION fuzzystrmatch; postgres=# CREATE EXTENSION postgis_tiger_geocoder; ``` ##### 验证Postgis安装 ``` postgres=# \dx List of installed extensions Name | Version | Schema | Description ------------------------+---------+------------+--------------------------------------------------------------------- fuzzystrmatch | 1.1 | public | determine similarities and distance between strings plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language postgis | 2.3.7 | public | PostGIS geometry, geography, and raster spatial types and functions postgis_tiger_geocoder | 2.3.7 | tiger | PostGIS tiger geocoder and reverse geocoder postgis_topology | 2.3.7 | topology | PostGIS topology spatial types and functions (5 rows) postgres=# \q ``` ##### 安装ProtoBuf 3.3.0 ``` [root@localhost ~]# wget https://github.com/google/protobuf/archive/v3.3.0.tar.gz [root@localhost ~]# ./autogen.sh./configure --prefix=/usr/local/protobuf --libdir=/usr/lib64 [root@localhost ~]# make & make [root@localhost ~]# install ldconfig [root@localhost ~]# echo "export PATH=$PATH:/usr/local/protobuf/bin" >> /etc/profile ``` ##### 安装ProtoBuf-C 1.2.1 ``` [root@localhost ~]# wget https://github.com/protobuf-c/protobuf-c/archive/v1.2.1.tar.gz [root@localhost ~]# ./autogen.sh./configure --prefix=/usr/local/protobuf-c --libdir=/usr/lib64/ [root@localhost ~]# make & make install ``` ##### 安装postgresql-decoderbufs ``` [postgres@localhost ~]$ wget https://github.com/debezium/postgres-decoderbufs/archive/v0.7.5.tar.gz [postgres@localhost ~]$ tar xzvf v0.7.5.tar.gzsudo make USE_PGXS=1 [postgres@localhost ~]$ PG_CONFIG=/usr/local/pgsql/bin/pg_configsudo make install USE_PGXS=1 [postgres@localhost ~]$ PG_CONFIG=/usr/local/pgsql/bin/pg_config [postgres@localhost ~]$ cat /usr/local/pgsql/data/postgresql.conf listen_addresses = '*' shared_preload_libraries = 'decoderbufs' wal_level = logical max_wal_senders = 10 wal_keep_segments = 4 max_replication_slots = 4 ``` ##### 重启PG数据库 ``` [postgres@localhost ~]$ pg_ctl stop -D /usr/local/pgsql/data [postgres@localhost ~]$ pg_ctl start -D /usr/local/pgsql/data ``` ##### 验证,创建有以下结果无报错则成功 ``` postgres=# select * from pg_create_logical_replication_slot('decoderbufs_demo', 'decoderbufs'); LOG: logical decoding found consistent point at 0/23205E0 DETAIL: There are no running transactions. STATEMENT: select * from pg_create_logical_replication_slot('decoderbufs_demo', 'decoderbufs'); INFO: Exiting startup callback slot_name | xlog_position ------------------+--------------- decoderbufs_demo | 0/2320618 (1 row) ```