From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christopher Weimann <cweimann@k12hq.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: High Performance/High Reliability File system on SuSE64
Date: Sat, 31 Jan 2004 00:07:53 -0500
Message-ID: <26690.1075525673@sss.pgh.pa.us> (raw)
In-Reply-To: <20040124012247.GA40439@smtp.k12us.com>
References: <001001c3e1d0$072b20e0$6601a8c0@thore>
<401150F7.1040802@commandprompt.com>
<20040123175544.GA12642@phlogiston.dyndns.org>
<4011657B.2090501@commandprompt.com>
<20040124012247.GA40439@smtp.k12us.com>
Christopher Weimann <cweimann@k12hq.com> writes:
> You can do snapshots in FreeBSD 5.x with UFS2 as well but that (
> nor XFS snapshots ) will let you backup with the database server
> running. Just because you will get the file exactly as it was at
> a particular instant does not mean that the postmaster did not
> still have some some data that was not flushed to disk yet.
It *will* work, if you have an instantaneous filesystem snapshot
covering the entire $PGDATA directory tree (both data files and WAL).
Restarting the postmaster on the backup will result in a WAL replay
sequence, and at the end the data files will be consistent. If this
were not so, we'd not be crash-proof. The instantaneous snapshot
is exactly equivalent to the on-disk state at the moment of a kernel
crash or power failure, no?
regards, tom lane
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, cweimann@k12hq.com, jd@commandprompt.com, ajs@crankycanuck.ca, pgsql-performance@postgresql.org
Subject: Re: High Performance/High Reliability File system on SuSE64
In-Reply-To: <26690.1075525673@sss.pgh.pa.us>
References: <001001c3e1d0$072b20e0$6601a8c0@thore> <401150F7.1040802@commandprompt.com> <20040123175544.GA12642@phlogiston.dyndns.org> <4011657B.2090501@commandprompt.com> <20040124012247.GA40439@smtp.k12us.com> <26690.1075525673@sss.pgh.pa.us>
* 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