{"id":243,"date":"2018-06-11T20:21:25","date_gmt":"2018-06-11T20:21:25","guid":{"rendered":"http:\/\/dbtut.com\/?p=243"},"modified":"2019-11-05T13:40:58","modified_gmt":"2019-11-05T13:40:58","slug":"how-to-install-postgresql-replication-on-centos","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/","title":{"rendered":"How To Install PostgreSQL Replication By using archive_command On Centos"},"content":{"rendered":"<p lang=\"en-US\">I will tell how to install PostgreSQL Replication by using archive_command parameter on centos in this article. But usually I prefer to install postgresql replication with slot method. To learn more about installing replication with slot method, read the below article.<\/p>\n<p lang=\"en-US\">&#8220;How To Install PostgreSQL Replication With Slots&#8221;,<\/p>\n<p lang=\"en-US\">&#8220;How To Failover and Failback PostgreSQL Replication&#8221;<\/p>\n<p lang=\"en-US\">You may want to read the below article to install PostgreSQL on Centos.<\/p>\n<p lang=\"en-US\">&#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<h1 lang=\"en-US\">Install PostgreSQL Replication by using archive_command<\/h1>\n<p>Switch to the postgres user with the command below and connect to postgres using the psql command.<\/p>\n<p><strong>On Master:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">su - postgres<\/pre>\n<p>Create a user named replicauser which will be connected to the master server for replica with the help of the following script.<\/p>\n<pre class=\"lang:default decode:true\">create user replicauser with replication encrypted password 'rp';<\/pre>\n<p>Edit pg_hba file on the master server to backup from the master server using the replicauser user on the standby server\u00a0 with the below command.<\/p>\n<pre class=\"lang:default decode:true \">vim \/postgres\/pg_data\/pg_hba.conf<\/pre>\n<p>Add the below line to pg_hba.conf. This will allow the standby server to connect to the master server for replication.<\/p>\n<p>192.168.1.29 -&gt; Standby IP<\/p>\n<pre class=\"lang:default decode:true\">host\u00a0\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 replicauser\u00a0\u00a0\u00a0\u00a0 192.168.1.29\/32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 trust<\/pre>\n<p>We also add a line to each server that contains the IP of the other server as follows so that the two servers can connect to each other. This line means that the related IP can connect to me with the specified user. I allow it.<\/p>\n<pre class=\"lang:default decode:true \">host\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 192.168.1.29\/32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 trust<\/pre>\n<p>Then run the following command while connected with the Postgres user so that the changes take effect.<\/p>\n<pre class=\"lang:default decode:true \">\/usr\/pgsql-10\/bin\/pg_ctl reload -D \/postgres\/pg_data<\/pre>\n<p>You can also do this with the following command while connected with root.<\/p>\n<pre class=\"lang:default decode:true\">systemctl reload postgresql-10.service<\/pre>\n<p>In the next step, we use the following command to set some parameters in the postgresql.conf file.<\/p>\n<pre class=\"lang:default decode:true\">vim \/postgres\/pg_data\/postgresql.conf<\/pre>\n<p>First, we set the value of listen_adress * as follows, and remove the leading # sign.<\/p>\n<pre class=\"lang:default decode:true\">listen_addresses = '*'<\/pre>\n<p>Our other settings are as follows;<\/p>\n<pre class=\"lang:default decode:true\">archive_mode = on\nwal_level=replika\nmax_wal_senders=2\nwal_keep_segments=256\narchive_command = '\/postgres\/waltransport.sh %p %f'<\/pre>\n<p>Then we use the following command to create waltransport.sh file.<\/p>\n<pre class=\"lang:default decode:true\">vim \/postgres\/waltransport.sh<\/pre>\n<p>Below you can see the contents of the waltransport.sh file.<\/p>\n<p>The IP below is the IP of the standby server.<\/p>\n<pre class=\"lang:default decode:true\">#!\/bin\/bash\nrsync -ave ssh $1 postgres@192.168.1.29:\/postgres\/xlogarchive\/$2<\/pre>\n<p>We make the owner of the waltransport file postgres user and grant necessary rights(700) by using chown and chmod.<\/p>\n<pre class=\"lang:default decode:true\">chown postgres:postgres \/postgres\/waltransport.sh \nchmod 700 \/postgres\/waltransport.sh<\/pre>\n<p>To create the standby, go to the standby server first and download the repo and install postgresql without initdb.<\/p>\n<p>Then, using the script below, we back up the master postgresql over the standby server.<\/p>\n<p>The following IP is the IP of the master server.<\/p>\n<p><strong>On Standby Server:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">\/usr\/pgsql-10\/bin\/pg_basebackup -D \/postgres\/pg_standby -c fast -P -Fp -h 192.168.1.28 -p 5432 -U replicauser<\/pre>\n<p>Then go to the &#8220;\/postgres\/pg_standby&#8221; path on the standby server and create the recovery.conf file. The contents of the recovery.conf shoul be as follows.<\/p>\n<p>The following IP is the IP of the standby server.<\/p>\n<pre class=\"lang:default decode:true\">standby_mode='on'\n\nprimary_conninfo='host=192.168.1.29 port=5432 user=replicauser password=rp'\n\nrestore_command='cp \/postgres\/xlogarchive\/ %f %p'\n\narchive_cleanup_command='\/usr\/pgsql-10\/bin\/pg_archivecleanup \/postgre\/xlogarchive %r'<\/pre>\n<p>Then start the standby service by showing the pg_standby folder and you will see that the replication starts without errors. Congratulations.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_243\" class=\"pvc_stats all  \" data-element-id=\"243\" 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>I will tell how to install PostgreSQL Replication by using archive_command parameter on centos in this article. But usually I prefer to install postgresql replication with slot method. To learn more about installing replication with slot method, read the below article. &#8220;How To Install PostgreSQL Replication With Slots&#8221;, &#8220;How To Failover and Failback PostgreSQL Replication&#8221; &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_243\" class=\"pvc_stats all  \" data-element-id=\"243\" 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":1,"featured_media":13407,"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":[233,226,222,207,206,213,196,203,204,205,5240,5239,224,208,219,234,209,201,194,195,200,202,193,199,220,231,221,232,228,229,210,211,230,198,212,197,214,218,216,215,217,225,223],"class_list":["post-243","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres","tag-archive_cleanup_command","tag-archive_command","tag-archive_mode","tag-chmod","tag-chown","tag-close-selinux-on-centos","tag-initdb","tag-install-postgres","tag-install-postgresql","tag-install-postgresql-replica","tag-install-postgresql-replication-by-using-archive_command","tag-install-postgresql-replication-by-using-archive_command-parameter","tag-max_wal_senders","tag-pg_data","tag-pg_hba-conf","tag-pg_standby","tag-posgresql-10-service","tag-postgres-installation","tag-postgres-replica","tag-postgres-replication","tag-postgres-service-status","tag-postgresql-installation","tag-postgresql-replication","tag-postgresql-service-status","tag-postgresql-conf","tag-primary_conninfo","tag-reload-postgresql","tag-restore_command","tag-she-bang","tag-shebang","tag-ssh-connectivity","tag-ssh-keygen-t-rsa","tag-standby_mode","tag-start-postgresql-service","tag-stop-firewall-on-centos","tag-systemctl","tag-systemctl-enable-postgresql","tag-systemctl-restart-postgresql","tag-systemctl-start-postgresql","tag-systemctl-status-postgresql","tag-systemctl-stop-postgresql","tag-wal_keep_segments","tag-wal_level"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Install PostgreSQL Replication By using archive_command On Centos - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Install PostgreSQL Replication On Centos\" \/>\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\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Install PostgreSQL Replication By using archive_command On Centos - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Install PostgreSQL Replication On Centos\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-11T20:21:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-05T13:40:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-23.png\" \/>\n\t<meta property=\"og:image:width\" content=\"466\" \/>\n\t<meta property=\"og:image:height\" content=\"327\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Install PostgreSQL Replication By using archive_command On Centos\",\"datePublished\":\"2018-06-11T20:21:25+00:00\",\"dateModified\":\"2019-11-05T13:40:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/\"},\"wordCount\":463,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-23.png\",\"keywords\":[\"archive_cleanup_command\",\"archive_command\",\"archive_mode\",\"chmod\",\"chown\",\"close selinux on centos\",\"initdb\",\"install postgres\",\"install postgresql\",\"install postgresql replica\",\"install PostgreSQL Replication by using archive_command\",\"install PostgreSQL Replication by using archive_command parameter\",\"max_wal_senders\",\"pg_data\",\"pg_hba.conf\",\"pg_standby\",\"posgresql-10.service\",\"postgres installation\",\"postgres replica\",\"postgres replication\",\"postgres service status\",\"postgresql installation\",\"PostgreSQL Replication\",\"postgresql service status\",\"postgresql.conf\",\"primary_conninfo\",\"reload postgresql\",\"restore_command\",\"she bang\",\"shebang\",\"ssh connectivity\",\"ssh-keygen -t rsa\",\"standby_mode\",\"start postgresql service\",\"stop firewall on centos\",\"systemctl\",\"systemctl enable postgresql\",\"systemctl restart postgresql\",\"systemctl start postgresql\",\"systemctl status postgresql\",\"systemctl stop postgresql\",\"wal_keep_segments\",\"wal_level\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/\",\"name\":\"How To Install PostgreSQL Replication By using archive_command On Centos - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-23.png\",\"datePublished\":\"2018-06-11T20:21:25+00:00\",\"dateModified\":\"2019-11-05T13:40:58+00:00\",\"description\":\"How To Install PostgreSQL Replication On Centos\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-23.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-23.png\",\"width\":466,\"height\":327},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Install PostgreSQL Replication By using archive_command On Centos\"}]},{\"@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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Install PostgreSQL Replication By using archive_command On Centos - Database Tutorials","description":"How To Install PostgreSQL Replication On Centos","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\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/","og_locale":"en_US","og_type":"article","og_title":"How To Install PostgreSQL Replication By using archive_command On Centos - Database Tutorials","og_description":"How To Install PostgreSQL Replication On Centos","og_url":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/","og_site_name":"Database Tutorials","article_published_time":"2018-06-11T20:21:25+00:00","article_modified_time":"2019-11-05T13:40:58+00:00","og_image":[{"width":466,"height":327,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-23.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Install PostgreSQL Replication By using archive_command On Centos","datePublished":"2018-06-11T20:21:25+00:00","dateModified":"2019-11-05T13:40:58+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/"},"wordCount":463,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-23.png","keywords":["archive_cleanup_command","archive_command","archive_mode","chmod","chown","close selinux on centos","initdb","install postgres","install postgresql","install postgresql replica","install PostgreSQL Replication by using archive_command","install PostgreSQL Replication by using archive_command parameter","max_wal_senders","pg_data","pg_hba.conf","pg_standby","posgresql-10.service","postgres installation","postgres replica","postgres replication","postgres service status","postgresql installation","PostgreSQL Replication","postgresql service status","postgresql.conf","primary_conninfo","reload postgresql","restore_command","she bang","shebang","ssh connectivity","ssh-keygen -t rsa","standby_mode","start postgresql service","stop firewall on centos","systemctl","systemctl enable postgresql","systemctl restart postgresql","systemctl start postgresql","systemctl status postgresql","systemctl stop postgresql","wal_keep_segments","wal_level"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/","url":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/","name":"How To Install PostgreSQL Replication By using archive_command On Centos - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-23.png","datePublished":"2018-06-11T20:21:25+00:00","dateModified":"2019-11-05T13:40:58+00:00","description":"How To Install PostgreSQL Replication On Centos","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-23.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-23.png","width":466,"height":327},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/11\/how-to-install-postgresql-replication-on-centos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Install PostgreSQL Replication By using archive_command On Centos"}]},{"@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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/243","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=243"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/243\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13407"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}