Re: LVM snapshots

I don't see why not. What happens if your server crashes? Hopefully what's
on the disk is consistent (one of the good reasons to use Postgresql).

BTW I've heard of someone else doing something like this and using rsync.
He was running it just before the snapshot and then again against the
snapshot. This should then reduce the amount of time the actual snapshot
needs to be kept.

Regards,

Ben

-----Original Message-----
From: David F. Skoll [mailto:dfs(at)roaringpenguin(dot)com]
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

*****************************************************************************
This email and any attachments transmitted with it are confidential
and intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the sender and do not store, copy or disclose the content
to any other person.

It is the responsibility of the recipient to ensure that opening this
message and/or any of its attachments will not adversely affect
its systems. No responsibility is accepted by the Company.
*****************************************************************************