Step-by-Step Guide: How to Install Odoo 16 on Windows Server 2022 with PostgreSQL and PyCharm

[@ygorsardinha5521]

So easy to follow... great tutorial!

[@ITIssueFixers-wo2sy]

Thank you a lot

[@polasamy9699]

quite helpful, thank you!!

[@alfgerardo]

What is the difference between your installation with installing "odoo server and postgreSQL server" in the same wizard odoo setup

[@YasminSalah-r2s]

you have a folder in Odoo16 called venv, from where you get this folder? It is not existed in my Odoo16 in program files :((

[@ITIssueFixers-wo2sy]

Navigate to Your Odoo Project Directory:
Open Windows File Explorer.
Go to the directory where you've set up your Odoo project or instance. This is where you've created the virtual environment.
Locate the venv Folder:
Within your Odoo project directory, you should see the venv folder. It may be named "venv" or "env," depending on how you set up your virtual environment.
Example path: C:\yourpath\odoo16\venv
Access the Virtual Environment:
Inside the venv folder, you'll find the Python virtual environment that Odoo uses. It contains a copy of the Python interpreter and the installed packages specific to your Odoo project.
E:\Program Files\Odoo16\venv

[@furqanqadeer17]

i could't find this documentation on Odoo. Can you please send link.

[@capitan_edgar]

Al parecer la web está actualizada y ya no es como antes, yo también la estoy buscando

[@fakecut5007]

I've got a question regarding your password. Did you use the password Odoo in PGAdmin or is it just the default password? I did follow everything you did (afaik) but I do get a psycopg2.OperationalError as soon as I start the instance. Played around a little with the password thing, and didn't have an error but still couldn't connect with the server.
And is it important that you set your User as iif\administrator as you install postgres? I installed it before, and I don't think the tutorial told me to do so, so I'm not quite sure what I did back then. Thank you very much :)

[@fakecut5007]

Exception in thread odoo.service.cron.cron0:
Traceback (most recent call last):
File "C:\Program Files\Python38\lib\threading.py", line 932, in _bootstrap_inner
self.run()
File "C:\Program Files\Python38\lib\threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "C:\Program Files (x86)\Odoo\server\odoo\service\server.py", line 497, in target
self.cron_thread(i)
File "C:\Program Files (x86)\Odoo\server\odoo\service\server.py", line 455, in cron_thread
with conn.cursor() as cr:
File "C:\Program Files (x86)\Odoo\server\odoo\sql_db.py", line 740, in cursor
return Cursor(self.__pool, self.__dbname, self.__dsn)
File "C:\Program Files (x86)\Odoo\server\odoo\sql_db.py", line 267, in __init__
self._cnx = pool.borrow(dsn)
File "", line 2, in borrow
File "C:\Program Files (x86)\Odoo\server\odoo\tools\func.py", line 87, in locked
return func(inst, *args, **kwargs)
File "C:\Program Files (x86)\Odoo\server\odoo\sql_db.py", line 668, in borrow
result = psycopg2.connect(
File "C:\Program Files (x86)\Odoo\venv\lib\site-packages\psycopg2\__init__.py", line 127, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError
Exception in thread odoo.service.cron.cron1:
Traceback (most recent call last):
File "C:\Program Files\Python38\lib\threading.py", line 932, in _bootstrap_inner
self.run()
File "C:\Program Files\Python38\lib\threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "C:\Program Files (x86)\Odoo\server\odoo\service\server.py", line 497, in target
self.cron_thread(i)
File "C:\Program Files (x86)\Odoo\server\odoo\service\server.py", line 455, in cron_thread
with conn.cursor() as cr:
File "C:\Program Files (x86)\Odoo\server\odoo\sql_db.py", line 740, in cursor
return Cursor(self.__pool, self.__dbname, self.__dsn)
File "C:\Program Files (x86)\Odoo\server\odoo\sql_db.py", line 267, in __init__
self._cnx = pool.borrow(dsn)
File "", line 2, in borrow
File "C:\Program Files (x86)\Odoo\server\odoo\tools\func.py", line 87, in locked
return func(inst, *args, **kwargs)
File "C:\Program Files (x86)\Odoo\server\odoo\sql_db.py", line 668, in borrow
result = psycopg2.connect(
File "C:\Program Files (x86)\Odoo\venv\lib\site-packages\psycopg2\__init__.py", line 127, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError
That's the error I'm getting...

[@fakecut5007]

I think my error is understanding what I need to define as the db_password and db_user in the config files, but I might be wrong....

[@ITIssueFixers-wo2sy]

Yes, I think you need to change the db_password and db_user in the odoo.conf

[@fakecut5007]

@@ITIssueFixers-wo2sy is it always "odoo" by default or does it depend on what I chose in PG Admin?

[@ITIssueFixers-wo2sy]

If you are referring to the default database name in Odoo, it is often set to "odoo" by default during the installation process. However, the database name can be customized during the installation or configuration steps, and it doesn't necessarily have to be "odoo." The choice of the database name depends on what you specify during the setup.@@fakecut5007

[@mohammadayash9217]

why did the conf file changed with you ?

[@ITIssueFixers-wo2sy]

Please explain your question more