PITR base backup -- stop server or not?

From: Rob Adams <robfadams(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: PITR base backup -- stop server or not?
Date: 2008-06-19 06:14:05
Message-ID: 4859F92D.5080002@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Artacus 2008-06-19 06:19:27 Re: Problem with volatile function
Previous Message Giorgio Valoti 2008-06-19 05:56:22 Re: UTF8 encoding problem