Re: missing pg_clog files ?

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: missing pg_clog files ?
Date: 2003-09-22 18:21:43
Message-ID: 20030922182142.GA2693@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Sep 22, 2003 at 05:03:28PM +0100, Patrick Welche wrote:
> On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote:
> > Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> writes:
> > > I hope I guessed the right syntax...
> > > % pg_filedump -R 71716 data/base/17148/283342
> >
> > Yes, but this doesn't give all the available info. Add -i and -f
> > options. A plain -d dump might be interesting too.
>
> Indeed, the plain -d dump says that I have a chunk of /var/mail/prlw1
> in 1000-13ff. No wonder postgres complained!

For the record, what filesystem is this on? Is it ReiserFS by any
chance?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Aprende a avergonzarte mas ante ti que ante los demas" (Democrito)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2003-09-22 18:29:31 Re: Killing the backend to cancel a long waiting query
Previous Message Paulo Scardine 2003-09-22 17:53:45 Re: Killing the backend to cancel a long waiting query