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.
-----------------------------------------------------------------------------------------------------------------------
|