I am running the PostgreSQL 8.0 beta on my Windows box for development. While I was downstairs eating dinner, my computer crashed, which even though it is Windows, that is still unusual. When I tried to start PostgreSQL after the reboot, it would not start. Windows would say, this is sometimes normal for services to just not start up and offered no assistance about what was actually going wrong. I found a .pid file in the data directory. Since the database wasn't running, I decided that it should go. I tried to start it again and BAM it started right up.
So, if you can't get your Postgre database running after a Windows crash, try deleting the .pid file in the data directory.
Posted by carl at September 3, 2004 11:23 PM
Comments