Modules tagged postgresql · Puppet Forge Offers support for basic management of PostgreSQL databases. Release notes for repmgr 3.0: repmgr - Replication Manager for… repmgr (Replication Manager) is a tool that helps DBAs and System administrators manage a cluster of PostgreSQL databases
PostgreSQL provides infrastructure to stream the modifications performed via SQL to external consumers. This functionality can be used for a variety of purposes, including replication solutions and auditing.
Streaming replication slots in PostgreSQL 9.4 How can the answer be improved? PostgreSQL: Documentation: 9.4: Streaming Replication Protocol The name of the slot to create. Must be a valid replication slot name (see Section 25.2.6.1). output_plugin. The name of the output plugin used for logical decoding (see Section 46.6). Streaming replication slots in PostgreSQL 9.4 Streaming replication slots are a new facility introduced in PostgreSQL 9.4. They are a persistent record of the state of a replica that is kept on the master server even when the replica … Streaming Replication Slots in PostgreSQL 9.4 - blogspot.com
Replication slots allow standbys to provide information to the primary or upstream cascading standby as to the point they've reached in the write-ahead log. This information is available to the ...
GitHub - Adbsql/adb-repmgr Replication slots were introduced with PostgreSQL 9.4 and are designed to ensure that any standby connected to the master using a replication slot will always be able to retrieve the required WAL files.
PostgreSQL 9.4 and later come with a feature called “replication slots”. They can be used to make WAL archiving and streaming replication more robust …
Using PostgreSQL Logical Replication to Maintain an Always Up… This blog discusses logical replication in PostgreSQL: its use cases, general information on the status of this technology, and a special use case in particular on how to setup a subscriber (replica) node of the primary server in order to … /usr/src.org – PostgreSQL - Streaming Replication - name: PostgreSQL NODE1 hosts: node1 sudo: yes roles: - ANXS.postgresql vars: - postgresql_version: 9.4 - postgresql_encoding: 'UTF-8' - postgresql_locale: 'en_US.UTF-8' - postgresql_listen_addresses: - '*' - postgresql_ssl: on … Barman for PostgreSQL - Browse /2.0 at SourceForge.net Backup and Recovery Manager for PostgreSQL
PostgreSQL: Documentation: 9.4: Log-Shipping Standby Servers
Replication slots were introduced with PostgreSQL 9.4 and are designed to ensure that any standby connected to the master using a replication slot will always be able to retrieve the required WAL files. Postgres 9.5 feature highlight - Replication slot control with… commit: d9f38c7a555dd5a6b81100c6d1e4aa68342d8771 author: Andres Freund
Physical and Logical replication API - PostgreSQL The replication stream will send all changes since the creation of the replication slot or from replication slot restart LSN if the slot was already used for replication. You can also start streaming changes from a particular LSN position,in that case LSN position should be specified when you create the replication stream. Example 9.7. Postgres 9.4 feature highlight - Physical slots for Mar 12, 2014 · Replication slots is a new feature of PostgreSQL 9.4 that has been introduced by this commit: In the case of a standby node using streaming replication, the server does not actually wait for the slave to catch up if it disconnects and simply deletes the WAL files that are not needed. This has the advantage to facilitate management of the ...