PDA

View Full Version : PostgreSQL randomly quits



Tom Howard
01-26-2005, 02:56 PM
I've got a project I'm working on that uses Postgres. I'll start Postgres and it will work just fine. However, after a few days I'll try to login via phpPgAdmin and I won't be able to get in. When I look for problems, there isn't any Postgres process(es) running (however, mysql and others will be). I'll restart Postgres and everything will be fine again. There doesn't seem to be any pattern to it either.

Anyone else had this problem and/or know how to fix it? I need to ensure that my database backend is reliable. As an alternative, is there a way to automatically detect when something has stopped and automatically get it started again?