Back to list

Built-in replication cannot selectively replicate individual databases

6/10 Medium

PostgreSQL's built-in replication replicates entire clusters with the same settings and priority, not individual databases. This forces teams to manage multiple separate clusters to control replication groups, significantly increasing management complexity and operational overhead.

Category
config
Workaround
hack
Stage
deploy
Freshness
persistent
Scope
single_lib
Upstream
wontfix
Recurring
Yes
Buyer Type
enterprise

Sources

Collection History

Query: “What are the most common pain points with PostgreSQL for developers in 2025?3/29/2026

Built-in replication can't replicate only some databases of a cluster; you have to replicate both my-critically-important-10MB-database and my-totally-unimportant-50GB-database with the same settings, same priority, etc. This is a usability challenge because it means people have to create and manage multiple clusters to control replication groups

Created: 3/29/2026Updated: 3/29/2026