{"id":13409,"date":"2019-11-05T14:33:24","date_gmt":"2019-11-05T14:33:24","guid":{"rendered":"https:\/\/dbtut.com\/?p=13409"},"modified":"2019-11-06T14:46:33","modified_gmt":"2019-11-06T14:46:33","slug":"how-to-install-postgresql-replication-with-replication-slots","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/","title":{"rendered":"How To Install PostgreSQL Replication With Replication Slots"},"content":{"rendered":"

First of all, we must install PostgreSQL on Primary Server and perform initdb operations. You can find out how to do this in the article “How To Install PostgreSQL On centos\/redhat<\/a>“.<\/p>\n

On the Primary Server:<\/strong><\/p>\n

Switch to the postgres user with the su postgres<\/code> command and connect to the primary server with the psql -h primaryserverip<\/code> command.<\/p>\n

Then run the following commands:<\/p>\n

create role replication login replication;\nselect pg_create_physical_replication_slot('yoursecondaryservername');\nALTER SYSTEM SET synchronous_standby_names TO 'yoursecondaryservername';<\/pre>\n
Edit the pg_hba.conf file by using the vi command in the directory where we installed PostgreSQL and update it as follows.<\/p>\n
Note:<\/strong> If there is a record at the top in the pg_hba.conf file, it does not care for the values at the bottom. So make sure these changes are at the top.<\/p>\n
host\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0primaryserverip\/32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0trust\nhost\u00a0\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 secondaryserverip\/32\u00a0\u00a0\u00a0 trust<\/pre>\n
We then transfer our data to the secondary server using the base backup method. We need to run the following command on the secondary server.<\/p>\n
On the Secondary Server w<\/strong>ith postgres user:<\/strong><\/p>\n
pg_basebackup --pgdata=\/yourdatadirectory \\\n\u00a0\u00a0\u00a0\u00a0\u00a0 --waldir=\/yourwaldirectory \\\n\u00a0\u00a0\u00a0\u00a0\u00a0 --write-recovery-conf --wal-method=stream \\\n\u00a0\u00a0\u00a0\u00a0\u00a0 --checkpoint=fast \\\n\u00a0\u00a0\u00a0\u00a0\u00a0 --progress --verbose\\\n\u00a0\u00a0\u00a0\u00a0\u00a0 --slot=yoursecondaryservername \\\n\u00a0\u00a0\u00a0\u00a0\u00a0 --host=yourprimaryserverip \\\n\u00a0\u00a0\u00a0\u00a0\u00a0 --port=5432 \\\n\u00a0\u00a0\u00a0\u00a0\u00a0 --username=replication<\/pre>\n
Configure recovery.conf<\/h2>\n
After running pg_basebackup, we update the recovery.conf under the data directory with vi command and update it as follows. Do not copy and paste this file as it is. You will only add the following two lines to the relevant sections.<\/p>\n
Note:<\/strong> The recovery.conf file was removed along with postgresql 12. If recovery.conf is present in the data directory, you cannot start postgresql.<\/p>\n
application_name=synchronous_standby_name_you_set_on_primary_server\ntrigger_file='\/dbwhite\/dbats\/promotdbats.data'<\/pre>\n
The final version should be as follows:<\/p>\n
standby_mode = 'on'\nprimary_conninfo = 'user=replication passfile=''\/var\/lib\/pgsql\/.pgpass'' host=yourprimaryserverip port=5432 sslmode=prefer sslcompression=0 krbsrvname=postgres target_session_attrs=any application_name='synchronous_standby_name_you_set_on_primary_server'\nprimary_slot_name = 'yoursecondaryservername'\ntrigger_file='\/dbwhite\/dbats\/promotdbats.data'<\/pre>\n
Note:<\/strong> With PostgreSQL 12, standby_mode = ‘on’ no longer exists and PostgreSQL writes other information in the recovery.conf to postgresql.auto.conf. Also trigger_file’s name changed to promote_trigger_file.<\/p>\n
Then go to postgresql.conf and change the ip. Because basebackup copy postgresql.conf from primary server. Therefore we must change IP information on postgresql.conf. \u0130f its localhost do not change.<\/p>\n
Change pg_hba.con on the Secondary Server<\/h3>\n
Then we change the pg_hba on the secondary server as follows. If we perform failover, these settings will be needed.<\/p>\n
host\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0primaryserverip\/32\u00a0\u00a0\u00a0\u00a0trust\nhost\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0secondaryserverip\/32\u00a0\u00a0trust\nhost\u00a0\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 primaryserverip\/32\u00a0\u00a0\u00a0 trust\n<\/pre>\n
Note:<\/strong> After this change, you must restart or reload the postgresql on the secondary server.<\/p>\n
Then start postgresql service on secondary server.<\/p>\n
systemctl start postgresql-11<\/pre>\n
Then go to primary server and connect postgresql and execute the below command to check replication start succesfully.<\/p>\n
On Primary Server:<\/strong><\/p>\n
\\x\nselect * from pg_stat_replication;<\/pre>\n
\"\"<\/p>\n
As you can see, replication works asynchronously. You can synchronize replication by running the following command on the primary server.<\/p>\n
On Primary Server:<\/strong><\/p>\n
ALTER SYSTEM SET synchronous_commit TO 'remote_write';<\/pre>\n
\"\"<\/p>\n
Check PostgreSQL Replication Status<\/h3>\n
Then run the following command and check the replication status again. As you can see, replication has become synchronous.<\/p>\n
select pg_reload_conf();<\/pre>\n
\"\"<\/p>\n
You may want to do a failover test. You can read the article “How To Failover and Failback PostgreSQL Replication<\/a>” to do a failover test.<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
First of all, we must install PostgreSQL on Primary Server and perform initdb operations. You can find out how to do this in the article “How To Install PostgreSQL On centos\/redhat“. On the Primary Server: Switch to the postgres user with the su postgres command and connect to the primary server with the psql -h …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":13419,"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":[5247,5245,5246,5241,5248,4896,5249,5242,5243,5251,5254,5258,5280,221,5244,5253,5257,5250,5256,5255,5252],"class_list":["post-13409","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres","tag-check-postgresql-replication-status","tag-check-replication-status","tag-check-replication-status-on-postgresql","tag-configure-recovery-conf","tag-create-postgresql-replication-with-replication-slots","tag-create-postgresql-repository","tag-install-postgresql-replication-with-replication-slots","tag-pg_basebackup","tag-pg_reload_conf","tag-pg_stat_replication","tag-postgresql-replication-slots","tag-postgresql-replication-with-replication-slots","tag-promote_trigger_file","tag-reload-postgresql","tag-reload-postgresql-with-pl-pgsql","tag-replication-slots","tag-replication-slots-in-postgresql","tag-setup-postgresql-replication-with-replication-slots","tag-streaming-replication-slots","tag-streaming-replication-slots-in-postgresql","tag-what-is-replication-slot"],"aioseo_notices":[],"yoast_head":"\nHow To Install PostgreSQL Replication With Replication Slots - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Install PostgreSQL Replication With Slots\" \/>\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\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/\" \/>\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 With Replication Slots - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Install PostgreSQL Replication With Slots\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-05T14:33:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-06T14:46:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"467\" \/>\n\t<meta property=\"og:image:height\" content=\"288\" \/>\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\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Install PostgreSQL Replication With Replication Slots\",\"datePublished\":\"2019-11-05T14:33:24+00:00\",\"dateModified\":\"2019-11-06T14:46:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/\"},\"wordCount\":441,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-3.png\",\"keywords\":[\"Check postgresql replication status\",\"check replication status\",\"Check Replication Status on Postgresql\",\"Configure recovery.conf\",\"Create postgresql replication with replication slots\",\"Create PostgreSQL Repository\",\"install postgresql replication with replication slots\",\"pg_basebackup\",\"pg_reload_conf()\",\"pg_stat_replication\",\"PostgreSQL Replication Slots\",\"postgresql replication with replication slots\",\"promote_trigger_file\",\"reload postgresql\",\"reload postgresql with pl\/pgsql\",\"replication slots\",\"Replication slots in Postgresql\",\"setup postgresql replication with replication slots\",\"Streaming replication slots\",\"Streaming replication slots in PostgreSQL\",\"What is replication slot?\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/\",\"name\":\"How To Install PostgreSQL Replication With Replication Slots - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-3.png\",\"datePublished\":\"2019-11-05T14:33:24+00:00\",\"dateModified\":\"2019-11-06T14:46:33+00:00\",\"description\":\"How To Install PostgreSQL Replication With Slots\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-3.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-3.png\",\"width\":467,\"height\":288},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Install PostgreSQL Replication With Replication Slots\"}]},{\"@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 With Replication Slots - Database Tutorials","description":"How To Install PostgreSQL Replication With Slots","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\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/","og_locale":"en_US","og_type":"article","og_title":"How To Install PostgreSQL Replication With Replication Slots - Database Tutorials","og_description":"How To Install PostgreSQL Replication With Slots","og_url":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/","og_site_name":"Database Tutorials","article_published_time":"2019-11-05T14:33:24+00:00","article_modified_time":"2019-11-06T14:46:33+00:00","og_image":[{"width":467,"height":288,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-3.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\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Install PostgreSQL Replication With Replication Slots","datePublished":"2019-11-05T14:33:24+00:00","dateModified":"2019-11-06T14:46:33+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/"},"wordCount":441,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-3.png","keywords":["Check postgresql replication status","check replication status","Check Replication Status on Postgresql","Configure recovery.conf","Create postgresql replication with replication slots","Create PostgreSQL Repository","install postgresql replication with replication slots","pg_basebackup","pg_reload_conf()","pg_stat_replication","PostgreSQL Replication Slots","postgresql replication with replication slots","promote_trigger_file","reload postgresql","reload postgresql with pl\/pgsql","replication slots","Replication slots in Postgresql","setup postgresql replication with replication slots","Streaming replication slots","Streaming replication slots in PostgreSQL","What is replication slot?"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/","url":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/","name":"How To Install PostgreSQL Replication With Replication Slots - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-3.png","datePublished":"2019-11-05T14:33:24+00:00","dateModified":"2019-11-06T14:46:33+00:00","description":"How To Install PostgreSQL Replication With Slots","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-3.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-3.png","width":467,"height":288},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/05\/how-to-install-postgresql-replication-with-replication-slots\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Install PostgreSQL Replication With Replication Slots"}]},{"@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\/13409","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=13409"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13409\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13419"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}