Home / Companies / Aiven / Blog / Post Details
Content Deep Dive

Aiven PostgreSQL® now supports logical replication

Blog post from Aiven

Post Details
Company
Date Published
Author
Hannu Valtonen
Word Count
1,334
Language
English
Hacker News Points
-
Summary

Aiven has introduced an open source extension that enables users to perform logical replication without superuser roles, using PostgreSQL 10's publish/subscribe feature. This extension, called aiven_extras, creates functions that allow users to perform publish/subscribe-style logical replication without needing a superuser account as the functions themselves are run with superuser privileges. The extension greatly increases the utility of Aiven PostgreSQL and can be used for replicating a subset of tables in a database or performing no-downtime upgrades between major versions, among other use cases.