postmaster locking issues
От | suchet singh khalsa |
---|---|
Тема | postmaster locking issues |
Дата | |
Msg-id | LAW-F28q1apZwMybLb900001b91@hotmail.com обсуждение исходный текст |
Ответы |
Re: postmaster locking issues
|
Список | pgsql-hackers |
Hello Everybody, Sorry for mailing at both the addresses. The situation is a nightmare at our installation facility, hence the need to capture as much attention as possible. We are using PostgreSQL 7.0 along with Enhydra 3.0 application server to host a web site. It has been observed that sometimes (can't pinpoint when it starts) the postmaster instance 'hangs' and another starts. Then the new one hangs and another starts. This happens until the max limit for backends is reached (32 in our case). Then the whole application crashes. After some debugging in our code, we have come to theconclusion that this problem could be due to some internal locking problem in Postgres. This issue of the locking abilities of the postmasterhas been discussed before (see the reference section below). However, it seems that it was dropped without any action plan, especially the part about point 3 : "Two PID files will be necessary, one to prevent mulitple instances of postmasters from running against the same data base, and one to prevent multiple instances from using the same port." Can anybody point us in the right direction? Thanks in advance. References: http://www.postgresql.org/mhonarc/pgsql-hackers/1998-10/msg00295.html This is the first mail in the thread by Bill Allie. Thank You, Suchet Singh, IMRglobal Corp. P.S. Please mail any suggestions to suchet_singh@hotmail.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
В списке pgsql-hackers по дате отправления: