I'm trying to install postgresql 8.4 on ubuntu server 9.10, simply by running apt-get install postgresql. All fine and apt get succeeds, but there's a slight problem:
There is no configuration directory created with the postgresql config files. /etc/postgresql does not exists, only /etc/postgresql-common, but it doesn't contain the config files.
The only files I can find are the sample files in /usr/share/postgresql/8.4, but I don't think I should mess with because I believe it contains markers for automatic config file building.
I've tried the following:
When I try to start psql I get the following error:
Which, according to the documentation, means it tries to connect to the server through TCP/IP, but the server probably doesn't accept TCP/IP connections. But I also can't find a postmaster/postgresql process running anywhere.
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Anyone an idea?
Thanks in advance.