Odoo - Remote access with pgAdmin to Odoo postgre database on Ubuntu ?

Zarshed Ali
Zarshed Ali
5000
| 2 1 2
Asked on 2/17/15, 5:47 AM
0
vote
3713 Views

STEP #1 – get pgAdmin
Install pgAdmin from pgadmin.org

STEP #2 – allow postgre server remote connections from everywhere
Open etc/postgresql/9.x/main/pg_hba.conf and add following line:
host    all             all             all                     md5

STEP #3 – let the postgre server listen to everyone
Open etc/postgresql/9.x/main/postgresql.conf and change following line:
listen_addresses = ‘*’

STEP #4 – give the user “postgres” a password
Start the psql terminal: sudo -u postgres psql
Give a password: ALTER USER postgres PASSWORD ‘yourpassword';
Leave the psql terminal: \q

STEP #5
Restart postgre server by executing this terminal command:
sudo /etc/init.d/postgresql restart

STEP #6
Start pgAdmin and add a connection to a server like this:
new_server_connection_with_pgadmin

You are ready!

Zarshed Ali
Zarshed Ali
5000
| 2 1 2
Answered on 2/17/15, 5:48 AM
0
vote

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!

Ask a Question

Keep Informed

About This Forum

This forum is for HiTechnologia Employees & just Odoo general knowledge purpose only.

Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 2/17/15, 5:47 AM
Seen: 3713 times
Last updated: 2/17/15, 5:48 AM