August 2018 Summaries

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.