slony.info

What It Is

Slony-I is a “master to multiple slaves” replication system for PostgreSQL. Its core purpose is to replicate large databases to a relatively limited number of standby nodes, with support for cascading replication and failover. It is mainly designed for scenarios such as data centers and backup sites, assuming that all nodes are normally available during regular operation.

Core Capabilities

Functionally, Slony-I is not meant to replace every built-in PostgreSQL replication option, but to serve as a complement when WAL-based replication is not suitable. It can replicate between nodes running different PostgreSQL versions; replicate only selected changes instead of the entire dataset as WAL replication does; and allow subscribers to perform additional actions, such as populating cache management information. Release notes show that the project has continued to track compatibility issues for versions such as PG10, PG11, PG12, PG13, and PG15. In terms of ecosystem, the official site provides a Git repository, mailing lists, documentation, downloads, and a Bug Policy, along with an admin guide, design documents, and engine documentation for multiple versions.

Pricing and Deployment

The source material does not mention commercial pricing or paid support. The project provides source code downloads and a Git repository, indicating an open-source model, though the page does not directly list a license. Deployment is more self-hosted in nature: database administrators need to install and configure components such as slon and slonik in a PostgreSQL environment. There is no visible information about a managed cloud service, API, or SDK.

Pros and Cons

Its strengths lie in cross-version PostgreSQL replication, making it suitable for short-downtime upgrades, migrations from legacy database versions, replication of selected tables or selected changes, and backup architectures that require cascading replication and failover. Its drawbacks are that it is more complex than the built-in streaming replication introduced after PostgreSQL 9.0. From a long-term perspective, PostgreSQL Logical Replication/Logical Decoding has stronger advantages in performance and native ecosystem support, which limits Slony-I’s appeal for new projects. The official website also feels dated, with scattered information and unclear commercial support options.

Who It’s For and Access from China

Slony-I is suitable for DBAs and infrastructure teams with complex PostgreSQL replication needs, cross-version migration requirements, or legacy database upgrade projects. If you only need primary-standby replication within the same PostgreSQL version, PostgreSQL streaming replication or logical replication should be considered first. The source material does not provide enough information to assess access from China, and there is no payment-related information. Alternatives include PostgreSQL native streaming replication, Logical Replication, Londiste, and Bucardo.