OdooWiki OCA HUB
Tools License: AGPL-3

This module supports replication of an Odoo database with pglogical by also passing DDL to the replicas. You can configure which replica sets to pass DDL to.

auto_awesome What this module does

AI-generated from the code · Odoo 12.0

This module makes Odoo replicate database structure changes (like creating or altering tables) to configured pglogical replicas, so replicated databases stay in sync with the main one.

This is a technical server-side module that changes how Odoo sends database structure changes (DDL) to PostgreSQL. When configured, it intercepts those changes and forwards them to the replica sets you choose, so copies of the database receive the same table and column updates as the main database.

  • It only activates if a pglogical section exists in the Odoo configuration file and lists one or more replication sets. Without that, it does nothing.
  • It requires the Python library sqlparse; if that library is missing, the feature is disabled and an error is logged.
  • It does not run during automated tests.
  • It automatically adds the public schema name to table and column names in the intercepted statements when needed, while leaving temporary tables and certain statements (like those involving aggregates, constraints, triggers, or indexes) untouched.
  • It does not add any menus, screens, buttons, reports, or user-facing settings in Odoo. There are no new models or business rules for end users.

In short, it is an infrastructure tool for administrators who use pglogical replication and want schema changes to propagate automatically.

Text generated by AI (DeepSeek) from reading the Odoo 12.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 1 confirmed, 8 with no information of 9 versions.

Sources · Odoo 12.0

Confirmed on 2026-11-03 in branch 12.0 of OCA/server-backend.

terminal Installation and usage

OCA documentation · Odoo 12.0

To configure this module, you need to:

  • add section [pglogical] to your odoo configuration file
  • add value replication_sets = set1,set2,set3,etc in this section
  • add pglogical to your list of server wide modules

Example:

[pglogical]
replication_sets = ddl_sql

If configured correctly, this module is completely transparent for users.

No verified information in OCA: Installation.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.