Re: LVM snapshots

I *think* it is guaranteed with WAL, otherwise the system could fail to recover after a system crash. At least that's how I 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 inappropriate time to
fsync the WAL?

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of David F. Skoll
> Sent: 14 March 2003 15:52
> To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org
>
>