Originally Posted by btmiller
I just tried this on Ubuntu Karmic and their is indeed a postgres user created, however it is not configured with a password. Are you sure
it's not being created for you (how are you checking?)? You could set one with:
sudo passwd postgres
or just become the postgres user via sudo:
opps quite correct, after serveral instals and reinstalls I got that far.
now I did have an /etc/postgres this is now missing, and
root@tux:~# su - postgres
postgres@tux:~$ createdb mytestdb
createdb: could not connect to database postgres: 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"?