On Tue, May 11, 2004 at 08:30:08PM -0700, 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.
You were running dd on the block device at the same time as using
the mounted filesystem though, weren't you? Did problems persist
after you stopped doing that? You didn't get back to us with any
further details there..
Do you (either of you) have a test case so we can try to reproduce
these problems locally?
thanks.
--
Nathan
|