Hello,

I'm trying to setup the Postgresql for OpenERP on an Ubuntu 12.04 minimal server with no shell and am following instructions at theopensourcerer[DOT]com/2012/12/how-to-install-openerp-7-0-on-ubuntu-12-04-lts/comment-page-1/

I do however need some help creating a database in Postgresql. The command I'm required to use is (after changing to postgres user):

createuser --createdb --username postgres --no-createrole --no-superuser --pwprompt openerp

But unfortunately am ending up with the following error:

createuser: 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"?

According to the PostgreSQL official documentation, it 'cos the server was not started, or it was not started where createdb expected it

I then removed PostgreSQL inorder that I may be able to do a clean reinstall and note any error messages along the way.

Using the following to uninstall in 2 steps: First dpkg -l | grep postgres results with the following:

ii postgresql 9.1+129ubuntu1 object-relational SQL database (supported version)

ii postgresql-9.1 9.1.9-0ubuntu12.04 object-relational SQL database, version 9.1 server

ii postgresql-client 9.1+129ubuntu1 front-end programs for PostgreSQL (supported version)

ii postgresql-client-9.1 9.1.9-0ubuntu12.04 front-end programs for PostgreSQL 9.1

ii postgresql-client-common 129ubuntu1 manager for multiple PostgreSQL client versions

ii postgresql-common 129ubuntu1 PostgreSQL database-cluster manager

Then sudo apt-get --purge remove postgresql results:

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following packages will be REMOVED:

postgresql*

0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.

After this operation, 64.5 kB disk space will be freed.

Do you want to continue [Y/n]? y

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LC_CTYPE = "en_CA.UTF-8",

LC_COLLATE = "en_CA.UTF-8",

LC_MESSAGES = "en_CA.UTF-8",

LANG = "en_CA.UTF-8"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

locale: Cannot set LC_CTYPE to default locale: No such file or directory

locale: Cannot set LC_MESSAGES to default locale: No such file or directory

locale: Cannot set LC_ALL to default locale: No such file or directory

(Reading database ... 75235 files and directories currently installed.)

Removing postgresql ...

Now using sudo apt-get install postgresql results to:

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following NEW packages will be installed:

postgresql

0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.

Need to get 0 B/5552 B of archives.

After this operation, 64.5 kB of additional disk space will be used.

perl: warning: Setting locale failed.

perl: warning: Please check that your locale settings:

LANGUAGE = (unset),

LC_ALL = (unset),

LC_CTYPE = "en_CA.UTF-8",

LC_COLLATE = "en_CA.UTF-8",

LC_MESSAGES = "en_CA.UTF-8",

LANG = "en_CA.UTF-8"

are supported and installed on your system.

perl: warning: Falling back to the standard locale ("C").

locale: Cannot set LC_CTYPE to default locale: No such file or directory

locale: Cannot set LC_MESSAGES to default locale: No such file or directory

locale: Cannot set LC_ALL to default locale: No such file or directory

Selecting previously unselected package postgresql.

(Reading database ... 75234 files and directories currently installed.)

Unpacking postgresql (from .../postgresql_9.1+129ubuntu1_all.deb) ...

Setting up postgresql (9.1+129ubuntu1) ...

When I try to start the postgresql server with /etc/init.d/postgresql start - no errors or messages are displayed

Would this give any indication as to why I'm getting the error as per my earlier post above?

Would really appreciate some help on this, pls. Thanks in anticipation.