xfs
[Top] [All Lists]

Re: XFS for postgres databases?

Subject: Re: XFS for postgres databases?
From: Jeremy Jackson <jerj@xxxxxxxxxxxx>
Date: Fri, 04 Jun 2004 16:04:33 -0400
Cc: stevew@xxxxxxxxxxxxxxx, linux-xfs@xxxxxxxxxxx
In-reply-to: <3554BFA5FAE4B14FB5459D36E4F4E36203D9CF@io.goeci.com>
References: <3554BFA5FAE4B14FB5459D36E4F4E36203D9CF@io.goeci.com>
Sender: linux-xfs-bounce@xxxxxxxxxxx
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040122 Debian/1.6-1
XFS developers - there were a few notes about not reading from a block device with an XFS filesystem mounted (rw?).

Will this interfere with lvm or device-mapper snapshots using the kernel vfs-lock patch? or xfs_freeze for that matter.

I'm wondering if the snapshot would see a consistent filesystem. My concern is with using EVMS, which is based on device-mapper snapshots.

Thanks,

Jeremy

Murthy Kambhampaty wrote:
We run postgresql on xfs (over LVM) on hardware raid (raid 50) with internal logs, and have done so for years now. Great performance, no data loss. In addition, xfs_freeze is very useful for doing backups: 1.) rsync from $PGDATA to a copy location
2.) xfs_freeze -u $PGDATA
3.) repeat the rsync
4.) xfs_freeze -u $PGDATA


Online backups without pain.
(we used to do it with snapshots, but LVM snapshots don't appear to be 100% 
reliable, so we live with the freeze which is at most several seconds long)


--
Jeremy Jackson
Coplanar Networks
(519)897-1516
http://www.coplanar.net


<Prev in Thread] Current Thread [Next in Thread>