On Wednesday 12 May 2004 16:39, Nathan Scott wrote:
> 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?
Unfortunately this was on the database of a very sensitive client so we
have scrubbed XFS and reverted to ext2. So I can't reproduce the
problem at all. I'll have a chat with the database developers and
admins and see if we can construct a test case on a development box.