could not open relation "pg_trigger_tgrelid_tgname_index" - Mailing list pgsql-general

From Octavio Alvarez Piza
Subject could not open relation "pg_trigger_tgrelid_tgname_index"
Date
Msg-id 4823.63.84.67.25.1085187321.squirrel@alvarezp.ods.org
Whole thread Raw
Responses Re: could not open relation  (Octavio Alvarez Piza <alvarezp@alvarezp.ods.org>)
List pgsql-general
Hello to everybody.

I'm running PostgreSQL under Cygwin on Windows 2000 SP4.

I'm receiving the following error on ANY connection to our main database:
pgsql: FATAL: could not open relation "pg_trigger_tgrelid_tgname_index":
No such file or directory.

Connections to template1 succeed, template0 is not accepting any
connections and other test databases under the same PostgreSQL instance do
work.

I already tried restarting the service and it does well, but still doesn't
allows us connections to the main database.

I can't even connect to do a dump, so I can re-init the DB. The problem
started suddenly like 2 days ago.

Is this a known issue? I'd like to know if there is any available help and
if there is any other information useful to diagnose this problem.

Thanks in advance.

Octavio.

pgsql-general by date:

Previous
From: "Carl E. McMillin"
Date:
Subject: Re: Am I locking more than I need to?
Next
From: Mike G
Date:
Subject: Re: pg_temp_N temp schema buildup