Skip to Content
Menu
This question has been flagged
1 Reply
3685 Views

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
Discard
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
Discard
Author

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 Replies Views Activity
10
May 20
7460
1
Jan 16
5299
5
Jan 17
3305
1
Feb 16
21280
3
Jul 15
3135