I have spent quite a bit of time wrestling with this postgresql update, but I just can't quite get it configured correctly. I recently upgraded from 9.0 to 9.1, and I can't get Postgres 9.1 configured correctly.
I wanted it to start on start up, so I went and found the postgres file in etc/init.d and replaced it with the script that came with the source files (the linux script found in
I only changed some of the stuff as follows:
# Installation prefix prefix="/usr/local/pgsql" # Data directory PGDATA="/var/lib/postgresql/9.1/main" # Who to run the postmaster as, usually "postgres". (NOT "root") PGUSER=postgres # Where to keep a log file PGLOG="/var/log/postgresql/9.1"
Then I installed and ran
chkconfig --add postgresql. From what I could see, the rhN directories seemed to have been updated. But, unfortunately, Postgresqk didn't work, it does not start up, or at least, I don't think it starts up. Did I miss a step?
Also, when I run
/usr/local/pgsql/bin/psql , the error says:
Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Whereas running the old server's psql command when it's not running gives:
Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
What is that domain socket directory, and do I need to change it?
So, how do I get it to start up, if it helps, I am running Ubuntu 10.04 LTS.
Lastly, I know it's bad etiquette to ask multiple questions, but I figured it would be rude to make another question for a small question like this: I also want to make it so that if I enter a postgres command (e.g. psql) into the terminal, it should run the new postgres command, not the old one like it does now. Where do I change this?
Thanks for all your help.