PostgreSQL FATAL: role "root" does not exist

I have installed postgresql via apt-get install postgresql, but have an error, don't make the folder /etc/postgresql/9.1.

The error on psql:

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 have installed the postgre via apt-get install postgresql, but have a error, dont make the folder /etc/postgresql/9.1

the error on 'psql':

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 upgraded a server with a Rails application to Ubuntu 12.04 from 10.04 and cannot connect to Postgresql database now...

Here is the error message from Rails app:

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"

Also the pg_ctl start is not recognized as a command.

EDIT:

Tur

I'm trying to setup rails 3.0.10 on a Ubuntu VPS server. I'm using postgres 9.0.4, Apache and passenger.

I installed postgresql via homebrew on my 10.7.3. The install seemed successful and I was able to start up the server. However when I try to access psql I get the following error:

psql: FATAL: role "larson" does not exist

In this case larson is my username. Does anybody know what the issue is and what I can do to address it?

I have a PostgreSQL 8.4 database running on Windows, but I've lost the name of the superuser username, so am unable to connect.

I've already configured pg_hba.conf to use trust to allow connections without a password, but I still need to know the name of a valid user to login.

I've tried postgres, admin etc, but I always get:

psql: FATAL: role "USERNAME" does not exist

I have installed postgresql using pacman & now it doesn't start.

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM with port 5432 mapped between host and VM.

pgAdmin Error:

Error connecting to the server: could not receive data from server: Software caused connection abortion (0x00002745/10053)

postgresql.conf

#------------------------------------------------------------------------------ # CONNECTIO

Hello all,

I can't start postgresql and logs are empty. Here is the complete steps I did so far:

I just installed Opensuse 11.2, got it up to date. Then I zypped in postgresql and postgresql-server.

When I first did rcpostgresql start, after a while (a minute or so of waiting) I got a message "could not start server". Bummer.