#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2013
    Posts
    1
    Rep Power
    0

    Postgresql - Creating a new database error


    Hello,

    I'm trying to setup a Postgresql based web app (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):

    sudo su - postgres
    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.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Location
    Usually Japan when not on contract
    Posts
    240
    Rep Power
    11
    Two things:

    You may need to run "initdb" to get Postgres' data storage area initialized. This is the most likely problem. Postgres setup is pretty simple, but different distros have different initial states for Postgres, so I suggest searching for a "how to get postgres up on Ubuntu" howto on the Ubuntu forums (no doubt there is already a lot of information on this, you just have to find it).

    And... OpenERP sucks. Nothing works the way you will expect, it can't be customized to your business need without extreme contortions or changing the way that you do business (and its assumption are very European in nature -- like it can't imagine a world without a VAT on everything). And... it can't decide whether it is an ERP system, or a business rules development framework (hint: it can't be both and do either well).

IMN logo majestic logo threadwatch logo seochat tools logo