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?
Questions on Web Applications Stack Exchange are expected to relate to web applications within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.
Type (requires Rails I think)
Or, if you want to use Wordpress and PgSQL, take a look at this