PITR base backup -- stop server or not? - Mailing list pgsql-general

From Rob Adams
Subject PITR base backup -- stop server or not?
Date
Msg-id 4859F92D.5080002@cox.net
Whole thread Raw
Responses Re: PITR base backup -- stop server or not?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
The docs for Making a Base Backup (tar) say that it can be done live
without stopping the server:
http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP
(step #3)

However, the docs for straight File System Level Backup (tar) say the
server must be shut down:
http://www.postgresql.org/docs/8.3/interactive/backup-file.html
(restriction #1)

Is this because replaying the WAL files will fix any of the issues
listed in the File System Level Backup restriction #1?


Thanks,
Rob Adams



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with volatile function
Next
From: Artacus
Date:
Subject: Re: Problem with volatile function