Known Limitations

pg_mooncake is currently in open beta. We're actively working toward a production-ready release candidate.

Current Restrictions

TLS Replication
Replicating from remote Postgres instances with TLS encryption is not yet supported.

Remote Storage
Data persistence to remote object storage (S3, GCS, etc.) is not available. Data is currently stored on the local filesystem. Expect a similar experience as v0.1 here.

Standalone Columnstore Table deployment
Direct writes to standalone columnstore tables (v0.1 pattern) are not supported. All columnstore tables must mirror existing Postgres tables, with writes flowing through the transactional Postgres table first.

Better DX for archiving/time-series workloads
This is a pattern currently supported (See archiving). If you have any suggestions on the DX here – please reach out!

Nested Array Types
Support for nested array data types is incomplete. We've made significant progress on type compatibility, but some edge cases remain. Track progress in issue #1338.

---

Found something else? Please create an issue! We appreciate your help to improve pg_mooncake.