Odoo SH - is there a way to log all the queries in postgres

Question

I need to know if it is possible in Odoo SH for PostgreSQL to log all the queries executed by the database. This is required as we may be audited for any changes made. From what I understand, in PostgreSQL, one can modify the configuration file to enable logging. However, I am unsure if Odoo SH grants sufficient permissions for this configuration.

Ray Carnes (ray) · Accepted Answer

You can edit the configuration file for every branch on Odoo.sh - not all changes are applied but changes to logging levels are.
Use the SHELL tab on your branch, then find the configuration file at *~/.config/odoo/odoo.conf*
A file like this will give you SQL output:

See  https://www.odoo.com/documentation/17.0/developer/reference/cli.html#cmdoption-odoo-bin-log-level [1] for an explanation of the different log levels.

Output:

[1] https://www.odoo.com/documentation/17.0/developer/reference

Vicente de Orue · Answer

Thank you very much for your response. This would provide all the changes entered from Odoo, but in the event that someone makes a query directly from the shell, is there a way to leave a log from Postgres to capture all these changes? This is mainly for auditing purposes.

Bài viết liên quan	Trả lời	Lượt xem
Does Odoo.sh support partitioning of tables that may grow to millions of records? database postgresql odoo.sh Odoo.sh	0 thg 9 24	1398
How can I extend an Odoo.sh staging branch due to expire soon? Đã xử lý odoo.sh Odoo.sh	2 thg 8 25	2865
module working fine on staging but not production on odoo.sh odoo.sh Odoo.sh	1 thg 3 24	2048
CVE-2023-44487 vulnerability Đã xử lý odoo.sh Odoo.sh	2 thg 10 23	3203
Odoo.sh. How to access the postgres from an external IP? Đã xử lý postgresql odoo.sh	1 thg 7 21	5978

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!