Guest User

Untitled

a guest
Feb 25th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. 2018-02-25 17:00:08 UTC FATAL: highest timeline 3 of the primary is behind recovery timeline 4
  2. 2018-02-25 17:00:13 UTC FATAL: highest timeline 3 of the primary is behind recovery timeline 4
  3. 2018-02-25 17:00:18 UTC FATAL: highest timeline 3 of the primary is behind recovery timeline 4
  4.  
  5. pg_basebackup --verbose --progress -d "host=10.132.x.x user=backup password=...." -D /var/lib/postgresql/9.4/main/ -l 'instance restore' --xlog-method=stream
  6.  
  7. restore_command = 'if [ -f /srv/postgresql/archive/${DATASET}/%f ]; then cp /srv/postgresql/archive/${DATASET}/%f %p; else aws s3 cp --quiet s3://company-backups/postgresql/${DATASET}/archive/%f %p; fi'
  8. standby_mode = 'on'
  9. primary_conninfo = 'host=10.132.x.x user=backup password=....'
  10. recovery_target_timeline = 'latest'
  11. trigger_file = '/var/lib/postgresql/9.4/main/failover'
Add Comment
Please, Sign In to add comment