RDBMS/PostgreSQL 썸네일형 리스트형 Replication Replication ( streming Replication ) 1. Master ( Primary ) 서버 구성$ psql –U postgres -p 5432postgres=# CREATE ROLE replication REPLICATION LOGIN PASSWORD 'password'; # 동기화 계정 생성$ vi /raid/usr/local/pgsql/data/data/postgresql.conf# Replication 관련 parameter 수정---------------------------------------------------------------------------------------------#------------------------------------------------.. 더보기 설치 PostgreSQL Source setup ( CentOS 6.5 / PostgreSQL 9.5.5 ) 1. PostgreSQL 설치파일 다운# wget https://ftp.postgresql.org/pub/source/v9.5.5/postgresql-9.5.5.tar.gz 2. PostgreSQL 설치# tar xvzf postgresql-9.5.5.tar.gz# cd postgresql-9.5.5# ./configure --prefix=/raid/usr/local/pgsql --bindir=/raid/usr/local/pgsql/bin --datadir=/raid/usr/local/pgsql/data --enable-depend --enable-nls=ko --with-openssl** --pref.. 더보기 이전 1 다음