Skip to content

Instantly share code, notes, and snippets.

@geo-stanciu
Created March 6, 2018 10:42
Show Gist options
  • Select an option

  • Save geo-stanciu/eef1150d152cd871d6154d5f59e659ce to your computer and use it in GitHub Desktop.

Select an option

Save geo-stanciu/eef1150d152cd871d6154d5f59e659ce to your computer and use it in GitHub Desktop.
postgres recovery.conf
standby_mode = 'on'
primary_conninfo = 'user=postgres passfile=''C:\\\\Users\\\\geo\\\\AppData\\\\Roaming/postgresql/pgpass.conf'' host=localhost port=5432 sslmode=prefer sslcompression=1 krbsrvname=postgres target_session_attrs=any'
recovery_target_time='2018-02-23 22:25:00+02:00'
restore_command = 'copy "D:\\backup\\archive\\%f" "%p"'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment