|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/backup.sgml,v 2.154 2010/04/29 21:49:03 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/backup.sgml,v 2.155 2010/05/03 09:14:16 heikki Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="backup"> |
4 | 4 | <title>Backup and Restore</title> |
@@ -550,8 +550,9 @@ tar -cf backup.tar /usr/local/pgsql/data |
550 | 550 | </para> |
551 | 551 |
|
552 | 552 | <para> |
553 | | - To enable WAL archiving, set the <xref |
554 | | - linkend="guc-archive-mode"> configuration parameter to <literal>on</>, |
| 553 | + To enable WAL archiving, set the <xref linkend="guc-wal-level"> |
| 554 | + configuration parameter to <literal>archive</> (or <literal>hot_standby</>), |
| 555 | + <xref linkend="guc-archive-mode"> to <literal>on</>, |
555 | 556 | and specify the shell command to use in the <xref |
556 | 557 | linkend="guc-archive-command"> configuration parameter. In practice |
557 | 558 | these settings will always be placed in the |
@@ -694,7 +695,7 @@ archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/ser |
694 | 695 | linkend="populate-pitr">. If archiving or streaming replication were |
695 | 696 | turned on during execution of one of these statements, WAL would not |
696 | 697 | contain enough information for archive recovery. (Crash recovery is |
697 | | - unaffected.) For this reason,these parameters can only be changed at |
| 698 | + unaffected.) For this reason,<varname>wal_level</> can only be changed at |
698 | 699 | server start. However, <varname>archive_command</> can be changed with a |
699 | 700 | configuration file reload. If you wish to temporarily stop archiving, |
700 | 701 | one way to do it is to set <varname>archive_command</> to the empty |
@@ -1180,7 +1181,8 @@ restore_command = 'cp /mnt/server/archivedir/%f %p' |
1180 | 1181 | </para> |
1181 | 1182 |
|
1182 | 1183 | <para> |
1183 | | - To prepare for standalone hot backups, set <varname>archive_mode</> to |
| 1184 | + To prepare for standalone hot backups, set <varname>wal_level</> to |
| 1185 | + <literal>archive</> (or <literal>hot_standby</>), <varname>archive_mode</> to |
1184 | 1186 | <literal>on</>, and set up an <varname>archive_command</> that performs |
1185 | 1187 | archiving only when a <emphasis>switch file</> exists. For example: |
1186 | 1188 | <programlisting> |
|