Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Installting OpenERP 7 - PostgreSQL issues

By
bizres
on 4/21/13, 7:57 AM 2,714 views

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.

i guess u need to supply hostname and port number also while creating db

Bhavik
on 4/22/13, 12:02 AM
0

patrick

--patrick--
1958
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
On 4/22/13, 9:20 AM

I see some error messages regarding languages, when you install postgreSQL. Are you sure you have configured/specified the correct language for your server? I am talking about the following messages:

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

## Maybe you should reinstall the server from scratch, and make sure you have specified a language.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 4/21/13, 7:57 AM
Seen: 2714 times
Last updated: 3/16/15, 8:10 AM