Guest User

Untitled

a guest
Sep 20th, 2018
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. max_wal_senders = 1
  2. wal_keep_segments = 8
  3.  
  4. standby_mode = 'on'
  5. primary_conninfo = 'host=master1 port=5432 user=replication password=replication'
  6. trigger_file = '/tmp/postgresql.trigger.5432'
  7.  
  8. < 2015-01-23 23:59:47.241 EST >LOG: started streaming WAL from primary at F/52000000 on timeline 1
  9. < 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
  10.  
  11. < 2015-01-23 23:59:52.259 EST >LOG: started streaming WAL from primary at F/52000000 on timeline 1
  12. < 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
  13.  
  14. < 2015-01-23 23:59:57.270 EST >LOG: started streaming WAL from primary at F/52000000 on timeline 1
  15. < 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
  16.  
  17. # on master
  18. archive_mode = on
  19. archive_command = 'cp %p /path_to/archive/%f'
  20.  
  21. # on slave
  22. restore_command = 'cp /path_to/archive/%f "%p"'
  23.  
  24. psql -c "select pg_start_backup('initial_backup');"
  25. rsync -cva --inplace --exclude=*pg_xlog* <data_dir> slave_IP_address:<data_dir>
  26. psql -c "select pg_stop_backup();"
Add Comment
Please, Sign In to add comment