Les experts internationalement reconnus dans les domaines du support, de la formation, du développement, de la migration et du conseil PostgreSQL

ModeLifestyle Urban Femme T shirt Court Dlav Classics nwO8Pk0
ModeLifestyle Stance Boxer Pigs Pink Homme Floyd PiOkTlZwXu ModeLifestyle Stance Boxer Pigs Pink Homme Floyd PiOkTlZwXu
Team Natation Pice Super Fly De Piece Arena Maillot One Bain 1 Stripe Femme lKc1JF

The next generation of logical replication for PostgreSQL

pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication.

Connect PostgreSQL with other data sources and targets

The 3rd generation of pglogical separates out the receiver and writer processes, creating a pluggable architecture for non-PostgreSQL subscribers & providers. Pglogical already supports Kafka and RabbitMQ, with many more in the pipeline. 

Minimize downtime with physical failover

Pglogical has the ability to failover to a physical standby, thereby ensuring that all standby databases in the cluster remain available as standbys to the new primary. A physical failover ensures that all data is present in the new primary, rather than a subset - as opposed to failing over to a logical standby, which does not guarantee the entire dataset.

ModeLifestyle Stance Boxer Pigs Pink Homme Floyd PiOkTlZwXu ModeLifestyle Stance Boxer Pigs Pink Homme Floyd PiOkTlZwXu

Homme Bain Briza Maillot Natation Noir Arena De Bleu Brief 6bgYf7vy

Seamlessly replicate new and updated data structures

With Transparent DDL Replication, pglogical provides seamless replication for any updates to the data structure of the source database. The DDL replication is statement-based, i.e. it is the statement that is replicated, not the result. 

Transparent partitioning support

Through seamless integration of partitioned tables, pglogical allows you to specify the root table and replicates all partitions. Different partitioning configurations can be defined on the subscriber, including replication of a non-partitioned table to a partitioned one, and vice versa. Partitioning support is elastic, allowing to add and remove partitions transparently.  

Row and column filters

Taking advantage of logical replication, pglogical allows to filter rows and/or columns that need to be replicated to the standby database. Being selective during replication allows for reduced traffic, as well as data segregation as needed.

Availability

pglogical 2.2.1 released - October 29, 2018

pglogical is available for PostgreSQL 9.4 - 11. It is available via 2ndQuadrant’s apt and yum repositories for Debian and Red Hat family (RHEL, CentOS, and Fedora). You can use standard apt and yum package managers for installing pglogical with your instance of PostgreSQL.

Detailed installation instructions are available here. 

Release notes are available here. 

Blanc shirt Oversize Classics Urban Tee Long Adulte Rouge Carreaux ModeLifestyle HW2DIEY9

You can also access github repository. 

pglogical is fully open source, released under the PostgreSQL licence with copyright novated to the PostgreSQL Development Group.
 

About 2ndQuadrant

2ndQuadrant provides PostgreSQL solutions for the Enterprise. Our support engineers have over 100 years of combined code contributions to the PostgreSQL project, making us the only company to contribute enterprise features to all of the last 13 releases. This is paired with 17+ years of hands-on experience through client engagements and allows us to integrate customized solutions with our customers - making 2ndQuadrant the Gold Standard for PostgreSQL products & services.

To request more information about pglogical please complete the contact form below and we will have someone contact you as soon as possible! 
 

Adidas Mode Basket Adulte Stan Bd7436 Cuir Smith Composition Originals N80vmwn

ModeLifestyle Blue Slab Quiksilver Homme Shd 16 Volley FK1Jcul5T3
Pelour Pelour Bottines Femme Femme Cognac Cognac Pelour Bottines Bottines Femme Bottines Femme Cognac ZPXOkiu

All fields are required

     
  • Apr, 30 - 2018

    Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)

  • Mar, 23 - 2018

    Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)

  • Oct, 19 - 2017

    pglogical with OmniDB Topaz Homme C3 Black Element Multisport 8 5 Chambray srChQdxt

  • Sep, 22 - 2017

    PG Phriday: pglogical and Postgres 10 Partitions

  • Sep, 30 - 2016

    Untangling the PostgreSQL upgrade

  • May, 12 - 2016ModeLifestyle Stance Boxer Pigs Pink Homme Floyd PiOkTlZwXu

    PGLogical 1.1 packages for PostgreSQL 9.6beta1

2ndQuadrant Updates

ModeLifestyle Stance Boxer Pigs Pink Homme Floyd PiOkTlZwXu

ModeLifestyle Stance Boxer Pigs Pink Homme Floyd PiOkTlZwXu
   +33 9 72 17 01 31

Restons en contact

Inscrivez-vous à notre newsletter trimestrielle pour être à l'écoute des derniers développements de 2ndQuadrant et des technologies associées.

Nous vous enverrons également les informations et mises à jour importantes que vous devriez trouver utiles.

Nous prenons la confidentialité au sérieux et ne fournissons pas vos informations à des tiers.

2ndQuadrant Updates

ModeLifestyle Stance Boxer Pigs Pink Homme Floyd PiOkTlZwXu
Oxbow Marque ModeLifestyle Blanc Homme Col Noster Polo Bouton De FKJ3ul1Tc5

(c) 2001-2019 2ndQuadrant Ltd // All rights reserved // Politique de confidentialité