1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
[wal-master]
job_name = servername_walmgr_master
logfile = /var/lib/postgresql/log/wal-master.log
pidfile = /var/lib/postgresql/pid/wal-master.pid
use_skylog = 1
master_db = dbname=template1
master_data = /var/lib/postgresql/8.3/main
master_config = /etc/postgresql/8.3/main/postgresql.conf
# set this only if you can afford database restarts during setup and stop.
#master_restart_cmd = /etc/init.d/postgresql-8.3 restart
slave_config = /var/lib/postgresql/conf/wal-slave.ini
slave = slave:/var/lib/postgresql/walshipping
completed_wals = %(slave)s/logs.complete
partial_wals = %(slave)s/logs.partial
full_backup = %(slave)s/data.master
config_backup = %(slave)s/config.backup
# syncdaemon update frequency
loop_delay = 10.0
# use record based shipping available since 8.2
use_xlog_functions = 0
# pass -z to rsync, useful on low bandwidth links
compression = 0
# keep symlinks for pg_xlog and pg_log
keep_symlinks = 1
# tell walmgr to set wal_level to hot_standby during setup
#hot_standby = 1
# periodic sync
#command_interval = 600
#periodic_command = /var/lib/postgresql/walshipping/periodic.sh
|
