Skip site navigation (1) Skip section navigation (2)

Re: Base Backups from PITR Standby

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 (view raw or flat)
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


In response to

Responses

pgsql-general by date

Next:From: Oleg BartunovDate: 2007-10-30 20:54:47
Subject: Re: Fragments in tsearch2 headline
Previous:From: Decibel!Date: 2007-10-30 18:58:29
Subject: Updated .vim file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group