{"id":2776,"date":"2025-12-11T02:15:10","date_gmt":"2023-06-06T14:14:43","guid":{"rendered":""},"modified":"2025-07-28T17:56:04","modified_gmt":"2025-07-28T16:56:04","slug":"how-to-set-up-postgresql-replication-on-debian-11-2","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/how-to-set-up-postgresql-replication-on-debian-11-2\/","title":{"rendered":"How to Set up PostgreSQL Replication on Debian 11"},"content":{"rendered":"<p>&nbsp;<\/p>\n<header>\n<h1><\/h1>\n<\/header>\n<article>\n<section>\n<h2>Introduction<\/h2>\n<p>PostgreSQL is a powerful, open-source object-relational database system that offers advanced features for database management. Setting up replication is essential for ensuring high availability and load balancing. In this guide, we will walk you through the process of setting up PostgreSQL replication on Debian 11, which can be effectively utilized with for enhanced performance.<\/p>\n<\/section>\n<section>\n<h2>Prerequisites<\/h2>\n<ul>\n<li>Debian 11 installed on your server<\/li>\n<li>PostgreSQL installed<\/li>\n<li>Two servers for primary and secondary databases<\/li>\n<li>Basic understanding of command-line operations<\/li>\n<\/ul>\n<\/section>\n<section>\n<h2>Step 1: Configure the Primary Server<\/h2>\n<p>Start by editing the PostgreSQL configuration file on the primary server. Open the <code>postgresql.conf<\/code> file using your preferred text editor:<\/p>\n<pre><code>sudo nano \/etc\/postgresql\/13\/main\/postgresql.conf<\/code><\/pre>\n<p>Locate the following settings and modify them:<\/p>\n<pre><code>wal_level = replica\r\narchive_mode = on\r\narchive_command = 'test ! -f \/var\/lib\/postgresql\/wal_archive\/%f &amp;&amp; cp %p \/var\/lib\/postgresql\/wal_archive\/%f'\r\nmax_wal_senders = 3\r\n<\/code><\/pre>\n<p>After saving your changes, restart PostgreSQL:<\/p>\n<pre><code>sudo systemctl restart postgresql<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 2: Configure the Secondary Server<\/h2>\n<p>Next, set up the secondary server to replicate from the primary server. First, create a base backup using the following command:<\/p>\n<pre><code>pg_basebackup -h primary_server_ip -D \/var\/lib\/postgresql\/13\/main -U replication_user -P --wal-method=stream<\/code><\/pre>\n<p>Replace <code>primary_server_ip<\/code> with the actual IP address of your primary server. Once the backup is complete, configure the secondary server by creating a <code>recovery.conf<\/code> file:<\/p>\n<pre><code>sudo nano \/var\/lib\/postgresql\/13\/main\/recovery.conf<\/code><\/pre>\n<p>In this file, add the following lines:<\/p>\n<pre><code>standby_mode = 'on'\r\nprimary_conninfo = 'host=primary_server_ip port=5432 user=replication_user password=your_password'\r\ntrigger_file = '\/tmp\/postgresql.trigger.5432'\r\n<\/code><\/pre>\n<p>Finally, restart the PostgreSQL service on the secondary server:<\/p>\n<pre><code>sudo systemctl restart postgresql<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 3: Verify Replication<\/h2>\n<p>To verify that replication is working, you can check the replication status on the primary server:<\/p>\n<pre><code>SELECT * FROM pg_stat_replication;<\/code><\/pre>\n<p>You should see the status of the connected secondary server. If you\u2019re using a , ensure that the necessary ports are open in your firewall settings.<\/p>\n<\/section>\n<section>\n<h2>Conclusion<\/h2>\n<p>Setting up PostgreSQL replication on Debian 11 is a straightforward process that enhances your database&#8217;s reliability and performance. This setup can be particularly beneficial for those using <a href=\"https:\/\/ie.netcloud24.com\">UK Windows VPS<\/a> solutions. For more information on server hosting options, including <a href=\"https:\/\/ie.netcloud24.com\">Windows VPS Virtual Private Server Hosting<\/a>, consider exploring various providers for your needs. Establishing PostgreSQL replication on Debian 11 is a systematic procedure that elevates the dependability and efficiency of your database. This configuration can be especially advantageous for individuals utilising UK Windows VPS services. For further details on server hosting alternatives, such as Windows VPS Virtual Private Server Hosting, we recommend examining different providers to accommodate your requirements.<\/p>\n<\/section>\n<\/article>\n<footer>\u00a9 2024 PostgreSQL Tutorial. All rights reserved.<\/p>\n<\/footer>\n<div class=\"post-author-box\" style=\"border-top:1px solid #ddd;margin-top:20px;padding-top:15px;\">\n<p><strong>Author:<\/strong> \u0141ukasz Bodziony<\/p>\n<p><strong>Website:<\/strong> <a href=\"https:\/\/ca.netcloud24.com\" target=\"_blank\" rel=\"dofollow\">Windows VPS<\/a><\/p>\n<p><em>\u0141ukasz Bodziony is the CEO and founder of <a href=\"https:\/\/netcloud24.com\" target=\"_blank\" rel=\"dofollow\">NETCLOUD24<\/a>, a global VPS hosting brand proudly originating from Poland. With extensive experience in cloud computing, virtualization, and server management, he delivers high-performance <strong>Windows VPS<\/strong> and <strong>Remote Desktop Services (RDS)<\/strong> solutions to clients across Europe, North America, and beyond.<\/em><\/p>\n<p><em>His expertise covers a wide range of technologies, including <strong>Microsoft Azure<\/strong>, <strong>Proxmox VE<\/strong>, <strong>Amazon Web Services (AWS)<\/strong>, and numerous other virtualization and cloud platforms.<\/em><\/p>\n<p><em>Beyond running his hosting business, \u0141ukasz also provides <strong>professional paid server configuration and optimization services<\/strong> for companies and individuals. Outside of work, he is dedicated to caring for his children and building a secure future for them.<\/em><\/p>\n<p><em>If you are interested in working with him or need expert assistance with your hosting, cloud environment, or server setup, feel free to reach out via <a href=\"https:\/\/ca.netcloud24.com\" target=\"_blank\" rel=\"dofollow\">Windows VPS<\/a>.<\/em><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Introduction PostgreSQL is a powerful, open-source object-relational database system that offers advanced features for database management. Setting up replication is essential for ensuring high availability and load\u2026<\/p>\n","protected":false},"author":1,"featured_media":3421,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[14,12,11,23,20,21,22,17,7,8,6,10,18,19,15,24,16,5,13,9],"class_list":["post-2776","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","tag-cheapvps","tag-cloudvps","tag-hostingvps","tag-rds","tag-rdscal","tag-remotedesktop","tag-remotedesktopvps","tag-servervps","tag-ukvps","tag-virtualserver","tag-vpshosting","tag-vpsserver","tag-vpssolutions","tag-vpswindows","tag-vpswithwindows","tag-windowsrds","tag-windowsserver","tag-windowsvps","tag-windowsvpshosting","tag-windowsvpsuk"],"jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/2776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=2776"}],"version-history":[{"count":1,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/2776\/revisions"}],"predecessor-version":[{"id":3551,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/2776\/revisions\/3551"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media\/3421"}],"wp:attachment":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=2776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=2776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=2776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}