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)
I will note the server runs nothing but postgresql. Secondly, all changes --
kernel upgrades, version upgrades, etc. -- are first tested and allowed to
"soak in" on a test server, before they are applied to the production server.
All in all, your skepticism is well justified.
> -----Original Message-----
> From: linux-xfs-bounce@xxxxxxxxxxx
> [mailto:linux-xfs-bounce@xxxxxxxxxxx]On Behalf Of Steve Wray
> Sent: Tuesday, May 11, 2004 9:00 PM
> To: linux-xfs@xxxxxxxxxxx
> Subject: XFS for postgres databases?
> Hi there,
> I'd just like to know if anyone knows of any issues with running a
> postgres database on an XFS filesystem in Linux?
> We did this a few weeks ago and the DB Admin swears that they
> have been
> seeing problems. I'm not convinced that the problems are XFS related.