On Thu, 10 Jul 2003, Christopher Kings-Lynne wrote:
> Just saw this on our demo server:
>
> [EMAIL PROTECTED]:~/htdocs/webdb/conf# /usr/local/pgsql-7.3.3/bin/psql -p5473
> phppgadmin
> psql: FATAL: cannot open segment 1 of relation
> pg_trigger_tgrelid_tgname_index (target block 8310112): No suc
On Thu, 10 Jul 2003, Christopher Kings-Lynne wrote:
> > Hmm... I was thinking the index could be somehow corrupted. However,
> > it's strange that all databases have the same problem, since pg_trigger
> > is not shared across databases.
> >
> > Have you tried reindexing pg_trigger?
>
> Can't -
> Hmm... I was thinking the index could be somehow corrupted. However,
> it's strange that all databases have the same problem, since pg_trigger
> is not shared across databases.
>
> Have you tried reindexing pg_trigger?
Can't - I can't log into any database.
Maybe it's one of psql's startup q
On Thu, Jul 10, 2003 at 11:45:09AM +1000, Gavin Sherry wrote:
> On Thu, 10 Jul 2003, Christopher Kings-Lynne wrote:
>
> > Just saw this on our demo server:
> >
> > [EMAIL PROTECTED]:~/htdocs/webdb/conf# /usr/local/pgsql-7.3.3/bin/psql -p5473
> > phppgadmin
> > psql: FATAL: cannot open segment 1
On Thu, 10 Jul 2003, Christopher Kings-Lynne wrote:
> Just saw this on our demo server:
>
> [EMAIL PROTECTED]:~/htdocs/webdb/conf# /usr/local/pgsql-7.3.3/bin/psql -p5473
> phppgadmin
> psql: FATAL: cannot open segment 1 of relation
> pg_trigger_tgrelid_tgname_index (target block 8310112): No suc
Just saw this on our demo server:
[EMAIL PROTECTED]:~/htdocs/webdb/conf# /usr/local/pgsql-7.3.3/bin/psql -p5473
phppgadmin
psql: FATAL: cannot open segment 1 of relation
pg_trigger_tgrelid_tgname_index (target block 8310112): No such file or
directory
Any solution? Happens on all databases.
Ch
