I recently could not restart a stopped PostgreSQL server on Fedora 7. For some reason the server stopped and would not restart. I tried uninstalling and reinstalling Postgres and had the same problems.

I then renamed the data folder (/var/lib/pgsql), reinstalled Posgres, and was able to start the service. A corrupt database or table may have been causing the errors that prevented the database services from starting.

You would think that uninstalling an application and then installing it would fix these types of problems, but in this case it didn’t. A clean uninstall should include deleting all data files that the application created. This is something that the Postgres team should consider.

Tweet This Post!

Related posts:
	Fixing “/var/lib/pgsql/data is missing” Error Updating PostgreSQL With yum Fixing Joomla’s “Unable to find install package” PostgreSQL Using Too Much Memory

Share this post:

               

Follow Me:

Did you find this post interesting and useful? You can keep up to date on this blog by subscribing to my RSS feed, or you can have new posts sent to you by e-mail. You can also follow me on Twitter.

No Comments »

Trackback This Post | Subscribe to the comments through RSS Feed