In a previous version of this blog I complained that Ubuntu developers would ignore the problem.
Martin Pitt pointed out that the problem had something to do with my settings of locale. It turns out that the installation script checks very stringently for a correct setting of the locales. Otherwise it would simply terminate the installation process.
locales showed a correct list of locale settings.
Martin suggested to use the following command:
sudo locale-gen de_AT.UTF-8 en_US.UTF-8On my test machine this changed nothing (obvious). Only when Martin explained why he insisted on the locales (setting the character set and collation sequence in tables) did I follow his advice and reset the locales.
Reinstallation postgresql 8.2 worked finally, the database started automatically.
Kudos to Martin Pitt for having the patience putting up with me. Martin, I am sorry.
To set up you database server you first need to:
- edit postgresql.conf configuration file and set
listen_addresses = '*'
- edit pg_hba.conf host based authentication configuration, add
hostssl all all 0.0.0.0 0.0.0.0 md5to the end of the file to allow all clients to connect to the database
- restart the database server with