Company
Date Published
Aug. 17, 2018
Author
Hannu Valtonen
Word count
1334
Language
English
Hacker News points
None

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.