I have installed PostGreSQL 8.3 on an Ubuntu machine and I want to configure a pssw for it, however when I run this command:
sudu su postgres -c psql template1
I get the following error:
"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"?"
Can anybody tell me how I can check if the db server is running locally (only accepting connections on localhost)?
How I can start the psql server?
I'm a Linux newbie, btw