|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/backup.sgml,v 2.83 2006/08/17 23:04:02 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/backup.sgml,v 2.84 2006/09/15 21:55:07 momjian Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="backup"> |
4 | 4 | <title>Backup and Restore</title> |
@@ -855,7 +855,9 @@ SELECT pg_stop_backup(); |
855 | 855 | <listitem> |
856 | 856 | <para> |
857 | 857 | Start the server. The server will go into recovery mode and |
858 | | - proceed to read through the archived WAL files it needs. Upon completion |
| 858 | + proceed to read through the archived WAL files it needs. Should the |
| 859 | + recovery be terminated because of an external error, the server can |
| 860 | + simply be restarted and it will continue recovery. Upon completion |
859 | 861 | of the recovery process, the server will rename |
860 | 862 | <filename>recovery.conf</> to <filename>recovery.done</> (to prevent |
861 | 863 | accidentally re-entering recovery mode in case of a crash later) and then |
@@ -935,7 +937,21 @@ restore_command = 'cp /mnt/server/archivedir/%f %p' |
935 | 937 | recover to such a time, you must go back to your previous base backup |
936 | 938 | and roll forward from there.) |
937 | 939 | </para> |
938 | | - </note> |
| 940 | + </note> |
| 941 | + |
| 942 | + <para> |
| 943 | + If recovery finds a corruption in the WAL data then recovery will |
| 944 | + complete at that point and the server will not start. The recovery |
| 945 | + process could be re-run from the beginning, specifying a |
| 946 | + <quote>recovery target</> so that recovery can complete normally. |
| 947 | + If recovery fails for an external reason, such as a system crash or |
| 948 | + the WAL archive has become inaccessible, then the recovery can be |
| 949 | + simply restarted and it will restart almost from where it failed. |
| 950 | + Restartable recovery works by writing a restartpoint record to the control |
| 951 | + file at the first safely usable checkpoint record found after |
| 952 | + <varname>checkpoint_timeout</> seconds. |
| 953 | + </para> |
| 954 | + |
939 | 955 |
|
940 | 956 | <sect3 id="recovery-config-settings" xreflabel="Recovery Settings"> |
941 | 957 | <title>Recovery Settings</title> |
|