Skip to Content
This question has been flagged
updatepostgresql9.2odooV8
1 Respondre
7727 Vistes
Avatar
himaOdoo

i am facing this error whenever i want to update a module from command line, 

Using the database user 'postgres' is a security risk, aborting.postgres@ubuntu:/odoo/extra_addons/module_test

here you can see my odoo.conf configuration 

options]
; This is the password that allows database operations:
; admin_passwd = admin
db_host = False
db_port = False
db_user = odoo
db_password = False
addons_path = /usr/lib/python2.7/dist-packages/openerp/addons,/odoo/extra_addons

what it could be the issue ? 

Avatar
Descartar
Avatar
Begineer
Best Answer

Hi,

    I guess you are running your server with the default user role postgres . Just create a new user role and password and try running the server with it.

sudo su postgres

Enter your system password:  

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

Enter password for new role: 

Enter it again: 

exit

Once created try running with your new user role and password by navigating into your odoo  directory

./odoo.py --addons-path=openerp/addons,openerp/extra_addons  --xmlrpc-port=8069  -r your_user_role_name -w password 

Hope it helps,

Thanks

Avatar
Descartar
himaOdoo
Autor

has it the same effect to run it with odoo user as follow ?

sudo su - odoo -s /bin/bash

python odoo-bin -u module_name -d database_name

cause i usually do it with postgresql shell

Related Posts Respostes Vistes Activitat
Why odoo want to delete some items when update all module ? Solved
update odooV8
Avatar
Avatar
10
de maig 20
10523
How to start server with --update all
update odooV8
Avatar
Avatar
1
de gen. 16
8067
Developing new modules, KeyError: 'stock.picking' return self.models[model_name] Solved
module update odooV8
Avatar
Avatar
1
de gen. 25
26210
Odoo v8 still good for use?
update odooV8 odoo9.0
Avatar
Avatar
Avatar
Avatar
5
de gen. 17
6161
Best repository for Odoo v8 and efficient way for update
update repository odooV8
Avatar
Avatar
Avatar
3
de jul. 15
5671