[ubuntu-za] Database Problems - Installing PostgreSQL

Ian Whitfield whitfield at federalsaints.net
Mon Jan 25 09:40:38 GMT 2010


OK - Today we dived back into the Postgres pond.

I had installed it a week or so back. I used

sudo apt-get install postgresql
sudo apt-get install pgadmin3

I have the two subdirectories under /etc, namely postgresql and 
postgresql-common.

I called up the PostgreSQL page under Ubuntu Community Documentation and 
it says I must first set a password to access the Server. The command is...

sudo-u postgres psql postgress

I get the error

psql: could not connect to server: no such file or directory

The documentation offers another way to connect.The command is....

sudo -u postgres createuser --superuser $USER

Here I get the error.....

createuser: could not connect to database postgres: could not connect to 
server: no such file or directory.

Any help with this please?

Ian





More information about the ubuntu-za mailing list