sgm <sgm277@xxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
