X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id ACF6BD1D2C7 for ; Sat, 31 Jan 2004 18:40:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 01921-07 for ; Sat, 31 Jan 2004 14:40:39 -0400 (AST) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id A8A89D1C9DB for ; Sat, 31 Jan 2004 14:40:37 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id i0VIeOa14468; Sat, 31 Jan 2004 13:40:24 -0500 (EST) From: Bruce Momjian Message-Id: <200401311840.i0VIeOa14468@candle.pha.pa.us> Subject: Re: High Performance/High Reliability File system on SuSE64 In-Reply-To: <20040124012247.GA40439@smtp.k12us.com> To: Christopher Weimann Date: Sat, 31 Jan 2004 13:40:24 -0500 (EST) Cc: "Joshua D. Drake" , Andrew Sullivan , pgsql-performance@postgresql.org X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/348 X-Sequence-Number: 5522 Christopher Weimann wrote: > On 01/23/2004-10:18AM, Joshua D. Drake wrote: > > > > XFS also has the interesting ability (although I have yet to test it) > > that will allow you > > to take a snapshot of the filesystem. Thus you can have filesystem level > > backups > > of the PGDATA directory that are consistent even though the database is > > running. > > 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. Uh, yea, it does. If the snapshot includes all of /data, including WAL/xlog, you can then back up the snapshot and restore it on another machine. It will restart just like a crash. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073