{"id":10745,"date":"2018-03-23T16:31:13","date_gmt":"2018-03-23T15:31:13","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/"},"modified":"2023-07-17T14:55:46","modified_gmt":"2023-07-17T12:55:46","slug":"postgresql-logical-replication-with-pglogical","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/","title":{"rendered":"PostgreSQL – logical replication with pglogical"},"content":{"rendered":"

Although PostgreSQL 10 integrate native logical replication (have a look here<\/a> or here<\/a>), it is always interesting to be aware of alternative solutions to the available in-core features.
\nOne of those is called pglogical<\/em>. It’s a Postgres extension developed by 2ndQuadrant<\/a>, major contributor to PostgreSQL development.
\n\"pg_logical\"
\nThe goal of this blog post is to discover how to install pglogical and configure it in order to generate simple logical replication cases.<\/p>\n

Installation<\/h3>\n

To get the extension we should start with RPM repository installation :
\npostgres@ppas02:\/u01\/app\/postgres\/product\/10\/db_1\/ [PG10] sudo yum install http:\/\/packages.2ndquadrant.com\/pglogical\/yum-repo-rpms\/pglogical-rhel-1.0-3.noarch.rpm<\/span>
\nLoaded plugins: fastestmirror
\npglogical-rhel-1.0-3.noarch.rpm | 8.3 kB 00:00:00
\nExamining \/var\/tmp\/yum-root-oH8huK\/pglogical-rhel-1.0-3.noarch.rpm: pglogical-rhel-1.0-3.noarch
\nMarking \/var\/tmp\/yum-root-oH8huK\/pglogical-rhel-1.0-3.noarch.rpm to be installed
\n...
\n...
\n...
\nInstalled:
\npglogical-rhel.noarch 0:1.0-3<\/p>\n

Complete!
\npostgres@ppas02:\/u01\/app\/postgres\/product\/10\/db_1\/ [PG10]<\/code><\/p>\n

Once installed, we can add the extension inside our Postgres instance :
\npostgres=# CREATE EXTENSION pglogical;<\/span>
\n2017-12-18 16:24:39.079 CET [4327] ERROR: pglogical is not in shared_preload_libraries
\n2017-12-18 16:24:39.079 CET [4327] STATEMENT: CREATE EXTENSION pglogical;
\nERROR: pglogical is not in shared_preload_libraries
\npostgres=#<\/code><\/p>\n

Oops… the pglogical library must be loaded when the cluster starts :
\npostgres=# alter system set shared_preload_libraries = 'pglogical';<\/span>
\nALTER SYSTEM
\npostgres=#<\/code><\/p>\n

Restart the cluster to take it in account :
\npostgres@ppas01:\/u01\/app\/postgres\/product\/10\/db_1\/share\/ [PG10] pg_ctl -D \/u02\/pgdata\/PG10\/ stop<\/span>
\nwaiting for server to shut down....2017-12-18 16:28:03.895 CET [4447] LOG: received fast shutdown request
\n2017-12-18 16:28:03.902 CET [4447] LOG: aborting any active transactions
\n2017-12-18 16:28:03.923 CET [4447] LOG: worker process: logical replication launcher (PID 4455) exited with exit code 1
\n2017-12-18 16:28:03.923 CET [4449] LOG: shutting down
\n2017-12-18 16:28:03.940 CET [4447] LOG: database system is shut down
\ndone
\nserver stopped
\npostgres@ppas01:\/u01\/app\/postgres\/product\/10\/db_1\/share\/ [PG10] pg_ctl -D \/u02\/pgdata\/PG10\/ start<\/span>
\nwaiting for server to start....2017-12-18 16:28:10.405 CET [4654] LOG: listening on IPv4 address \"0.0.0.0\", port 5420
\n2017-12-18 16:28:10.405 CET [4654] LOG: listening on IPv6 address \"::\", port 5420
\n2017-12-18 16:28:10.407 CET [4654] LOG: listening on Unix socket \"\/tmp\/.s.PGSQL.5420\"
\n2017-12-18 16:28:10.416 CET [4655] LOG: database system was shut down at 2017-12-18 16:28:03 CET
\n2017-12-18 16:28:10.426 CET [4654] LOG: database system is ready to accept connections
\n2017-12-18 16:28:10.430 CET [4661] LOG: starting pglogical supervisor
\n2017-12-18 16:28:10.435 CET [4663] LOG: manager worker [4663] at slot 0 generation 1 detaching cleanly
\n2017-12-18 16:28:10.439 CET [4664] LOG: manager worker [4664] at slot 0 generation 2 detaching cleanly
\n2017-12-18 16:28:10.444 CET [4665] LOG: manager worker [4665] at slot 0 generation 3 detaching cleanly
\ndone
\nserver started
\npostgres@ppas01:\/u01\/app\/postgres\/product\/10\/db_1\/share\/ [PG10]<\/code><\/p>\n

Once the cluster restarted with the library, we may noticed a new OS process :
\npostgres@ppas01:\/u01\/app\/postgres\/product\/10\/db_1\/share\/ [PG10] ps -ef | grep pglogical
\npostgres 5001 4994 0 16:33 ? 00:00:00 postgres: bgworker: pglogical supervisor<\/span><\/code><\/p>\n

We should now be able to create the extension :
\npostgres=# CREATE EXTENSION pglogical;<\/span>
\nCREATE EXTENSION
\npostgres=#
\npostgres=# \\dx+ pglogical<\/span>
\nObjects in extension \"pglogical\"
\nObject description
\n------------------------------------------------------------------------------------------
\nfunction pglogical.alter_node_add_interface(name,name,text)
\nfunction pglogical.alter_node_drop_interface(name,name)
\nfunction pglogical.alter_replication_set(name,boolean,boolean,boolean,boolean)
\nfunction pglogical.alter_subscription_add_replication_set(name,name)
\nfunction pglogical.alter_subscription_disable(name,boolean)
\nfunction pglogical.alter_subscription_enable(name,boolean)
\nfunction pglogical.alter_subscription_interface(name,name)
\nfunction pglogical.alter_subscription_remove_replication_set(name,name)
\nfunction pglogical.alter_subscription_resynchronize_table(name,regclass,boolean)
\nfunction pglogical.alter_subscription_synchronize(name,boolean)
\nfunction pglogical.create_node(name,text)
\nfunction pglogical.create_replication_set(name,boolean,boolean,boolean,boolean)
\nfunction pglogical.create_subscription(name,text,text[],boolean,boolean,text[],interval)
\nfunction pglogical.drop_node(name,boolean)
\nfunction pglogical.drop_replication_set(name,boolean)
\nfunction pglogical.drop_subscription(name,boolean)
\nfunction pglogical.pglogical_gen_slot_name(name,name,name)
\nfunction pglogical.pglogical_max_proto_version()
\nfunction pglogical.pglogical_min_proto_version()
\nfunction pglogical.pglogical_node_info()
\nfunction pglogical.pglogical_version()
\nfunction pglogical.pglogical_version_num()
\nfunction pglogical.queue_truncate()
\nfunction pglogical.replicate_ddl_command(text,text[])
\nfunction pglogical.replication_set_add_all_sequences(name,text[],boolean)
\nfunction pglogical.replication_set_add_all_tables(name,text[],boolean)
\nfunction pglogical.replication_set_add_sequence(name,regclass,boolean)
\nfunction pglogical.replication_set_add_table(name,regclass,boolean,text[],text)
\nfunction pglogical.replication_set_remove_sequence(name,regclass)
\nfunction pglogical.replication_set_remove_table(name,regclass)
\nfunction pglogical.show_repset_table_info(regclass,text[])
\nfunction pglogical.show_subscription_status(name)
\nfunction pglogical.show_subscription_table(name,regclass)
\nfunction pglogical.synchronize_sequence(regclass)
\nfunction pglogical.table_data_filtered(anyelement,regclass,text[])
\nfunction pglogical.wait_slot_confirm_lsn(name,pg_lsn)
\ntable pglogical.depend
\ntable pglogical.local_node
\ntable pglogical.local_sync_status
\ntable pglogical.node
\ntable pglogical.node_interface
\ntable pglogical.queue
\ntable pglogical.replication_set
\ntable pglogical.replication_set_seq
\ntable pglogical.replication_set_table
\ntable pglogical.sequence_state
\ntable pglogical.subscription
\nview pglogical.tables
\n(48 rows)<\/code><\/p>\n

The wal_level parameter must be set to ‘logical’ for logical replication :
\npostgres=# show wal_level;<\/span>
\nwal_level
\n-----------
\nlogical
\n(1 row)<\/code><\/p>\n

And the pg_hba file<\/a> must contains an entry to allow connections for replication purpose.
\nImportant : all the steps we have seen until now must be done on the standby side as well.<\/p>\n

What’s next ?<\/h3>\n

Logical replication with Postgres is based on several components :
\n– Provider : the primary node\/cluster
\n– Subscriber : the standby node\/cluster, on which data will be replicated
\n– Replication set : collection of table you want to replicate
\n– Subscription : runs the replication, based on the replication set<\/p>\n

We’ll start by creating the provider on the primary side :
\npostgres=# select pglogical.create_node (node_name := 'provider1', dsn := 'host=192.168.22.37 port=5420 dbname=postgres');<\/span>
\ncreate_node
\n-------------
\n2976894835
\n(1 row)
\npostgres=# select * from pglogical.node_interface;<\/span>
\nif_id | if_name | if_nodeid | if_dsn
\n------------+-----------+------------+-----------------------------------------------
\n2402836775 | provider1 | 2976894835 | host=192.168.22.37 port=5420 dbname=postgres
\n(1 row)<\/code><\/p>\n

Notice again a new OS process :
\npostgres@ppas01:\/home\/postgres\/ [PG10] ps -ef | grep pglogical
\npostgres 1796 1788 0 15:13 ? 00:00:00 postgres: bgworker: pglogical supervisor
\npostgres 4566 1788 0 16:05 ? 00:00:00 postgres: bgworker: pglogical manager 13211<\/span><\/code><\/p>\n

On the standby side, we create the subscriber :
\npostgres=# select pglogical.create_node(node_name := 'subscriber1', dsn := 'host=192.168.22.38 port=5420 dbname=postgres');<\/span>
\ncreate_node
\n-------------
\n330520249
\n(1 row)
\npostgres=# select * from pglogical.node_interface;<\/span>
\nif_id | if_name | if_nodeid | if_dsn
\n------------+-------------+-----------+----------------------------------------------
\n2049915666 | subscriber1 | 330520249 | host=192.168.22.38 port=5420 dbname=postgres
\n2402836775 | provider1 | 2976894835 | host=192.168.22.37 port=5420 dbname=postgres
\n(1 row)<\/code><\/p>\n

What about replication set ? There is 3 existing by default with a different DML replication behavior for each :
\npostgres=# select * from pglogical.replication_set;<\/span>
\nset_id | set_nodeid | set_name | replicate_insert | replicate_update | replicate_delete | replicate_truncate
\n------------+------------+---------------------+------------------+------------------+------------------+--------------------
\n290045701 | 2976894835 | default | t | t | t | t
\n3461245231 | 2976894835 | default_insert_only | t | f | f | t
\n2465411902 | 2976894835 | ddl_sql | t | f | f | f
\n<\/code><\/p>\n

We can easily add our own :
\npostgres=# select pglogical.create_replication_set('my_set', true, true, true, true);<\/span>
\ncreate_replication_set
\n------------------------
\n1521346531<\/code><\/p>\n

To start the replication we have to create a subscription (using the replication set we created) from the standby side :
\npostgres=# select pglogical.create_subscription(subscription_name := 'subscription1', provider_dsn := 'host=192.168.22.37 port=5420 dbname=postgres', replication_sets := '{my_set}');<\/span>
\ncreate_subscription
\n---------------------
\n1763399739
\n(1 row)<\/p>\n

postgres=# select subscription_name, status FROM pglogical.show_subscription_status();<\/span>
\nsubscription_name | status
\n-------------------+-------------
\nsubscription1 | replicating
\n<\/code><\/p>\n

Have a look in the log file… replication started with the correct provider and subscription :
\n2018-02-02 15:16:14.234 CET [5488] LOG: starting apply for subscription subscription1
\n2018-02-02 15:17:54.547 CET [5502] LOG: starting pglogical database manager for database postgres
\n<\/code>
\npostgres@ppas02:\/u02\/pgdata\/PG10\/ [PG10] ps -ef | grep pglogical
\npostgres 3113 3105 0 10:01 ? 00:00:00 postgres: bgworker: pglogical supervisor
\npostgres 4587 3105 0 13:47 ? 00:00:00 postgres: bgworker: pglogical manager 13211
\npostgres 5060 3105 0 15:06 ? 00:00:00 postgres: bgworker: pglogical apply 13211:1763399739<\/span><\/code><\/p>\n

The last step is to add the tables in the replication set we created :
\npostgres=# select pglogical.replication_set_add_all_tables('my_set', ARRAY['public']);<\/span>
\nreplication_set_add_all_tables
\n--------------------------------
\nt
\n(1 row)<\/code><\/p>\n

The insert\/update\/delete operations run against the primary server are now replicated to the standby one.<\/p>\n","protected":false},"excerpt":{"rendered":"

Although PostgreSQL 10 integrate native logical replication (have a look here or here), it is always interesting to be aware of alternative solutions to the available in-core features. One of those is called pglogical. It’s a Postgres extension developed by 2ndQuadrant, major contributor to PostgreSQL development. The goal of this blog post is to discover […]<\/p>\n","protected":false},"author":30,"featured_media":10747,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,83],"tags":[1248,1249,1250,570,77,301],"type_dbi":[],"class_list":["post-10745","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","category-postgresql","tag-1248","tag-logical","tag-pglogical","tag-postgres","tag-postgresql","tag-replication"],"acf":[],"yoast_head":"\nPostgreSQL - logical replication with pglogical - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL - logical replication with pglogical\" \/>\n<meta property=\"og:description\" content=\"Although PostgreSQL 10 integrate native logical replication (have a look here or here), it is always interesting to be aware of alternative solutions to the available in-core features. One of those is called pglogical. It’s a Postgres extension developed by 2ndQuadrant, major contributor to PostgreSQL development. The goal of this blog post is to discover […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-23T15:31:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-17T12:55:46+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_logical-e1517578175294.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jo\u00ebl Cattin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jo\u00ebl Cattin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/\"},\"author\":{\"name\":\"Jo\u00ebl Cattin\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780\"},\"headline\":\"PostgreSQL – logical replication with pglogical\",\"datePublished\":\"2018-03-23T15:31:13+00:00\",\"dateModified\":\"2023-07-17T12:55:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/\"},\"wordCount\":350,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_logical-e1517578175294.jpg\",\"keywords\":[\"10\",\"logical\",\"pglogical\",\"postgres\",\"PostgreSQL\",\"Replication\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/\",\"name\":\"PostgreSQL - logical replication with pglogical - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_logical-e1517578175294.jpg\",\"datePublished\":\"2018-03-23T15:31:13+00:00\",\"dateModified\":\"2023-07-17T12:55:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_logical-e1517578175294.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_logical-e1517578175294.jpg\",\"width\":1200,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL – logical replication with pglogical\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780\",\"name\":\"Jo\u00ebl Cattin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"caption\":\"Jo\u00ebl Cattin\"},\"description\":\"Jo\u00ebl Cattin has more than three years of experience in databases management. He is specialized in Oracle solutions such as Data Guard and RMAN and has a good background knowledge of Oracle Database Appliance (ODA), Real Application Cluster (RAC) and applications development on APEX. Jo\u00ebl Cattin\u2019s experience includes other RDBMS, such as PostgreSQL and MySQL. He is Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server 9.5 Certified Professional, RedHat Certified System Administrator and ITILv3 Foundation for Service Management Certified. Jo\u00ebl Cattin holds a degree from the \u00c9cole Sup\u00e9rieure d\u2019Informatique de Gestion (ESIG) in Del\u00e9mont and a Federal Certificate of Proficiency in Computer Science (Certificat f\u00e9d\u00e9ral de Capacit\u00e9 \u2013 CFC).\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/joel-cattin\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL - logical replication with pglogical - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL - logical replication with pglogical","og_description":"Although PostgreSQL 10 integrate native logical replication (have a look here or here), it is always interesting to be aware of alternative solutions to the available in-core features. One of those is called pglogical. It’s a Postgres extension developed by 2ndQuadrant, major contributor to PostgreSQL development. The goal of this blog post is to discover […]","og_url":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/","og_site_name":"dbi Blog","article_published_time":"2018-03-23T15:31:13+00:00","article_modified_time":"2023-07-17T12:55:46+00:00","og_image":[{"width":1200,"height":720,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_logical-e1517578175294.jpg","type":"image\/jpeg"}],"author":"Jo\u00ebl Cattin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jo\u00ebl Cattin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/"},"author":{"name":"Jo\u00ebl Cattin","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780"},"headline":"PostgreSQL – logical replication with pglogical","datePublished":"2018-03-23T15:31:13+00:00","dateModified":"2023-07-17T12:55:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/"},"wordCount":350,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_logical-e1517578175294.jpg","keywords":["10","logical","pglogical","postgres","PostgreSQL","Replication"],"articleSection":["Database Administration & Monitoring","Database management","PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/","url":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/","name":"PostgreSQL - logical replication with pglogical - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_logical-e1517578175294.jpg","datePublished":"2018-03-23T15:31:13+00:00","dateModified":"2023-07-17T12:55:46+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_logical-e1517578175294.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_logical-e1517578175294.jpg","width":1200,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/postgresql-logical-replication-with-pglogical\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL – logical replication with pglogical"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780","name":"Jo\u00ebl Cattin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","caption":"Jo\u00ebl Cattin"},"description":"Jo\u00ebl Cattin has more than three years of experience in databases management. He is specialized in Oracle solutions such as Data Guard and RMAN and has a good background knowledge of Oracle Database Appliance (ODA), Real Application Cluster (RAC) and applications development on APEX. Jo\u00ebl Cattin\u2019s experience includes other RDBMS, such as PostgreSQL and MySQL. He is Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server 9.5 Certified Professional, RedHat Certified System Administrator and ITILv3 Foundation for Service Management Certified. Jo\u00ebl Cattin holds a degree from the \u00c9cole Sup\u00e9rieure d\u2019Informatique de Gestion (ESIG) in Del\u00e9mont and a Federal Certificate of Proficiency in Computer Science (Certificat f\u00e9d\u00e9ral de Capacit\u00e9 \u2013 CFC).","url":"https:\/\/www.dbi-services.com\/blog\/author\/joel-cattin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10745"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10745\/revisions"}],"predecessor-version":[{"id":26743,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10745\/revisions\/26743"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10747"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10745"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}