{"id":6321,"date":"2026-05-07T11:00:14","date_gmt":"2026-05-07T07:30:14","guid":{"rendered":"https:\/\/parmin.cloud\/blog\/?p=6321"},"modified":"2026-05-07T11:00:14","modified_gmt":"2026-05-07T07:30:14","slug":"%d8%b1%d8%a7%d9%87%d8%a7%d9%86%d8%af%d8%a7%d8%b2%db%8c-physical-streaming-replication-%d8%af%d8%b1-postgresql-12-%d8%b1%d9%88%db%8c-ubuntu-20-04","status":"publish","type":"post","link":"https:\/\/parmin.cloud\/blog\/%d8%b1%d8%a7%d9%87%d8%a7%d9%86%d8%af%d8%a7%d8%b2%db%8c-physical-streaming-replication-%d8%af%d8%b1-postgresql-12-%d8%b1%d9%88%db%8c-ubuntu-20-04\/","title":{"rendered":"\u0631\u0627\u0647\u200c\u0627\u0646\u062f\u0627\u0632\u06cc Physical Streaming Replication \u062f\u0631 PostgreSQL 12 \u0631\u0648\u06cc Ubuntu 20.04"},"content":{"rendered":"<section class=\"text-token-text-primary w-full focus:outline-none [--shadow-height:45px] has-data-writing-block:pointer-events-none has-data-writing-block:-mt-(--shadow-height) has-data-writing-block:pt-(--shadow-height) [&amp;:has([data-writing-block])&gt;*]:pointer-events-auto [content-visibility:auto] supports-[content-visibility:auto]:[contain-intrinsic-size:auto_100lvh] R6Vx5W_threadScrollVars scroll-mb-[calc(var(--scroll-root-safe-area-inset-bottom,0px)+var(--thread-response-height))] scroll-mt-[calc(var(--header-height)+min(200px,max(70px,20svh)))]\" dir=\"auto\" data-turn-id=\"request-697f4abe-c9d4-8330-acaa-80c7a68e53b3-0\" data-testid=\"conversation-turn-222\" data-scroll-anchor=\"false\" data-turn=\"assistant\">\n<div class=\"text-base my-auto mx-auto pb-10 [--thread-content-margin:var(--thread-content-margin-xs,calc(var(--spacing)*4))] @w-sm\/main:[--thread-content-margin:var(--thread-content-margin-sm,calc(var(--spacing)*6))] @w-lg\/main:[--thread-content-margin:var(--thread-content-margin-lg,calc(var(--spacing)*16))] px-(--thread-content-margin)\">\n<div class=\"[--thread-content-max-width:40rem] @w-lg\/main:[--thread-content-max-width:48rem] mx-auto max-w-(--thread-content-max-width) flex-1 group\/turn-messages focus-visible:outline-hidden relative flex w-full min-w-0 flex-col agent-turn\">\n<div class=\"flex max-w-full flex-col gap-4 grow\">\n<div class=\"min-h-8 text-message relative flex w-full flex-col items-end gap-2 text-start break-words whitespace-normal outline-none keyboard-focused:focus-ring [.text-message+&amp;]:mt-1\" dir=\"auto\" data-message-author-role=\"assistant\" data-message-id=\"071a7a8c-7c37-4312-83e8-fbf876e21cb2\" data-message-model-slug=\"gpt-5-5\" data-turn-start-message=\"true\">\n<div class=\"flex w-full flex-col gap-1 empty:hidden\">\n<div class=\"markdown prose dark:prose-invert wrap-break-word w-full light markdown-new-styling\">\n<h3 data-section-id=\"105t4uk\" data-start=\"80\" data-end=\"89\">\u0645\u0642\u062f\u0645\u0647<\/h3>\n<p data-start=\"91\" data-end=\"437\">Streaming Replication \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u062d\u0628\u0648\u0628\u200c\u062a\u0631\u06cc\u0646 \u0631\u0648\u0634\u200c\u0647\u0627 \u0628\u0631\u0627\u06cc \u0645\u0642\u06cc\u0627\u0633\u200c\u067e\u0630\u06cc\u0631\u06cc \u0627\u0641\u0642\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u200c\u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647\u200c\u0627\u06cc \u0627\u0633\u062a. \u062f\u0631 \u0627\u06cc\u0646 \u0631\u0648\u0634\u060c \u062f\u0648 \u06cc\u0627 \u0686\u0646\u062f \u0646\u0633\u062e\u0647 \u0627\u0632 \u06cc\u06a9 \u06a9\u0644\u0627\u0633\u062a\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0631\u0648\u06cc \u0645\u0627\u0634\u06cc\u0646\u200c\u0647\u0627\u06cc \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0627\u062c\u0631\u0627 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u06cc\u06a9\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u06a9\u0644\u0627\u0633\u062a\u0631\u0647\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 Primary \u0634\u0646\u0627\u062e\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u0648 \u0639\u0645\u0644\u06cc\u0627\u062a \u062e\u0648\u0627\u0646\u062f\u0646 \u0648 \u0646\u0648\u0634\u062a\u0646 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u062f\u0647\u062f\u061b \u0633\u0627\u06cc\u0631 \u06a9\u0644\u0627\u0633\u062a\u0631\u0647\u0627 \u06a9\u0647 Replica \u0646\u0627\u0645 \u062f\u0627\u0631\u0646\u062f\u060c \u0641\u0642\u0637 \u0639\u0645\u0644\u06cc\u0627\u062a \u062e\u0648\u0627\u0646\u062f\u0646 \u0631\u0627 \u0633\u0631\u0648\u06cc\u0633\u200c\u062f\u0647\u06cc \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f.<\/p>\n<p data-start=\"439\" data-end=\"685\">\u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 Streaming Replication \u0628\u0631\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634 High Availability \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u0627\u06af\u0631 \u0633\u0631\u0648\u0631 \u06cc\u0627 \u06a9\u0644\u0627\u0633\u062a\u0631 \u0627\u0635\u0644\u06cc \u0628\u0647 \u0647\u0631 \u062f\u0644\u06cc\u0644\u06cc \u0627\u0632 \u062f\u0633\u062a\u0631\u0633 \u062e\u0627\u0631\u062c \u0634\u0648\u062f\u060c Replica\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0647\u0645\u0686\u0646\u0627\u0646 \u062f\u0631\u062e\u0648\u0627\u0633\u062a\u200c\u0647\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646 \u0631\u0627 \u067e\u0627\u0633\u062e \u062f\u0647\u0646\u062f \u06cc\u0627 \u06cc\u06a9\u06cc \u0627\u0632 Replica\u0647\u0627 \u0628\u0647 Primary \u062c\u062f\u06cc\u062f \u062a\u0628\u062f\u06cc\u0644 \u0634\u0648\u062f.<\/p>\n<p data-start=\"687\" data-end=\"1096\">PostgreSQL \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u062d\u0628\u0648\u0628\u200c\u062a\u0631\u06cc\u0646 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u200c\u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647\u200c\u0627\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u0647\u0631 \u062f\u0648 \u0646\u0648\u0639 Replication \u06cc\u0639\u0646\u06cc Logical \u0648 Physical \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062f\u0631 Logical Replication \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0633\u0637\u062d \u0628\u0627\u0644\u0627 \u0627\u0632 Primary \u0628\u0647 Replica \u0645\u0646\u062a\u0642\u0644 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f \u0648 \u062d\u062a\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0641\u0642\u0637 \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u06cc\u0627 \u062c\u062f\u0648\u0644 \u062e\u0627\u0635 \u0631\u0627 Replicate \u06a9\u0631\u062f. \u0627\u0645\u0627 \u062f\u0631 Physical Replication\u060c \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0641\u0627\u06cc\u0644 WAL \u06cc\u0627 \u0647\u0645\u0627\u0646 Write-Ahead Logging \u0645\u0646\u062a\u0642\u0644 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f \u0648 \u062f\u0631 \u0646\u062a\u06cc\u062c\u0647 \u062a\u0645\u0627\u0645 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u06a9\u0644\u0627\u0633\u062a\u0631 \u0627\u0635\u0644\u06cc \u0631\u0648\u06cc Replica \u0627\u0639\u0645\u0627\u0644 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n<p data-start=\"1098\" data-end=\"1310\">\u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634\u060c \u0646\u062d\u0648\u0647 \u0631\u0627\u0647\u200c\u0627\u0646\u062f\u0627\u0632\u06cc Physical Streaming Replication \u062f\u0631 PostgreSQL 12 \u0631\u0648\u06cc Ubuntu 20.04 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0648 \u0633\u0631\u0648\u0631 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u06cc\u0627\u062f \u0645\u06cc\u200c\u06af\u06cc\u0631\u06cc\u062f. \u06cc\u06a9\u06cc \u0627\u0632 \u0633\u0631\u0648\u0631\u0647\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 Primary \u0648 \u062f\u06cc\u06af\u0631\u06cc \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 Replica \u0639\u0645\u0644 \u062e\u0648\u0627\u0647\u062f \u06a9\u0631\u062f.<\/p>\n<hr data-start=\"1312\" data-end=\"1315\" \/>\n<h2 data-section-id=\"1i1mrbk\" data-start=\"1317\" data-end=\"1330\">\u067e\u06cc\u0634\u200c\u0646\u06cc\u0627\u0632\u0647\u0627<\/h2>\n<p data-start=\"1332\" data-end=\"1382\">\u0642\u0628\u0644 \u0627\u0632 \u0634\u0631\u0648\u0639 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634\u060c \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0628\u0627\u06cc\u062f \u0622\u0645\u0627\u062f\u0647 \u0628\u0627\u0634\u0646\u062f:<\/p>\n<ul data-start=\"1384\" data-end=\"1650\">\n<li data-section-id=\"12x8ze0\" data-start=\"1384\" data-end=\"1466\">\u062f\u0648 \u0633\u0631\u0648\u0631 Ubuntu 20.04 \u062c\u062f\u0627\u06af\u0627\u0646\u0647\n<ul data-start=\"1417\" data-end=\"1466\">\n<li data-section-id=\"zv3384\" data-start=\"1417\" data-end=\"1439\">\u06cc\u06a9\u06cc \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 Primary<\/li>\n<li data-section-id=\"183qy3k\" data-start=\"1442\" data-end=\"1466\">\u062f\u06cc\u06af\u0631\u06cc \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 Replica<\/li>\n<\/ul>\n<\/li>\n<li data-section-id=\"6rj2zz\" data-start=\"1468\" data-end=\"1517\">\u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 \u063a\u06cc\u0631 Root \u0628\u0627 \u062f\u0633\u062a\u0631\u0633\u06cc sudo \u0631\u0648\u06cc \u0647\u0631 \u062f\u0648 \u0633\u0631\u0648\u0631<\/li>\n<li data-section-id=\"4237a\" data-start=\"1519\" data-end=\"1614\">\u0641\u0639\u0627\u0644 \u0628\u0648\u062f\u0646 \u0641\u0627\u06cc\u0631\u0648\u0627\u0644 \u0648 \u0628\u0627\u0632 \u0628\u0648\u062f\u0646 \u067e\u0648\u0631\u062a\u200c\u0647\u0627\u06cc:\n<ul data-start=\"1562\" data-end=\"1614\">\n<li data-section-id=\"nobues\" data-start=\"1562\" data-end=\"1574\">HTTP\/HTTPS<\/li>\n<li data-section-id=\"gy4g9v\" data-start=\"1577\" data-end=\"1614\">\u067e\u0648\u0631\u062a 5432 (\u067e\u0648\u0631\u062a \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 PostgreSQL)<\/li>\n<\/ul>\n<\/li>\n<li data-section-id=\"7gcqkp\" data-start=\"1616\" data-end=\"1650\">\u0646\u0635\u0628 PostgreSQL 12 \u0631\u0648\u06cc \u0647\u0631 \u062f\u0648 \u0633\u0631\u0648\u0631<\/li>\n<\/ul>\n<hr data-start=\"1652\" data-end=\"1655\" \/>\n<h1 data-section-id=\"tkquik\" data-start=\"1657\" data-end=\"1701\">\u0645\u0631\u062d\u0644\u0647 \u0627\u0648\u0644 \u2014 \u062a\u0646\u0638\u06cc\u0645 Primary \u0628\u0631\u0627\u06cc \u067e\u0630\u06cc\u0631\u0634 \u0627\u062a\u0635\u0627\u0644<\/h1>\n<p data-start=\"1703\" data-end=\"1869\">\u0628\u0647 \u0635\u0648\u0631\u062a \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 PostgreSQL \u0641\u0642\u0637 \u0631\u0648\u06cc localhost \u06cc\u0627 \u0647\u0645\u0627\u0646 127.0.0.1 \u06af\u0648\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 Replica \u0628\u062a\u0648\u0627\u0646\u062f \u0628\u0647 Primary \u0645\u062a\u0635\u0644 \u0634\u0648\u062f\u060c \u0628\u0627\u06cc\u062f \u062a\u0646\u0638\u06cc\u0645\u0627\u062a listen_addresses \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.<\/p>\n<p data-start=\"1871\" data-end=\"1924\">\u0631\u0648\u06cc \u0633\u0631\u0648\u0631 Primary \u0641\u0627\u06cc\u0644 \u062a\u0646\u0638\u06cc\u0645\u0627\u062a PostgreSQL \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code><span class=\"\u037cl\">sudo<\/span> nano \/etc\/postgresql\/12\/main\/postgresql.conf<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"1989\" data-end=\"2076\">\u0645\u0642\u062f\u0627\u0631 listen_addresses \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0647 \u0648 \u0622\u0646 \u0631\u0627 \u0627\u0632 localhost \u0628\u0647 IP \u0633\u0631\u0648\u0631 Primary \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code>listen_addresses = 'your_primary_IP_address'<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2136\" data-end=\"2173\">\u0647\u0645\u0686\u0646\u06cc\u0646 \u0639\u0644\u0627\u0645\u062a # \u0627\u0628\u062a\u062f\u0627\u06cc \u062e\u0637 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f.<\/p>\n<p data-start=\"2175\" data-end=\"2206\">\u0641\u0627\u06cc\u0644 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0631\u062f\u0647 \u0648 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f.<\/p>\n<p data-start=\"2208\" data-end=\"2270\">\u0627\u06a9\u0646\u0648\u0646 PostgreSQL \u0622\u0645\u0627\u062f\u0647 \u067e\u0630\u06cc\u0631\u0634 \u0627\u062a\u0635\u0627\u0644 \u0627\u0632 \u0633\u0627\u06cc\u0631 \u0645\u0627\u0634\u06cc\u0646\u200c\u0647\u0627 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.<\/p>\n<hr data-start=\"2272\" data-end=\"2275\" \/>\n<h1 data-section-id=\"1fdg5kh\" data-start=\"2277\" data-end=\"2318\">\u0645\u0631\u062d\u0644\u0647 \u062f\u0648\u0645 \u2014 \u0633\u0627\u062e\u062a Role \u0645\u062e\u0635\u0648\u0635 Replication<\/h1>\n<p data-start=\"2320\" data-end=\"2423\">\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0628\u0627\u06cc\u062f \u06cc\u06a9 Role \u0645\u062e\u0635\u0648\u0635 Replication \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u062a\u0627 Replica \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0628\u0647 Primary \u0645\u062a\u0635\u0644 \u0634\u0648\u062f.<\/p>\n<p data-start=\"2425\" data-end=\"2457\">\u0627\u0628\u062a\u062f\u0627 \u0648\u0627\u0631\u062f \u0645\u062d\u06cc\u0637 PostgreSQL \u0634\u0648\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code><span class=\"\u037cl\">sudo<\/span> <span class=\"\u037cn\">-u<\/span> postgres psql<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2494\" data-end=\"2517\">\u0633\u067e\u0633 Role \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code><span class=\"\u037cg\">CREATE<\/span> <span class=\"\u037cg\">ROLE<\/span> test <span class=\"\u037cg\">WITH<\/span> REPLICATION PASSWORD <span class=\"\u037ck\">'testpassword'<\/span> LOGIN;<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2596\" data-end=\"2602\">\u062e\u0631\u0648\u062c\u06cc:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute end-1.5 top-1 z-2 md:end-2 md:top-1\"><\/div>\n<div class=\"relative\">\n<div class=\"pe-11 pt-3\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code>CREATE ROLE<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2629\" data-end=\"2692\">\u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u06cc\u06a9 Role \u0628\u0647 \u0646\u0627\u0645 test \u0645\u06cc\u200c\u0633\u0627\u0632\u062f \u06a9\u0647 \u0645\u062c\u0648\u0632 Replication \u062f\u0627\u0631\u062f.<\/p>\n<p data-start=\"2694\" data-end=\"2729\">\u0627\u06a9\u0646\u0648\u0646 \u0627\u0632 \u0645\u062d\u06cc\u0637 PostgreSQL \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code>\\q<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2746\" data-end=\"2779\">\u0633\u067e\u0633 \u0641\u0627\u06cc\u0644 pg_hba.conf \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code><span class=\"\u037cl\">sudo<\/span> nano \/etc\/postgresql\/12\/main\/pg_hba.conf<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2840\" data-end=\"2876\">\u0627\u06cc\u0646 \u062e\u0637 \u0631\u0627 \u0628\u0647 \u0627\u0646\u062a\u0647\u0627\u06cc \u0641\u0627\u06cc\u0644 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code>host    replication     test    your-replica-IP\/32   md5<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2948\" data-end=\"3040\">\u0627\u06cc\u0646 \u062a\u0646\u0638\u06cc\u0645 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f Replica \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Role \u0633\u0627\u062e\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u0647 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 Replication \u0645\u062a\u0635\u0644 \u0634\u0648\u062f.<\/p>\n<p data-start=\"3042\" data-end=\"3080\">\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a PostgreSQL \u0631\u0627 \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code><span class=\"\u037cl\">sudo<\/span> systemctl <span class=\"\u037cl\">restart<\/span> postgresql@12-main<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<hr data-start=\"3137\" data-end=\"3140\" \/>\n<h1 data-section-id=\"9ieqp3\" data-start=\"3142\" data-end=\"3191\">\u0645\u0631\u062d\u0644\u0647 \u0633\u0648\u0645 \u2014 \u06af\u0631\u0641\u062a\u0646 Backup \u0627\u0632 Primary \u0631\u0648\u06cc Replica<\/h1>\n<p data-start=\"3193\" data-end=\"3283\">\u062f\u0631 Physical Replication \u0628\u0627\u06cc\u062f \u06cc\u06a9 \u0646\u0633\u062e\u0647 \u06a9\u0627\u0645\u0644 \u0627\u0632 \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 Primary \u0631\u0648\u06cc Replica \u06a9\u067e\u06cc \u0634\u0648\u062f.<\/p>\n<p data-start=\"3285\" data-end=\"3332\">\u0627\u0628\u062a\u062f\u0627 \u0645\u062d\u062a\u0648\u0627\u06cc \u062f\u06cc\u062a\u0627\u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc Replica \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code><span class=\"\u037cl\">sudo<\/span> <span class=\"\u037cn\">-u<\/span> postgres <span class=\"\u037cl\">rm<\/span> <span class=\"\u037cn\">-r<\/span> \/var\/lib\/postgresql\/12\/main\/*<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"3400\" data-end=\"3469\">\u0627\u06af\u0631 \u0628\u0647 \u0647\u0631 \u062f\u0644\u06cc\u0644\u06cc \u062e\u0637\u0627 \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0631\u062f\u06cc\u062f\u060c \u06a9\u0644 \u067e\u0648\u0634\u0647 \u0631\u0627 \u062d\u0630\u0641 \u0648 \u062f\u0648\u0628\u0627\u0631\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code><span class=\"\u037cl\">sudo<\/span> <span class=\"\u037cn\">-u<\/span> postgres <span class=\"\u037cl\">rm<\/span> <span class=\"\u037cn\">-r<\/span> \/var\/lib\/postgresql\/12\/main\r\n<span class=\"\u037cl\">sudo<\/span> <span class=\"\u037cn\">-u<\/span> postgres <span class=\"\u037cl\">mkdir<\/span> \/var\/lib\/postgresql\/12\/main\r\n<span class=\"\u037cl\">sudo<\/span> <span class=\"\u037cn\">-u<\/span> postgres <span class=\"\u037cl\">chmod<\/span> <span class=\"\u037cj\">700<\/span> \/var\/lib\/postgresql\/12\/main<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"3641\" data-end=\"3698\">\u0627\u06a9\u0646\u0648\u0646 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 pg_basebackup \u0627\u0632 Primary \u0628\u06a9\u0627\u067e \u0628\u06af\u06cc\u0631\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code><span class=\"\u037cl\">sudo<\/span> <span class=\"\u037cn\">-u<\/span> postgres pg_basebackup <span class=\"\u037cn\">-h<\/span> primary-ip-addr <span class=\"\u037cn\">-p<\/span> <span class=\"\u037cj\">5432<\/span> <span class=\"\u037cn\">-U<\/span> test <span class=\"\u037cn\">-D<\/span> \/var\/lib\/postgresql\/12\/main\/ <span class=\"\u037cn\">-Fp<\/span> <span class=\"\u037cn\">-Xs<\/span> <span class=\"\u037cn\">-R<\/span><\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h3 data-section-id=\"1dm3iiq\" data-start=\"3822\" data-end=\"3841\">\u062a\u0648\u0636\u06cc\u062d \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627<\/h3>\n<ul data-start=\"3843\" data-end=\"4101\">\n<li data-section-id=\"16ky59i\" data-start=\"3843\" data-end=\"3874\"><code data-start=\"3845\" data-end=\"3849\">-h<\/code><br data-start=\"3849\" data-end=\"3852\" \/>\u0622\u062f\u0631\u0633 IP \u0633\u0631\u0648\u0631 Primary<\/li>\n<li data-section-id=\"dd2e44\" data-start=\"3876\" data-end=\"3902\"><code data-start=\"3878\" data-end=\"3882\">-p<\/code><br data-start=\"3882\" data-end=\"3885\" \/>\u067e\u0648\u0631\u062a PostgreSQL<\/li>\n<li data-section-id=\"utp1fe\" data-start=\"3904\" data-end=\"3944\"><code data-start=\"3906\" data-end=\"3910\">-U<\/code><br data-start=\"3910\" data-end=\"3913\" \/>\u0646\u0627\u0645 Role \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 Replication<\/li>\n<li data-section-id=\"4g9r8q\" data-start=\"3946\" data-end=\"3974\"><code data-start=\"3948\" data-end=\"3952\">-D<\/code><br data-start=\"3952\" data-end=\"3955\" \/>\u0645\u0633\u06cc\u0631 \u0630\u062e\u06cc\u0631\u0647 Backup<\/li>\n<li data-section-id=\"z6z29q\" data-start=\"3976\" data-end=\"4014\"><code data-start=\"3978\" data-end=\"3983\">-Fp<\/code><br data-start=\"3983\" data-end=\"3986\" \/>\u062e\u0631\u0648\u062c\u06cc \u0628\u0647 \u0635\u0648\u0631\u062a Plain Format<\/li>\n<li data-section-id=\"oi62u9\" data-start=\"4016\" data-end=\"4055\"><code data-start=\"4018\" data-end=\"4023\">-Xs<\/code><br data-start=\"4023\" data-end=\"4026\" \/>\u0627\u0646\u062a\u0642\u0627\u0644 WAL \u0647\u0645\u0632\u0645\u0627\u0646 \u0628\u0627 Backup<\/li>\n<li data-section-id=\"j7l3v8\" data-start=\"4057\" data-end=\"4101\"><code data-start=\"4059\" data-end=\"4063\">-R<\/code><br data-start=\"4063\" data-end=\"4066\" \/>\u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0646 Replica \u062f\u0631 \u062d\u0627\u0644\u062a Standby<\/li>\n<\/ul>\n<p data-start=\"4103\" data-end=\"4149\">\u067e\u0633 \u0627\u0632 \u0627\u062c\u0631\u0627\u06cc \u062f\u0633\u062a\u0648\u0631\u060c \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 Role \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f.<\/p>\n<p data-start=\"4151\" data-end=\"4206\">\u0628\u0633\u062a\u0647 \u0628\u0647 \u062d\u062c\u0645 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u060c \u0627\u06cc\u0646 \u0641\u0631\u0622\u06cc\u0646\u062f \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u06a9\u0645\u06cc \u0632\u0645\u0627\u0646 \u0628\u0628\u0631\u062f.<\/p>\n<hr data-start=\"4208\" data-end=\"4211\" \/>\n<h1 data-section-id=\"1h4q7o7\" data-start=\"4213\" data-end=\"4265\">\u0645\u0631\u062d\u0644\u0647 \u0686\u0647\u0627\u0631\u0645 \u2014 \u0631\u0627\u0647\u200c\u0627\u0646\u062f\u0627\u0632\u06cc Replica \u0648 \u062a\u0633\u062a Replication<\/h1>\n<p data-start=\"4267\" data-end=\"4299\">\u0627\u06a9\u0646\u0648\u0646 Replica \u0631\u0627 \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code><span class=\"\u037cl\">sudo<\/span> systemctl <span class=\"\u037cl\">restart<\/span> postgresql@12-main<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"4356\" data-end=\"4435\">\u0627\u06af\u0631 \u0647\u0645\u0647 \u0686\u06cc\u0632 \u062f\u0631\u0633\u062a \u062a\u0646\u0638\u06cc\u0645 \u0634\u062f\u0647 \u0628\u0627\u0634\u062f\u060c Replica \u0628\u0647 \u0635\u0648\u0631\u062a \u062e\u0648\u062f\u06a9\u0627\u0631 \u0628\u0647 Primary \u0645\u062a\u0635\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n<p data-start=\"4437\" data-end=\"4475\">\u0631\u0648\u06cc \u0633\u0631\u0648\u0631 Primary \u0648\u0627\u0631\u062f PostgreSQL \u0634\u0648\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code><span class=\"\u037cl\">sudo<\/span> <span class=\"\u037cn\">-u<\/span> postgres psql<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"4512\" data-end=\"4548\">\u0633\u067e\u0633 \u0648\u0636\u0639\u06cc\u062a Replication \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\">\n<div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\">\n<div class=\"sticky bg-token-border-light\"><\/div>\n<\/div>\n<\/div>\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code><span class=\"\u037cg\">SELECT<\/span> client_addr, <span class=\"\u037cg\">state<\/span> <span class=\"\u037cg\">FROM<\/span> pg_stat_replication;<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"4614\" data-end=\"4640\">\u062e\u0631\u0648\u062c\u06cc \u0645\u0634\u0627\u0628\u0647 \u0632\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-token-bg-elevated-secondary corner-superellipse\/1.1 overflow-clip rounded-3xl lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute end-1.5 top-1 z-2 md:end-2 md:top-1\"><\/div>\n<div class=\"relative\">\n<div class=\"pe-11 pt-3\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code>   client_addr    |  state\r\n------------------+-----------\r\n your_replica_IP | streaming<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"4742\" data-end=\"4817\">\u0627\u06af\u0631 \u0648\u0636\u0639\u06cc\u062a streaming \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u0648\u062f \u06cc\u0639\u0646\u06cc Replication \u0628\u0627 \u0645\u0648\u0641\u0642\u06cc\u062a \u0641\u0639\u0627\u0644 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<hr data-start=\"4819\" data-end=\"4822\" \/>\n<h1 data-section-id=\"1t6iden\" data-start=\"4824\" data-end=\"4836\">\u0646\u062a\u06cc\u062c\u0647\u200c\u06af\u06cc\u0631\u06cc<\/h1>\n<p data-start=\"4838\" data-end=\"4962\">\u0627\u06a9\u0646\u0648\u0646 \u062f\u0648 \u0633\u0631\u0648\u0631 Ubuntu 20.04 \u062f\u0627\u0631\u06cc\u062f \u06a9\u0647 \u0631\u0648\u06cc \u0647\u0631\u06a9\u062f\u0627\u0645 PostgreSQL 12 \u0627\u062c\u0631\u0627 \u0634\u062f\u0647 \u0648 \u0628\u06cc\u0646 \u0622\u0646\u200c\u0647\u0627 Physical Streaming Replication \u0628\u0631\u0642\u0631\u0627\u0631 \u0627\u0633\u062a.<\/p>\n<p data-start=\"4964\" data-end=\"5041\">\u0627\u0632 \u0627\u06cc\u0646 \u067e\u0633 \u0647\u0631 \u062a\u063a\u06cc\u06cc\u0631\u06cc \u06a9\u0647 \u0631\u0648\u06cc Primary \u0627\u0646\u062c\u0627\u0645 \u0634\u0648\u062f\u060c \u0631\u0648\u06cc Replica \u0646\u06cc\u0632 \u0627\u0639\u0645\u0627\u0644 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n<p data-start=\"5043\" data-end=\"5156\" data-is-last-node=\"\" data-is-only-node=\"\">\u0647\u0645\u0686\u0646\u06cc\u0646 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f Replica\u0647\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc \u0628\u0647 \u0633\u0627\u062e\u062a\u0627\u0631 \u062e\u0648\u062f \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u062a\u0648\u0627\u0646 \u067e\u0627\u0633\u062e\u200c\u06af\u0648\u06cc\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0627\u0641\u0632\u0627\u06cc\u0634 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u062f.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"z-0 flex min-h-[46px] justify-start\"><\/div>\n<div class=\"mt-3 w-full empty:hidden\">\n<div class=\"text-center\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n<div class=\"pointer-events-none -mt-px h-px translate-y-[calc(var(--scroll-root-safe-area-inset-bottom)-14*var(--spacing))]\" aria-hidden=\"true\"><\/div>\n<div class=\"pointer-events-none translate-y-(--scroll-root-safe-area-inset-bottom) R6Vx5W_threadScrollVars min-h-(--gutter-remaining-height,0px) group-data-stream-active\/scroll-root:h-[calc(var(--thread-response-height)-16*var(--spacing))]\">\u0627\u0632 \u0647\u0645\u0631\u0627\u0647\u06cc \u0634\u0645\u0627 \u0628\u0627 <strong><a href=\"https:\/\/parmin.cloud\/\">\u067e\u0627\u0631\u0645\u06cc\u0646 \u06a9\u0644\u0648\u062f<\/a><\/strong> \u0633\u067e\u0627\u0633\u06af\u0632\u0627\u0631\u06cc\u0645.<\/div>\n<div style='text-align:center' class='yasr-auto-insert-visitor'><\/div>","protected":false},"excerpt":{"rendered":"<p>\u0645\u0642\u062f\u0645\u0647 Streaming Replication \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u062d\u0628\u0648\u0628\u200c\u062a\u0631\u06cc\u0646 \u0631\u0648\u0634\u200c\u0647\u0627 \u0628\u0631\u0627\u06cc \u0645\u0642\u06cc\u0627\u0633\u200c\u067e\u0630\u06cc\u0631\u06cc \u0627\u0641\u0642\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u200c\u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647\u200c\u0627\u06cc \u0627\u0633\u062a. \u062f\u0631 \u0627\u06cc\u0646 \u0631\u0648\u0634\u060c \u062f\u0648 \u06cc\u0627 \u0686\u0646\u062f \u0646\u0633\u062e\u0647 \u0627\u0632 \u06cc\u06a9 \u06a9\u0644\u0627\u0633\u062a\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0631\u0648\u06cc \u0645\u0627\u0634\u06cc\u0646\u200c\u0647\u0627\u06cc \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0627\u062c\u0631\u0627 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u06cc\u06a9\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u06a9\u0644\u0627\u0633\u062a\u0631\u0647\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 Primary \u0634\u0646\u0627\u062e\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u0648 \u0639\u0645\u0644\u06cc\u0627\u062a \u062e\u0648\u0627\u0646\u062f\u0646 \u0648 \u0646\u0648\u0634\u062a\u0646 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u062f\u0647\u062f\u061b \u0633\u0627\u06cc\u0631 \u06a9\u0644\u0627\u0633\u062a\u0631\u0647\u0627 \u06a9\u0647 Replica \u0646\u0627\u0645 \u062f\u0627\u0631\u0646\u062f\u060c \u0641\u0642\u0637 \u0639\u0645\u0644\u06cc\u0627\u062a \u062e\u0648\u0627\u0646\u062f\u0646 [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":6322,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"yasr_overall_rating":0,"yasr_post_is_review":"","yasr_auto_insert_disabled":"","yasr_review_type":"","footnotes":""},"categories":[258,376],"tags":[1065,1062,1061,1063,1064],"class_list":["post-6321","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ubuntu","category-376","tag--postgresql-replication","tag---postgresql--","tag--high-availability--postgresql","tag--replica--postgresql-12","tag--streaming-replication--postgresql"],"aioseo_notices":[],"yasr_visitor_votes":{"stars_attributes":{"read_only":false,"span_bottom":false},"number_of_votes":0,"sum_votes":0},"_links":{"self":[{"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/posts\/6321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/comments?post=6321"}],"version-history":[{"count":1,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/posts\/6321\/revisions"}],"predecessor-version":[{"id":6323,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/posts\/6321\/revisions\/6323"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/media\/6322"}],"wp:attachment":[{"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/media?parent=6321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/categories?post=6321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/parmin.cloud\/blog\/wp-json\/wp\/v2\/tags?post=6321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}