Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- max_wal_senders = 1
- wal_keep_segments = 8
- standby_mode = 'on'
- primary_conninfo = 'host=master1 port=5432 user=replication password=replication'
- trigger_file = '/tmp/postgresql.trigger.5432'
- < 2015-01-23 23:59:47.241 EST >LOG: started streaming WAL from primary at F/52000000 on timeline 1
- < 2015-01-23 23:59:47.241 EST >FATAL: could not receive data from WAL stream: ERROR: requested WAL segment 000000010000000F00000052 has already been removed
- < 2015-01-23 23:59:52.259 EST >LOG: started streaming WAL from primary at F/52000000 on timeline 1
- < 2015-01-23 23:59:52.260 EST >FATAL: could not receive data from WAL stream: ERROR: requested WAL segment 000000010000000F00000052 has already been removed
- < 2015-01-23 23:59:57.270 EST >LOG: started streaming WAL from primary at F/52000000 on timeline 1
- < 2015-01-23 23:59:57.270 EST >FATAL: could not receive data from WAL stream: ERROR: requested WAL segment 000000010000000F00000052 has already been removed
- # on master
- archive_mode = on
- archive_command = 'cp %p /path_to/archive/%f'
- # on slave
- restore_command = 'cp /path_to/archive/%f "%p"'
- psql -c "select pg_start_backup('initial_backup');"
- rsync -cva --inplace --exclude=*pg_xlog* <data_dir> slave_IP_address:<data_dir>
- psql -c "select pg_stop_backup();"
Add Comment
Please, Sign In to add comment