Thread: Postgres restart problems
Hi, We have a postgres db which has been crashing about 5 times a day. It must be failrly apparent given my other messages to this mailing list. Now we are faced with a new problem. After crash we were able to restart postmaster. Now postgres is getting more temperamental. It refused to restart saying that the data directory is not found. When we posted this message last time... Somebody said... check out whether hard disk mounted. This is hilarious. We are doing serious stuff and the minimum we ensure that the directory exists. Finally I have cracked the problem. ipcclean utility does nothing. Instead you have to explicitly use ipcs and ipcrm and to clear all semaphore and shared memory which is blocked. After which restarting postmaster goes thru'. Hope this helps somebody in a different state of distress than mine. Bye, Murali Differentiated Software Solutions Pvt. Ltd., 176, Gr. Floor, 6th Main 2nd Block RT Nagar Bangalore - 560 032 India Ph: 91 80 3431470
I remember having to do the same thing on a aix oracle installation. I wrote a little shell script that did it for me. bob "Differentiated Software Solutions Pvt. Ltd." wrote: > Hi, > > We have a postgres db which has been crashing about 5 times a day. It must > be failrly apparent given my other messages to this mailing list. > > Now we are faced with a new problem. After crash we were able to restart > postmaster. Now postgres is getting more temperamental. It refused to > restart saying that the data directory is not found. > When we posted this message last time... Somebody said... check out whether > hard disk mounted. This is hilarious. We are doing serious stuff and the > minimum we ensure that the directory exists. > > Finally I have cracked the problem. ipcclean utility does nothing. Instead > you have to explicitly use ipcs and ipcrm and to clear all semaphore and > shared memory which is blocked. After which restarting postmaster goes > thru'. > > Hope this helps somebody in a different state of distress than mine. > > Bye, > > Murali > > Differentiated Software Solutions Pvt. Ltd., > 176, Gr. Floor, 6th Main > 2nd Block RT Nagar > Bangalore - 560 032 > India > Ph: 91 80 3431470 > > +ACoAKgAqACoAKgAqACoAKgAqACoAKgAq- -- rdavis@lillysoftware.com rsdavis@mediaone.net http://people.ne.mediaone.net/rsdavis