Re: [ADMIN] cannot open segment 1 of relation .... No such file or directory

Hello, --- Tom Lane <[EMAIL PROTECTED]> wrote: > <[EMAIL PROTECTED]> writes: > > I'm using PG 7.3.4 under RedHat 9.0 and I've started noticing the > > following type of errors: > > cannot open segment 1 of relation url (target block 537329664): > No > > such file or directory > > If this is co

Re: [ADMIN] cannot open segment 1 of relation .... No such file or directory

<[EMAIL PROTECTED]> writes: > I'm using PG 7.3.4 under RedHat 9.0 and I've started noticing the > following type of errors: > cannot open segment 1 of relation url (target block 537329664): No > such file or directory If this is coming from an indexscan query, then I'd bet on the problem being a

[ADMIN] cannot open segment 1 of relation .... No such file or directory

Hello, I'm using PG 7.3.4 under RedHat 9.0 and I've started noticing the following type of errors: cannot open segment 1 of relation url (target block 537329664): No such file or directory How can I determine what exactly is corrupt or missing and which row is triggering this? I have found pg