I am looking for open-source, free, self-hosted solution for a blog.
I had a look at Wordpress but it's a turn off since it does not support Postgres.
Are there any good blog engines with postgres support?
Serendipity comes with Postgres support: http://www.s9y.org/ Drupal also works with Postgresql, but it's a bit oversized for a blog. Or you could also use a framework like Django or Rails with a blog engine (more difficult to set up) -> http://stackoverflow.com/questions/82653/is-there-any-list-of-blog-engines-written-in-django / http://stackoverflow.com/questions/1807670/blog-engine-for-rails-application