Re: System crash and trying to run vacuum getting errors

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: System crash and trying to run vacuum getting errors
Date: 2003-11-05 17:34:31
Message-ID: 87n0ba3ejc.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> You should be able to DROP that table even though it doesn't have an
> underlying file. My guess is that you are running atop a non-crash-safe
> filesystem and it lost the directory entry for the just-created file.
> You might want to think about switching to a journaling file system.

In which case you might find them in /lost+found

--
greg

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-11-05 17:38:13 Re: Using SUBSELECT in CHECK expressions
Previous Message Tom Lane 2003-11-05 17:22:34 Re: System crash and trying to run vacuum getting errors