PostgreSQL Publications → Subscriptions (3 → 1 Funnel) → Metabase

Central read-only PostgreSQL via logical replication
for real-time Metabase visualization
without external tools

Databases of Services

PostgreSQL 1

PostgreSQL 2

PostgreSQL 3

Schema 1 Publication

Schema 2 Publication

Schema 3 Publication

Schema 4 Publication

Schema 5 Publication

Schema 1 Subscription

Schema 2 Subscription

Schema 3 Subscription

Schema 4 Subscription

Schema 5 Subscription

Central Read-only Database

PostgreSQL Central Replication

Data Visualization Tools

Metabase