{"id":15294,"date":"2020-03-10T07:15:57","date_gmt":"2020-03-10T07:15:57","guid":{"rendered":"https:\/\/dbtut.com\/?p=15294"},"modified":"2020-03-10T09:08:10","modified_gmt":"2020-03-10T09:08:10","slug":"repmgr-installation-and-configuration-for-postgresql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/","title":{"rendered":"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL"},"content":{"rendered":"<p style=\"font-weight: 400;\">We will perform REPMGR installation and configuration for postgresql in this article. You can see our environments. pg is our primary postgresql cluster and the others are our standbys<\/p>\n<table style=\"width: 100%; height: 96px;\" width=\"200\">\n<tbody>\n<tr style=\"height: 24px;\">\n<td style=\"height: 24px;\"><strong>Machine<\/strong><\/td>\n<td style=\"height: 24px;\"><strong>IP<\/strong><\/td>\n<td style=\"height: 24px;\"><strong>ROLE<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"height: 24px;\">pg<\/td>\n<td style=\"height: 24px;\">10.0.0.4<\/td>\n<td style=\"height: 24px;\">Primary<\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"height: 24px;\">pgrep<\/td>\n<td style=\"height: 24px;\">10.0.0.5<\/td>\n<td style=\"height: 24px;\">Replication<\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"height: 24px;\">Pgrep2<\/td>\n<td style=\"height: 24px;\">10.0.0.6<\/td>\n<td style=\"height: 24px;\">Replication2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"font-weight: 400;\"><strong>Pre Request:<\/strong><\/p>\n<ul style=\"font-weight: 400;\">\n<li>PostgreSQL must be installed in Primary and Standbys..<\/li>\n<li>Replication must be configured for this environment.<\/li>\n<\/ul>\n<p>You may want to read below articles to install PostgreSQL and configure replication.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/15\/how-to-install-postgresql-on-centos-redhat\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Install PostgreSQL On centos\/redhat<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Install PostgreSQL Replication By using archive_command On Centos<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/10\/16\/how-to-create-postgresql-repository-to-install-postgres-without-internet\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create PostgreSQL Repository To Install Postgres Without Internet<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Install PostgreSQL Replication With Replication Slots<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/11\/07\/how-to-install-streaming-replication-in-postgresql-12\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Install Streaming Replication in PostgreSQL 12<\/a>&#8221;<\/p>\n<h3>Install REPMGR<\/h3>\n<p>We are installing repmgr12 in all postgresql database machine.<\/p>\n<pre class=\"lang:default decode:true\">sudo yum install repmgr12<\/pre>\n<p style=\"font-weight: 400;\">We are executing below command in Primary Node.<\/p>\n<pre class=\"lang:default decode:true\">-bash-4.2$ psql\n\npsql (12.2)\n\nType \"help\" for help.\n\npostgres=# createuser --superuser repmgr\n\n-bash-4.2$ createdb --owner=repmgr repmgr\n\n-bash-4.2$ psql -c \"ALTER USER repmgr SET search_path TO repmgr, public;\"\n\nALTER ROLE<\/pre>\n<p>We are changing below parameter in postgresql.conf file.<\/p>\n<pre class=\"lang:default decode:true\">shared_preload_libraries = 'repmgr'<\/pre>\n<p>We are changing below parameters in \/etc\/repmgr\/12\/repmgr.conf file in primary server.<\/p>\n<p style=\"font-weight: 400;\"><strong>For Primary:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">node_id=1\n\nnode_name='PG-Node1'\n\nconninfo='host=10.0.0.4 user=repmgr dbname=repmgr connect_timeout=2'\n\ndata_directory='\/var\/lib\/pgsql\/12\/data'<\/pre>\n<p style=\"font-weight: 400;\">We are changing below parameters in \/etc\/repmgr\/12\/repmgr.conf file in standby server.<\/p>\n<p style=\"font-weight: 400;\"><strong>For Replication:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">node_id=2\n\nnode_name='PG-Node2'\n\nconninfo='host=10.0.0.5 user=repmgr dbname=repmgr\n\nconnect_timeout=2'\n\ndata_directory='\/var\/lib\/pgsql\/12\/data'<\/pre>\n<p style=\"font-weight: 400;\">We are changing below parameters in \/etc\/repmgr\/12\/repmgr.conf file in standby2 server.<\/p>\n<p style=\"font-weight: 400;\"><strong>For Replication2:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">node_id=3\n\nnode_name='PG-Node3'\n\nconninfo='host=10.0.0.6 user=repmgr dbname=repmgr\n\nconnect_timeout=2'\n\ndata_directory='\/var\/lib\/pgsql\/12\/data'<\/pre>\n<p style=\"font-weight: 400;\">We are adding below all line in pg_hba.conf file in all postgresql database machine. And also restart all database service. (if you must change 10.0.0.0 ip addreses because your machines ip can be different.)<\/p>\n<pre class=\"lang:default decode:true\">local\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 repmgr\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 trust\n\nhost\u00a0\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 repmgr\u00a0\u00a0\u00a0\u00a0\u00a0 127.0.0.1\/32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5\n\nhost\u00a0\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 repmgr\u00a0\u00a0\u00a0\u00a0\u00a0 10.0.0.0\/16\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5\n\nlocal\u00a0\u00a0 repmgr\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 repmgr\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 trust\n\nhost\u00a0\u00a0\u00a0 repmgr\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 repmgr\u00a0\u00a0\u00a0\u00a0\u00a0 127.0.0.1\/32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5\n\nhost\u00a0\u00a0\u00a0 repmgr\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 repmgr\u00a0\u00a0\u00a0\u00a0\u00a0 10.0.0.0\/16\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5<\/pre>\n<p style=\"font-weight: 400;\">We are testing below commands in standby and standby2 machine.<\/p>\n<pre class=\"lang:default decode:true\">-bash-4.2$ psql 'host=10.0.0.4 user=repmgr dbname=repmgr connect_timeout=2'\n\npsql (12.2)\n\nType \"help\" for help.\n\nrepmgr=#<\/pre>\n<p style=\"font-weight: 400;\">We are registering below commands in \u00a0primary node.<\/p>\n<pre class=\"lang:default decode:true\">-bash-4.2$ \/usr\/pgsql-12\/bin\/repmgr -f \/etc\/repmgr\/12\/repmgr.conf primary register\n\nINFO: connecting to primary database...\n\nNOTICE: attempting to install extension \"repmgr\"\n\nNOTICE: \"repmgr\" extension successfully installed\n\nNOTICE: primary node record (ID: 1) registered<\/pre>\n<p style=\"font-weight: 400;\">We are registering below command in standby servers.<\/p>\n<pre class=\"lang:default decode:true\">-bash-4.2$ \/usr\/pgsql-12\/bin\/repmgr standby register -F\n\nINFO: connecting to local node \"PG-Node2\" (ID: 2)\n\nINFO: connecting to primary database\n\nWARNING: --upstream-node-id not supplied, assuming upstream node is primary (node ID 1)\n\nWARNING: local node not attached to primary node 1\n\nNOTICE: -F\/--force supplied, continuing anyway\n\nINFO: standby registration complete\n\nNOTICE: standby node \"PG-Node2\" (ID: 2) successfully registered<\/pre>\n<p style=\"font-weight: 400;\">We are checking registration status below command in primary machine.<\/p>\n<pre class=\"lang:default decode:true\">-bash-4.2$ \/usr\/pgsql-12\/bin\/repmgr -f \/etc\/repmgr\/12\/repmgr.conf cluster show<\/pre>\n<p style=\"font-weight: 400;\">If you want you will look replication information in primary machine.<\/p>\n<pre class=\"lang:default decode:true\">select * from pg_stat_replication;<\/pre>\n<p style=\"font-weight: 400;\">Best Regards<\/p>\n<p style=\"font-weight: 400;\">Engin YILMAZ.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15294\" class=\"pvc_stats all  \" data-element-id=\"15294\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>We will perform REPMGR installation and configuration for postgresql in this article. You can see our environments. pg is our primary postgresql cluster and the others are our standbys Machine IP ROLE pg 10.0.0.4 Primary pgrep 10.0.0.5 Replication Pgrep2 10.0.0.6 Replication2 Pre Request: PostgreSQL must be installed in Primary and Standbys.. Replication must be configured &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15294\" class=\"pvc_stats all  \" data-element-id=\"15294\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":316,"featured_media":15300,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[9030,9029,9028,9024,9026,9025,9027,9034,112,9022,9033,9031,9023,9035,9032,9036],"class_list":["post-15294","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres","tag-config-repmgr","tag-configuration-repmgr","tag-configure-repmgr","tag-install-postgresql-repmgr","tag-install-repmgr-centos","tag-install-repmgr-centos-7","tag-install-repmgr-postgres","tag-postgres-repmgr-setup","tag-postgresql","tag-repmgr","tag-repmgr-conf-file","tag-repmgr-config-file","tag-repmgr-installation","tag-repmgr-setup","tag-repmgr-conf-log-file","tag-setup-a-postgresql-cluster-with-repmgr"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":3266,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-10T07:15:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-10T09:08:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-14.png\" \/>\n\t<meta property=\"og:image:width\" content=\"542\" \/>\n\t<meta property=\"og:image:height\" content=\"332\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Engin Yilmaz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Engin Yilmaz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/\"},\"author\":{\"name\":\"Engin Yilmaz\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/b1a386d05873bd038726ab40496e458a\"},\"headline\":\"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL\",\"datePublished\":\"2020-03-10T07:15:57+00:00\",\"dateModified\":\"2020-03-10T09:08:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/\"},\"wordCount\":287,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-14.png\",\"keywords\":[\"config repmgr\",\"configuration repmgr\",\"configure repmgr\",\"install postgresql repmgr\",\"install repmgr centos\",\"install repmgr centos 7\",\"install repmgr postgres\",\"postgres repmgr setup\",\"postgresql\",\"repmgr\",\"repmgr conf file\",\"repmgr config file\",\"repmgr installation\",\"repmgr setup\",\"repmgr.conf log file\",\"setup a postgresql cluster with repmgr\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/\",\"name\":\"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-14.png\",\"datePublished\":\"2020-03-10T07:15:57+00:00\",\"dateModified\":\"2020-03-10T09:08:10+00:00\",\"description\":\"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-14.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-14.png\",\"width\":542,\"height\":332},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/b1a386d05873bd038726ab40496e458a\",\"name\":\"Engin Yilmaz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1beca465a583c4518bafb41d560f2c385f15b4c6810b4c396204e58fb07520ea?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1beca465a583c4518bafb41d560f2c385f15b4c6810b4c396204e58fb07520ea?s=96&d=mm&r=g\",\"caption\":\"Engin Yilmaz\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/enginyilmaz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL - Database Tutorials","description":"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL","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:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL - Database Tutorials","og_description":"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL","og_url":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/","og_site_name":"Database Tutorials","article_published_time":"2020-03-10T07:15:57+00:00","article_modified_time":"2020-03-10T09:08:10+00:00","og_image":[{"width":542,"height":332,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-14.png","type":"image\/png"}],"author":"Engin Yilmaz","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Engin Yilmaz","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/"},"author":{"name":"Engin Yilmaz","@id":"https:\/\/dbtut.com\/#\/schema\/person\/b1a386d05873bd038726ab40496e458a"},"headline":"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL","datePublished":"2020-03-10T07:15:57+00:00","dateModified":"2020-03-10T09:08:10+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/"},"wordCount":287,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-14.png","keywords":["config repmgr","configuration repmgr","configure repmgr","install postgresql repmgr","install repmgr centos","install repmgr centos 7","install repmgr postgres","postgres repmgr setup","postgresql","repmgr","repmgr conf file","repmgr config file","repmgr installation","repmgr setup","repmgr.conf log file","setup a postgresql cluster with repmgr"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/","url":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/","name":"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-14.png","datePublished":"2020-03-10T07:15:57+00:00","dateModified":"2020-03-10T09:08:10+00:00","description":"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-14.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z-14.png","width":542,"height":332},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/10\/repmgr-installation-and-configuration-for-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/b1a386d05873bd038726ab40496e458a","name":"Engin Yilmaz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1beca465a583c4518bafb41d560f2c385f15b4c6810b4c396204e58fb07520ea?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1beca465a583c4518bafb41d560f2c385f15b4c6810b4c396204e58fb07520ea?s=96&d=mm&r=g","caption":"Engin Yilmaz"},"url":"https:\/\/dbtut.com\/index.php\/author\/enginyilmaz\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/316"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=15294"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15294\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/15300"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=15294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=15294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=15294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}