I am trying to install Postgresql on my Lucid 10.0.4 LTS system.
Ironically, a few months ago, I built, installed and run PG9.1 from sources on my machine, as a test. Since I will be deploying my app on a server that runs 8.4, I decided to install 8.4 on my local machine as well to test my app.
I followed the instructions here: https://help.ubuntu.com/community/PostgreSQL
here is output from my screen:
me@localhost:~$ sudo -u postgres psql postgres
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"?
I then tried
sudo /etc/init.d/postgresql-8.4 start
The postgres server failed to launch so I then tried to manually start postmaster.
Here are the results:
me@localhost:~$ postmaster -D /usr/local/pgsql/data
postmaster: command not found
What am I doing wrong?!