I *think* it is guaranteed with WAL, otherwise the system could fail to recover after a system crash. At least that's
howI read
section 11.1.1 of the docs:
http://www.postgresql.org/docs/view.php?version=7.2&idoc=1&file=wal.html
Could freezing of the filesystem result in the WAL being fsynced at an 'inappropriate' time? Is there ever an
inappropriatetime to
fsync the WAL?
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of David F. Skoll
> Sent: 14 March 2003 15:52
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] LVM snapshots
>
>
> On Fri, 14 Mar 2003, Matt Clark wrote:
>
> > Has anyone tried taking an LVM snapshot of a running DB?
>
> I don't think there's a guarantee that a snapshot of the file system
> corresponds to a consistent database, even if the snapshot corresponds
> to a single point-in-time.
>
> --
> David.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>