| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Brian Wipf <brian(at)clickspace(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Base Backups from PITR Standby |
| Date: | 2007-10-30 20:42:37 |
| Message-ID: | 1193776957.4229.10.camel@ebony.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2007-10-30 at 08:25 -0600, Brian Wipf wrote:
> I'm trying to take a base backup from the standby server in archive
> recovery mode. I don't believe it's possible to connect to it to issue
> pg_start_backup/pg_stop_backup.
>
> http://www.postgresql.org/docs/current/interactive/warm-standby.html#BACKUP-INCREMENTAL-UPDATED
It's safest to shutdown the standby first, take a backup then crank it
up again.
It's possible to do it online in the way you suggest, but only when
running with either full_page_writes = on or when making the backup with
rsync, or another method that uses atomic 8Kb reads. The backup is only
valid if you rollforward past the next restartpoint after the backup
completes, which is not technically the right place but definitely far
enough. So its not exactly for the feint-hearted, at the moment.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2007-10-30 20:54:47 | Re: Fragments in tsearch2 headline |
| Previous Message | Decibel! | 2007-10-30 18:58:29 | Updated .vim file |