April 21st, 2013, 05:10 AM
Postgresql - Creating a new database error
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):
But unfortunately am ending up with the following error:
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:
Then sudo apt-get --purge remove postgresql results:
Now using sudo apt-get install postgresql results to:
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.
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).