
{"id":5597,"date":"2024-04-24T07:03:02","date_gmt":"2024-04-24T07:03:02","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=5597"},"modified":"2024-04-24T07:09:35","modified_gmt":"2024-04-24T07:09:35","slug":"troubleshooting-postgresql-replication-setup-errors-with-repmgr","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/","title":{"rendered":"Troubleshooting PostgreSQL Replication Setup Errors with repmgr"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Hey All<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Managing a PostgreSQL replication setup involves various challenges, especially when encountering errors during configuration. This blog post explores common errors encountered while setting up replication using repmgr, a popular replication manager for PostgreSQL. We&#8217;ll delve into the causes of these errors and provide solutions to overcome them, ensuring a seamless replication setup. We had discussed setting up High Availability in Postgres using repmgr in this <a href=\"https:\/\/test.opensource-db.in\/wp1\/setting-up-high-availability-with-repmgr\/\">post<\/a>. If you did not get a chance to go through it, now might be a good time for it. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These are the some of the errors\/issues I faced in my initial work on repmgr as well as with ec2 instances. They might look very basic, but they reinforce the fact that minute details are important.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Error#1<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This is the first brake of my smooth journey with ec2 instances &amp; repmgr. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;postgres@ip-172-31-14-99 ~]$ \/usr\/pgsql-14\/bin\/repmgr -f \/var\/lib\/pgsql\/repmgr.conf primary register\nWARNING: the following problems were found in the configuration file:\n  parameter \"cluster\" is deprecated and will be ignored\nINFO: connecting to primary database...\nERROR: connection to database failed\nDETAIL:\nconnection to server at \"52.64.241.210\", port 5432 failed: timeout expired\n\nDETAIL: attempted to connect using:\n  user=repmgr connect_timeout=2 dbname=repmgr host=52.64.241.210 fallback_application_name=repmgr options=-csearch_path=\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Solution<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">We need to edit the inbound rules of the security group and add each and every PostgreSQL EC2 instances to allow traffic to flow between those instances.<br>Steps to do : Instances &#8211;> Security&#8211;>Security group&#8211;>Edit Inbound rules<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Add the PostgreSQL to the security group as mentioned below<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"426\" src=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/Error1ANB-1024x426.png\" alt=\"\" class=\"wp-image-5598\" style=\"width:841px;height:auto\" srcset=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/Error1ANB-1024x426.png 1024w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/Error1ANB-300x125.png 300w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/Error1ANB-768x319.png 768w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/Error1ANB-1536x639.png 1536w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/Error1ANB-238x99.png 238w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/Error1ANB-192x80.png 192w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/Error1ANB-394x164.png 394w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/Error1ANB-915x381.png 915w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/Error1ANB-1240x516.png 1240w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/Error1ANB.png 1762w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Result<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;postgres@ip-172-31-14-99 bin]$ \/usr\/pgsql-14\/bin\/repmgr -f \/var\/lib\/pgsql\/repmgr.conf primary register\nWARNING: the following problems were found in the configuration file:\n  parameter \"cluster\" is deprecated and will be ignored\nINFO: connecting to primary database...\nNOTICE: attempting to install extension \"repmgr\"\nNOTICE: \"repmgr\" extension successfully installed\nNOTICE: primary node record (ID: 1) registered\n\n#Verifying Primary registeration \n&#91;postgres@ip-172-31-14-99 bin]$ \/usr\/pgsql-14\/bin\/repmgr -f \/var\/lib\/pgsql\/repmgr.conf cluster show\nWARNING: the following problems were found in the configuration file:\n  parameter \"cluster\" is deprecated and will be ignored\n ID | Name  | Role    | Status    | Upstream | Location | Priority | Timeline | Connection string\n----+-------+---------+-----------+----------+----------+----------+----------+----------------------------------------------------------------\n 1  | node1 | primary | * running |          | default  | 100      | 1        | host=52.64.241.210 user=repmgr dbname=repmgr connect_timeout=2\n\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Error#2<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This is the basic error , we DBA&#8217;s deal with this on daily basis. &#8220;No Entries in pg_hba.conf&#8221; . I encountered this error while performing the Standby clone dry run operatiion.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;postgres@ip-172-31-7-43 ~]$ \/usr\/pgsql-14\/bin\/repmgr -h 52.64.241.210 -U repmgr -d repmgr -f \/var\/lib\/pgsql\/repmgr.conf standby clone --dry-run\n\nDETAIL:\nconnection to server at \"52.64.241.210\", port 5432 failed: FATAL:  no pg_hba.conf entry for replication connection from host \"13.210.66.27\", user \"repmgr\", no encryption\n\nERROR: connection to database failed\nDETAIL:\nconnection to server at \"52.64.241.210\", port 5432 failed: FATAL:  no pg_hba.conf entry for replication connection from host \"13.210.66.27\", user \"repmgr\", no encryption<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Solution<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">It clearly indicates that we need to make an entry in <code>pg_hba.conf<\/code> of <code>Primary<\/code> server. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd $PGDATA\nvi pg_hba.conf\nhost    replication     repmgr          {Standby1 IP}           md5\nhost    repmgr          repmgr          {Standby1 IP}           md5\n\n# We have to add details of all of the Standby nodes and the Witness node too, if applicable.<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Note : As we will clone the data from the Primary to both of the Standby nodes , there is no need to make these changes in the Standby nodes. But on the Witness mode , we need to enter the IP&#8217;s in <code>pg_hba.conf<\/code> file and change the parameters in <code>postgresql.conf<\/code> file . (For more details, refer to this <a href=\"https:\/\/test.opensource-db.in\/wp1\/setting-up-high-availability-with-repmgr\/\">post<\/a>)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Result<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;postgres@ip-172-31-7-43 ~]$ \/usr\/pgsql-14\/bin\/repmgr -h 52.64.241.210 -U repmgr -d repmgr -f \/var\/lib\/pgsql\/repmgr.conf standby clone --dry-run\n\nNOTICE: standby will attach to upstream node 1\nHINT: consider using the -c\/--fast-checkpoint option\nINFO: would execute:\n  pg_basebackup -l \"repmgr base backup\"  -D \/var\/lib\/pgsql\/14\/data -h 52.64.241.210 -p 5432 -U repmgr -X stream\nINFO: all prerequisites for \"standby clone\" are met<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Error#3<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">I had encountered this error when I was setting up the Witness node. It is possible that even after you have done an entry in <code>pg_hba.conf<\/code> file, you get the following error:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;postgres@ip-172-31-8-219 ~]$ \/usr\/pgsql-14\/bin\/repmgr -f \/var\/lib\/pgsql\/repmgr.conf witness register -h 52.64.241.210\nWARNING: the following problems were found in the configuration file:\n  parameter \"cluster\" is deprecated and will be ignored\nINFO: connecting to witness node \"node4\" (ID: 4)\nERROR: unable to connect to witness node \"node4\" (ID: 4)\nDETAIL:\nconnection to server at \"ec2-13-211-191-92.ap-southeast-2.compute.amazonaws.com\" (172.31.8.219), port 5432 failed: FATAL:  role \"repmgr\" is not permitted to log in\n\nHINT: the witness node must be running before it can be registered<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Solution<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Login to <code>psql<\/code> and check the attributes of the user<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;postgres@ip-172-31-8-219 ~]$ psql\npsql (14.11)\nType \"help\" for help.\npostgres=# \\du+\n\n                                          List of roles\n Role name |                         Attributes                         | Member of | Description\n-----------+------------------------------------------------------------+-----------+-------------\n postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}        |\n repmgr    | Superuser, Cannot login                                    | {}        |\n\n# It shows Role \"repmgr\" cannot login\n# Simply alter the role \npostgres=# ALTER ROLE repmgr LOGIN;\nALTER ROLE\npostgres=# \\du+\n                                          List of roles\n Role name |                         Attributes                         | Member of | Description\n-----------+------------------------------------------------------------+-----------+-------------\n postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}        |\n repmgr    | Superuser                                                  | {}        |\n <\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Result<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">After altering the role , retry registering the witness node.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;postgres@ip-172-31-8-219 ~]$ \/usr\/pgsql-14\/bin\/repmgr -f \/var\/lib\/pgsql\/repmgr.conf witness register -h 52.64.241.210\nWARNING: the following problems were found in the configuration file:\n  parameter \"cluster\" is deprecated and will be ignored\nINFO: connecting to witness node \"node4\" (ID: 4)\nINFO: connecting to primary node\nNOTICE: attempting to install extension \"repmgr\"\nNOTICE: \"repmgr\" extension successfully installed\nINFO: witness registration complete\nNOTICE: witness node \"node4\" (ID: 4) successfully registered<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In PostgreSQL replication setups, encountering errors is not uncommon, but with the right knowledge and troubleshooting steps, they can be resolved effectively. In this post, we have discussed some of the common errors encountered during the configuration of replication using repmgr. By understanding the root cause of these errors and implementing the provided solutions, administrators can ensure a smooth and reliable PostgreSQL replication setup, facilitating data redundancy and high availability for their applications. These might already be known to many of the experienced DBA&#8217;s, but can serve as a useful guide to novice PostgreSQL enthusiasts, and DBAs with less experience, and save precious time. If you have encountered any other with issues while building an PostgreSQL HA systems using repmgr, please feel free to comment below, and reach out to us. As always, we&#8217;re happy to help.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank you and Stay tuned&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Hey All Managing a PostgreSQL replication setup involves various challenges, especially when encountering errors during configuration. This blog post [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":5607,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[52,1,23],"tags":[],"class_list":["post-5597","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-customer-success","category-others","category-postgresql-14"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Troubleshooting PostgreSQL Replication Setup Errors with repmgr - OpenSource DB<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Troubleshooting PostgreSQL Replication Setup Errors with repmgr - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Introduction Hey All Managing a PostgreSQL replication setup involves various challenges, especially when encountering errors during configuration. This blog post [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/\" \/>\n<meta property=\"og:site_name\" content=\"OpenSource DB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-24T07:03:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-24T07:09:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"269\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Venkat Akhil\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:site\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Venkat Akhil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/\"},\"author\":{\"name\":\"Venkat Akhil\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\"},\"headline\":\"Troubleshooting PostgreSQL Replication Setup Errors with repmgr\",\"datePublished\":\"2024-04-24T07:03:02+00:00\",\"dateModified\":\"2024-04-24T07:09:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/\"},\"wordCount\":498,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png\",\"articleSection\":[\"Customer Success\",\"Others\",\"PostgreSQL 14\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/\",\"name\":\"Troubleshooting PostgreSQL Replication Setup Errors with repmgr - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png\",\"datePublished\":\"2024-04-24T07:03:02+00:00\",\"dateModified\":\"2024-04-24T07:09:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png\",\"width\":512,\"height\":269},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Troubleshooting PostgreSQL Replication Setup Errors with repmgr\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"name\":\"OpenSource DB\",\"description\":\"Your Trusted OpenSource Databases partner\",\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\",\"name\":\"OPENSOURCE DB PRIVATE LIMITED\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"width\":368,\"height\":120,\"caption\":\"OPENSOURCE DB PRIVATE LIMITED\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\",\"https:\/\/x.com\/opensource_db\",\"https:\/\/www.youtube.com\/channel\/UCmTI5h\",\"https:\/\/www.linkedin.com\/company\/opensource-db\",\"https:\/\/www.instagram.com\/opensource_db\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\",\"name\":\"Venkat Akhil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"caption\":\"Venkat Akhil\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Troubleshooting PostgreSQL Replication Setup Errors with repmgr - OpenSource DB","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Troubleshooting PostgreSQL Replication Setup Errors with repmgr - OpenSource DB","og_description":"Introduction Hey All Managing a PostgreSQL replication setup involves various challenges, especially when encountering errors during configuration. This blog post [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2024-04-24T07:03:02+00:00","article_modified_time":"2024-04-24T07:09:35+00:00","og_image":[{"width":512,"height":269,"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png","type":"image\/png"}],"author":"Venkat Akhil","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Venkat Akhil","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/"},"author":{"name":"Venkat Akhil","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328"},"headline":"Troubleshooting PostgreSQL Replication Setup Errors with repmgr","datePublished":"2024-04-24T07:03:02+00:00","dateModified":"2024-04-24T07:09:35+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/"},"wordCount":498,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png","articleSection":["Customer Success","Others","PostgreSQL 14"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/","url":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/","name":"Troubleshooting PostgreSQL Replication Setup Errors with repmgr - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png","datePublished":"2024-04-24T07:03:02+00:00","dateModified":"2024-04-24T07:09:35+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png","width":512,"height":269},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/troubleshooting-postgresql-replication-setup-errors-with-repmgr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"Troubleshooting PostgreSQL Replication Setup Errors with repmgr"}]},{"@type":"WebSite","@id":"https:\/\/test.opensource-db.in\/wp1\/#website","url":"https:\/\/test.opensource-db.in\/wp1\/","name":"OpenSource DB","description":"Your Trusted OpenSource Databases partner","publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/test.opensource-db.in\/wp1\/#organization","name":"OPENSOURCE DB PRIVATE LIMITED","url":"https:\/\/test.opensource-db.in\/wp1\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","width":368,"height":120,"caption":"OPENSOURCE DB PRIVATE LIMITED"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","https:\/\/x.com\/opensource_db","https:\/\/www.youtube.com\/channel\/UCmTI5h","https:\/\/www.linkedin.com\/company\/opensource-db","https:\/\/www.instagram.com\/opensource_db\/"]},{"@type":"Person","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328","name":"Venkat Akhil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","caption":"Venkat Akhil"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"}]}},"rttpg_featured_image_url":{"full":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png",512,269,false],"landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png",512,269,false],"portraits":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png",512,269,false],"thumbnail":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853-150x150.png",150,150,true],"medium":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853-300x158.png",300,158,true],"large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png",512,269,false],"1536x1536":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png",512,269,false],"2048x2048":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png",512,269,false],"ultp_layout_landscape_large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png",512,269,false],"ultp_layout_landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png",512,269,false],"ultp_layout_portrait":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png",512,269,false],"ultp_layout_square":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/04\/RR-1-e1713942090853.png",512,269,false]},"rttpg_author":{"display_name":"Venkat Akhil","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/business\/customer-success\/\" rel=\"category tag\">Customer Success<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/business\/others\/\" rel=\"category tag\">Others<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-14\/\" rel=\"category tag\">PostgreSQL 14<\/a>","rttpg_excerpt":"Introduction Hey All Managing a PostgreSQL replication setup involves various challenges, especially when encountering errors during configuration. This blog post [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/5597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=5597"}],"version-history":[{"count":3,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/5597\/revisions"}],"predecessor-version":[{"id":5602,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/5597\/revisions\/5602"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media\/5607"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=5597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=5597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=5597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}