From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org
To: sgm <sgm277@yahoo.com.cn>
Subject: Re: Question about PITR backup
Date: Fri, 08 Jun 2012 13:20:11 -0500
Message-ID: <4FD1FC0B020000250004821F@gw.wicourts.gov> (raw)
In-Reply-To: <1339152214.5566.YahooMailClassic@web15601.mail.cnb.yahoo.com>
References: <1339152214.5566.YahooMailClassic@web15601.mail.cnb.yahoo.com>
sgm <sgm277@yahoo.com.cn> wrote:
> I have a question about PITR backup in a single server, the method
> is make a base backup, and backup the WAL archive log(eg, every
> day at 11:30 pm). But if the OS' harddisk is broken(eg,14:00
> pm),the system can't start, we have to recover the database on a
> another server using the base backup and the WAL backup,so in this
> case suppose that we only can restore the database to yesterday's
> 11:30 pm state, am I right?
You can't recover to a point past your last available WAL record.
> I want to backup the pg_xlog folder every minute by crontab but my
> concern is that the data inconsistent, because the lastest log in
> pg_xlog is being updated all the time, am I right? Any
> suggestions?
Use streaming replication? Or at the very least, set a short
archive_timeout value and copy from the archive target location
frequently.
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, sgm277@yahoo.com.cn
Subject: Re: Question about PITR backup
In-Reply-To: <4FD1FC0B020000250004821F@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox