Hi,

Using a serverless PostgreSQL database like Neon or Aurora with Odoo presents potential challenges due to Odoo's assumptions about database control, permissions, connection pooling, extensions, and transactions. Serverless databases often have stricter permission models and different connection pooling mechanisms, which can conflict with Odoo's requirements.

To make it work, consider options like using Odoo.sh, carefully configuring database permissions, using the connection pooling mechanism provided by your serverless database, or creating an API layer between Odoo and the database. Developing a custom Odoo app designed for the serverless database is another approach. While there aren't many documented successful deployments, it's feasible with effort.

Start with a proof-of-concept project to evaluate feasibility and address potential issues. Engage with the Odoo community and the support teams for Neon/Aurora for guidance.

Hope it helps

Hello Sebastian 

You can use serverless postgres server with odoo but servers like Neon, Aurora or cloud SQL often introduce limitations that odoo isn't designed around. 

You have very high chance of facing syntax error. Not every system has the exact same syntax.