Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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 ?
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
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
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
