PostgreSQL에서 Extension 설정 (pglogical 추가)

Extention설정

pglogical 설치

Source File Download 후 pg config 파일 있는곳에 압축 해제

https://github.com/2ndQuadrant/pglogical 

> unzip pglogical-REL2_x_STABLE.zip 
> cd pglogical-REL2_x_STABLE
> make 
> make install 

postgresql.conf 파라미터 변경 (재기동 필수)

shared_preload_libraries = 'pglogical'

PostgreSQL 재기동

-- restart 
/pg/postgresql/bin/pg_ctl -D /pg/data -l logfile restart

설정 및 확인

\c test <-- 설치할 Database 접근. 
postgres=# create extension pglogical;
CREATE EXTENSION
postgres=# select * from pg_extension;
  extname  | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition 
-----------+----------+--------------+----------------+------------+-----------+--------------
 plpgsql   |       10 |           11 | f              | 1.0        |           | 
 pglogical |       10 |        16417 | f              | 2.4.4      |           | 
(2 rows)