1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
5
>Backup and Restore</TITLE
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
15
TITLE="Server Administration"
16
HREF="admin.html"><LINK
18
TITLE="Log File Maintenance"
19
HREF="logfile-maintenance.html"><LINK
22
HREF="backup-dump.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
56
TITLE="Log File Maintenance"
57
HREF="logfile-maintenance.html"
66
TITLE="Routine Database Maintenance Tasks"
67
HREF="maintenance.html"
80
TITLE="High Availability, Load Balancing, and Replication"
81
HREF="high-availability.html"
90
HREF="backup-dump.html"
105
>Chapter 24. Backup and Restore</H1
111
>Table of Contents</B
115
HREF="backup-dump.html"
125
HREF="backup-dump.html#BACKUP-DUMP-RESTORE"
126
>Restoring the Dump</A
130
HREF="backup-dump.html#BACKUP-DUMP-ALL"
138
HREF="backup-dump.html#BACKUP-DUMP-LARGE"
139
>Handling Large Databases</A
145
HREF="backup-file.html"
146
>File System Level Backup</A
150
HREF="continuous-archiving.html"
151
>Continuous Archiving and Point-in-Time Recovery (PITR)</A
157
HREF="continuous-archiving.html#BACKUP-ARCHIVING-WAL"
158
>Setting Up WAL Archiving</A
162
HREF="continuous-archiving.html#BACKUP-BASE-BACKUP"
163
>Making a Base Backup</A
167
HREF="continuous-archiving.html#BACKUP-PITR-RECOVERY"
168
>Recovering Using a Continuous Archive Backup</A
172
HREF="continuous-archiving.html#BACKUP-TIMELINES"
177
HREF="continuous-archiving.html#BACKUP-TIPS"
178
>Tips and Examples</A
182
HREF="continuous-archiving.html#CONTINUOUS-ARCHIVING-CAVEATS"
190
> As with everything that contains valuable data, <SPAN
194
databases should be backed up regularly. While the procedure is
195
essentially simple, it is important to have a clear understanding of
196
the underlying techniques and assumptions.
199
> There are three fundamentally different approaches to backing up
216
>File system level backup</P
220
>Continuous archiving</P
224
Each has its own strengths and weaknesses; each is discussed in turn
225
in the following sections.
233
SUMMARY="Footer navigation table"
244
HREF="logfile-maintenance.html"
262
HREF="backup-dump.html"
272
>Log File Maintenance</TD
b'\\ No newline at end of file'