Hello everyone,

I'm trying to set up automatic backups from my staging branch on Odoo.sh, with the goal of sending them to an SFTP server. I've tested several community modules (for Odoo 16 to 18, adapting where needed), but unfortunately, none of them worked as expected.

The SFTP part isn’t the issue – I'm using paramiko, and the connection/upload works fine. The real blocker is dumping the database: Odoo.sh restricts shell access and prevents using pg_dump (likely for security reasons). Every time I try, I get the same error:

permission denied for view pg_settings

So I usually end up with a working module… except for the actual backup step.

At this point, I’ve hit a wall. Even LLMs have run out of ideas. All I need is a reliable way to trigger a backup from my staging branch. Getting that backup to SFTP is trivial afterwards.

Has anyone faced (and solved) this issue? Any workaround, trick, or module that works in the Odoo.sh 18.0 environment would be a huge help.

Thanks in advance!