odoo16 连接postgresql错误
odoo16 用odoo15的环境出错,看到是psycopg2.OperationalError分析是postgresql版本问题,安装了13版本,还是出错,多版本共存问题如下:
Traceback (most recent call last):
File "D:\odsoft\python37\lib\threading.py", line 926, in _bootstrap_inner
self.run()
File "D:\odsoft\python37\lib\threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "D:\od162306\odoo\service\server.py", line 497, in target
self.cron_thread(i)
File "D:\od162306\odoo\service\server.py", line 455, in cron_thread
with conn.cursor() as cr:
File "D:\od162306\odoo\sql_db.py", line 723, in cursor
return Cursor(self.__pool, self.__dbname, self.__dsn)
File "D:\od162306\odoo\sql_db.py", line 259, in __init__
self._cnx = pool.borrow(dsn)
File "<decorator-gen-2>", line 2, in borrow
File "D:\od162306\odoo\tools\func.py", line 87, in locked
return func(inst, *args, **kwargs)
File "D:\od162306\odoo\sql_db.py", line 650, in borrow
**connection_info)
File "D:\od162306\venv\lib\site-packages\psycopg2\__init__.py", line 127, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError
INFO ? odoo.sql_db: Connection to the database failed
这个可以打开
db_password = 123
最终发现角色密码出了问题
密码用户修改正确后可以成功开始了
db_host = localhost
db_name = false
db_password = 123
db_user = postuser
db_port = 5432
http_port = 8069