I am a newbie here and to the server administration. A couple of days back I have registered a server with Hetzner with Ubuntu 11.04.
I intend to work with PostgreSQL, for which I have installed from source after failing to install using apt-get. The installation as such doesn't fail, but the PostgreSQl service doesn't start automatically or when I try to start it manually. It fails with the following error message when I try to do anything with it:
manager@Ubuntu-1104-natty-32-minimal:~$ sudo su postgres -c psql template1
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"?
This was the error I was getting when I had installed PostgreSQL using apt-get and I re-installed it from source. The following is the output I got when I installed it from source. This confirms that the PostgreSQL is indeed installed.
make -C config install
make[1]: Entering directory `/home/manager/postgresql-9.0.4/config'
/bin/mkdir -p '/usr/local/pgsql/lib/pgxs/config'
/bin/sh ../config/install-sh -c -m 755 ./install-sh '/usr/local/pgsql/lib/pgxs/config/install-sh'
make[1]: Leaving directory `/home/manager/postgresql-9.0.4/config'
PostgreSQL installation complete.
But, doesn't the service starts automatically? It doesn't here:
manager@Ubuntu-1104-natty-32-minimal:~$ ps auxw | grep post
manager 6734 0.0 0.0 4156 868 pts/0 S+ 14:10 0:00 grep --color=auto post
This is taking a toll on my patience and confidence. Please help me solve this problem.