[Problem] - Error: cannot open pg_class_oid_index: Permission denied

Hi,

This is Selva from India.

Actually my application is using the postgres 7.2.4 as backend.

Around 8 client consoles will be connecting and making the transactions
to one of the tables in the database.

We started all 8 machines and made automatic transactions for every one
minute from all the machines to the database.

Machines were running without any problem for 2 days (without shutting
down the machines).

After 2 days 6 of the machines were hung since they were not able to
establish a connection with the table.

At the point of time, number of records in the table is 35000. (Vaccum
is not happening)

But other 2 machines are working fine.

Errors are as below:

Mac 1: At 6:51:15 - ERROR: cannot open pg_class_oid_index: Permission
denied

Mac 2: At 6:51:45 - ERROR: cannot open pg_class_oid_index: Permission
denied

Mac 3: At 6:53:54 - FATAL 1: cannot open pg_attribute: Permission
denied

Max connections configured in the database is 60

Shared buffer 256

Our application will use around 2 connections each machine. Plus 1
connection will be opened and closed for every transaction.

Please let me know what exactly is the problem and how it can be solved.

Thanks in advance,

Selva

DISCLAIMER:
-----------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
received this email in error please delete it and notify the sender immediately. Before opening any mail and
attachments please check them for viruses and defect.

-----------------------------------------------------------------------------------------------------------------------