how to install Odoo 9 on ubuntu?

Question

I have pre installed postgres , postgres-9.3 and pgadmin on port 5432 and 5433 .

uninstall them then trying to install odoo 9 using http://openies.com/blog/install-openerp-odoo-9-on-ubuntu-server-14-04-lts/

this tutorial .

but when i ttrying to execute command

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

then it gives 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"?

sudo netstat -nltp | grep 5432 is not showing any result .

pg_hba.conf

# Database administrative login by Unix domain socket
local   all             postgres                                peer

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     postgres                                peer
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5

Answer 1

1. Introduction

In this tutorial I will learn you how to install Odoo 9 on Ubuntu 14.04. The script that you will use is based on the code from André Schenkels but has been updated and improved.

2. Downloading the script

The first step is to download my script from GitHub and to add the code in a new .sh file on your Ubuntu machine, wherever you’d like this. For example right under /home. Open up an Ubuntu terminal and cd to the directory where you’d like to keep the script and then create the file:

 sudo wget https://raw.githubusercontent.com/Yenthe666/InstallScript/9.0/odoo_install.sh

If you’re curious about how the whole code looks and works you can find it on my Github account.

Now open up the file and edit the parameters to your liking:

 sudo nano odoo_install.sh

There are some things you can configure/change to your likings at the top of the script. You can choose if you wish to install Wkhtmltopdf or not, which version you’d like, where the location is and most importantly what the master admin password is. Tip: always modify this for every Odoo you install!

3. Making the Odoo installation file executable

The next step is to make this file executable. After you’ve made it executable you can execute it and everything will be installed automatically. do this with the following command:

sudo chmod +x odoo_install.sh

4.Running the script

Now that the code is in your file and the file is executable you simply have to execute it with the following command:

 ./odoo_install.sh

You will see that the script automatically starts updates, downloads required packages, creates the user, downloads the code from Github, … Give the script a few minutes to configure and install everything and eventually you will see something like this:

You now have a fully functional Odoo V9 on your system! Congratulations. Odoo V9

5. Extra information

In the script you saw there was an option to change the Odoo port (OE_PORT). When you’d change this port number to 8070 in the install script it would be applied to /etc/your-config-file.conf and this would give you the ability to change the default port.

To apply these changes you should do the following:

The -c will change the configuration and memorize what you’ve changed under /etc/your-config-file.conf. Because my port was set to 8070 this is telling the Odoo that it should run on port 8070. When you would now open up your browser and navigate to http://localhost:8070/ you will see it is running there: Odoo V9 alternative port

Answer 2

This issue comes form installing the postgres package with out a version number. Although postgres will be installed and it will be the correct version the script to setup the cluster will not be run correctly. It's a packaging issue. If your comfortable with Postgres there is a script you can run to crete this cluster and get postgres running however if your like me then you do it the easy way. First purdge the old postgres install. The issue currently lies with 9.1 so I will assume that's what you have installed

sudo apt-get remove --purge postgresql-9.1 Now simply reinstall

sudo apt-get install postgresql-9.1

Note the package name with the version number. HTH.