On Thu, 13 May 2004, Jeffrey W. Baker wrote:
> On Thu, 2004-05-13 at 05:28, Net Llama! wrote:
> > On Wed, 12 May 2004, Feizhou wrote:
> > > Jeffrey W. Baker wrote:
> > > > On Tue, 2004-05-11 at 18:00, Steve Wray wrote:
> > > >
> > > >>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.
> > > >
> > > >
> > > > Until a few days ago I had a very large postgresql installation on XFS.
> > > > We suffered very unusual problems like corrupt tables, missing rows,
> > > > corrupt indexes, and so forth. We've never seen those problems on ext2,
> > > > to which we have since switched back.
> > > >
> > >
> > > Why would you put a database on a meta data journaling only filesystem?
> > >
> > > What's wrong with ext3 full journal? (data=journal)
>
> Postgres is a journalling database, so it's safe on any FS. I like to
> use a journalling FS because it's no fun to fsck several terabytes.
XFS has no fsck
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lonni J Friedman netllama@xxxxxxxxxxxxx
Linux Step-by-step & TyGeMo http://netllama.ipfox.com
|