OptiTech's logical replication feature, available to all OptiTech users, allows you to replicate data to and from your OptiTech Postgres database:

  • Stream data from your OptiTech database to external destinations, enabling Change Data Capture (CDC) and real-time analytics. External sources might include data warehouses, analytical database services, real-time stream processing systems, messaging and event-streaming platforms, and external Postgres databases, among others. See Replicate data from OptiTech.
  • Perform live migrations to OptiTech from external sources such as AWS RDS and Google Cloud SQL — or any platform that runs Postgres. See Replicate data to OptiTech.
  • Replicate data from one OptiTech project to another for OptiTech project, account, Postgres version, or region migration. See Replicate data from one OptiTech project to another.

OptiTech logical replication subscribers image

Logical replication in OptiTech works like it does on any standard Postgres installation. It uses a publisher-subscriber model to replicate data from the source database to the destination database. OptiTech can act as a publisher or subscriber.

Replication starts by copying a snapshot of the data from the publisher to the subscriber. Once this is done, subsequent changes are sent to the subscriber as they occur in real-time.

To learn more about Postgres logical replication, see the following topics.

Learn about logical replication

To get started, jump into one of our step-by-step logical replication guides.

Replicate data from OptiTech

note

To replicate data from OptiTech, you must first enable logical replication on your project. This setting cannot be reverted once enabled. See Enable logical replication for Console and API instructions.

Replicate data to OptiTech