/****************************************************************************************************************
-- Title : [PGS9.2] Online hot backup using pg_basebackup
-- Key word : pg_basebackup basebackup online backup 온라인백업 핫백업 hot backup
****************************************************************************************************************/
-- Archive mode is default
wal_level = archive
archive_mode = on
archive_commane = 'cp %p /Databases/ARCHIVE/%f'
archive_timeout = 0
-- postgresql.conf
max_wal_senders = 1 -- 대기 서버 연결 최대 숫자
-- pg_hba.conf
#하단에 추가(자신의 IP 추가)
host replication postgres 192.0.0.10/0 md5
$ $PGSQL_HOME/bin/pg_basebackup -D 저장할경로 -v -Fp -h 마스터IP -p 마스터port -U 마스터user
-- 참조 : http://dbrang.tistory.com/830
ex)
./pg_basebackup -D /app/pgsql/backupdata/20140220.bak -v -Ft -h 192.168.182.139 -U postgres