| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Rob Adams" <robfadams(at)cox(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PITR base backup -- stop server or not? |
| Date: | 2008-06-19 07:01:28 |
| Message-ID: | dcc563d10806190001h5d70d476t927732340fc6ee08@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jun 19, 2008 at 12:14 AM, Rob Adams <robfadams(at)cox(dot)net> wrote:
> 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?
Yes
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Arnošt | 2008-06-19 07:03:12 | Re: problem with to_ascii() function in version 8.3.3 |
| Previous Message | Craig Ringer | 2008-06-19 06:43:04 | Re: Problem with volatile function |