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- -- [EMAIL PROTECTED] [EMAIL PROTECTED] http://people.ne.mediaone.net/rsdavis ************