|
| 1 | +# ------------------------------- |
| 2 | +# PostgreSQL recovery config file |
| 3 | +# ------------------------------- |
| 4 | +# |
| 5 | +# Edit this file to provide the parameters that PostgreSQL |
| 6 | +# needs to perform an archive recovery of a database |
| 7 | +# |
| 8 | +# If "recovery.conf" is present in the PostgreSQL data directory, it is |
| 9 | +# read on postmaster startup. After successful recovery, it is renamed |
| 10 | +# to "recovery.done" to ensure that we do not accidentally re-enter archive |
| 11 | +# recovery mode. |
| 12 | +# |
| 13 | +# This file consists of lines of the form: |
| 14 | +# |
| 15 | +# name = 'value' |
| 16 | +# |
| 17 | +# (The quotes around the value are NOT optional, but the "=" is.) |
| 18 | +# |
| 19 | +# Comments are introduced with '#'. |
| 20 | +# |
| 21 | +# The complete list of option names and |
| 22 | +# allowed values can be found in the PostgreSQL documentation. The |
| 23 | +# commented-out settings shown below are sample values. |
| 24 | +# |
| 25 | +#--------------------------------------------------------------------------- |
| 26 | +# REQUIRED PARAMETERS |
| 27 | +#--------------------------------------------------------------------------- |
| 28 | +# |
| 29 | +# restore command |
| 30 | +# |
| 31 | +# specifies the shell command that is executed to copy log files |
| 32 | +# back from archival storage. The command string may contain %f, |
| 33 | +# which is replaced by the name of the desired log file, and %p, |
| 34 | +# which is replaced by the absolute path to copy the log file to. |
| 35 | +# |
| 36 | +# It is important that the command return nonzero exit status on failure. |
| 37 | +# The command *will* be asked for log files that are not present in the |
| 38 | +# archive; it must return nonzero when so asked. |
| 39 | +# |
| 40 | +# NOTE that the basename of %p will be different from %f; do not |
| 41 | +# expect them to be interchangeable. |
| 42 | +# |
| 43 | +# |
| 44 | +#restore_command = 'cp /mnt/server/archivedir/%f %p' |
| 45 | +# |
| 46 | +# |
| 47 | +#--------------------------------------------------------------------------- |
| 48 | +# OPTIONAL PARAMETERS |
| 49 | +#--------------------------------------------------------------------------- |
| 50 | +# |
| 51 | +# By default, recovery will rollforward to the end of the WAL log. |
| 52 | +# If you want to stop rollforward before that point, you |
| 53 | +# MUST set a recovery target. |
| 54 | +# |
| 55 | +# You may set a recovery target either by transactionId, or |
| 56 | +# by timestamp. Recovery may either include or exclude the |
| 57 | +# records with the recovery target value (ie, stop either just |
| 58 | +# after or just before the given target). |
| 59 | +# |
| 60 | +#recovery_target_time = '2004-07-14 22:39:00' |
| 61 | +# |
| 62 | +# note: target time is interpreted by strptime() and must therefore be |
| 63 | +# given in your system's default timezone. |
| 64 | +# |
| 65 | +#recovery_target_xid = '11000' |
| 66 | +# |
| 67 | +# true or false |
| 68 | +#recovery_target_inclusive = 'true' |
| 69 | +# |
| 70 | +#--------------------------------------------------------------------------- |