Non-simultaneous file system snapshots as backups

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Non-simultaneous file system snapshots as backups
Date: 2011-03-11 16:46:27
Message-ID: 201103111646.p2BGkRE21839@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I know we allow people to use file system snapshots as backups, but what
happens if they are using tablespaces and they can't do the snapshots
simultaneously? If there is only one check point happening between the
first and last snapshot, would the WAL logs clean up that inconsistency
like they do for crashes? I assume the pg_xlog directory would have to
be the last file system snapshotted. If so, is this something we should
document?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2011-03-11 16:50:20 Add unistd.h to c.h
Previous Message Robert Haas 2011-03-11 16:45:50 Re: multiple -f support