{"id":10096,"date":"2023-12-27T12:22:06","date_gmt":"2023-12-27T08:52:06","guid":{"rendered":"https:\/\/rasanegar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%af%d8%b1-centos-8\/"},"modified":"2023-12-27T12:22:06","modified_gmt":"2023-12-27T08:52:06","slug":"%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%af%d8%b1-centos-8","status":"publish","type":"post","link":"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%af%d8%b1-centos-8\/","title":{"rendered":"\u0631\u0648\u0634 \u0646\u0635\u0628 PostgreSQL \u062f\u0631 CentOS 8"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\"><p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0633\u0631\u0641\u0635\u0644\u0647\u0627\u06cc \u0645\u0637\u0644\u0628<\/p>\n<\/div><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%af%d8%b1-centos-8\/#%d9%be%db%8c%d8%b4_%d9%86%db%8c%d8%a7%d8%b2%d9%87%d8%a7\" >\u067e\u06cc\u0634 \u0646\u06cc\u0627\u0632\u0647\u0627<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%af%d8%b1-centos-8\/#%d9%86%d8%b5%d8%a8_postgresql_%d8%af%d8%b1_centos_8\" >\u0646\u0635\u0628 PostgreSQL \u062f\u0631 CentOS 8<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%af%d8%b1-centos-8\/#%d9%86%d9%82%d8%b4_%d9%87%d8%a7%db%8c_postgresql_%d9%88_%d8%b1%d9%88%d8%b4_%d9%87%d8%a7%db%8c_%d8%a7%d8%ad%d8%b1%d8%a7%d8%b2_%d9%87%d9%88%db%8c%d8%aa\" >\u0646\u0642\u0634 \u0647\u0627\u06cc PostgreSQL \u0648 \u0631\u0648\u0634 \u0647\u0627\u06cc \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%af%d8%b1-centos-8\/#%d8%a7%db%8c%d8%ac%d8%a7%d8%af_%d9%86%d9%82%d8%b4_%d9%88_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87_postgresql\" >\u0627\u06cc\u062c\u0627\u062f \u0646\u0642\u0634 \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%af%d8%b1-centos-8\/#%d8%af%d8%b3%d8%aa%d8%b1%d8%b3%db%8c_%d8%a7%d8%b2_%d8%b1%d8%a7%d9%87_%d8%af%d9%88%d8%b1_%d8%a8%d9%87_%d8%b3%d8%b1%d9%88%d8%b1_postgresql_%d8%b1%d8%a7_%d9%81%d8%b9%d8%a7%d9%84_%da%a9%d9%86%db%8c%d8%af\" >\u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 \u0633\u0631\u0648\u0631 PostgreSQL \u0631\u0627 \u0641\u0639\u0627\u0644 \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%af%d8%b1-centos-8\/#%d9%86%d8%aa%db%8c%d8%ac%d9%87\" >\u0646\u062a\u06cc\u062c\u0647<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">\u0632\u0645\u0627\u0646 \u0644\u0627\u0632\u0645 \u0628\u0631\u0627\u06cc \u0645\u0637\u0627\u0644\u0639\u0647: <\/span> <span class=\"rt-time\"> 4<\/span> <span class=\"rt-label rt-postfix\">\u062f\u0642\u06cc\u0642\u0647<\/span><\/span><p> <br \/>\n<br \/><\/p>\n<div class=\"markdown\">\n<p>PostgreSQL \u06cc\u0627 Postgres \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0634\u06cc-\u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0647\u0645\u0647 \u0645\u0646\u0638\u0648\u0631\u0647 \u0645\u0646\u0628\u0639 \u0628\u0627\u0632 \u0628\u0627 \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0645\u062d\u06cc\u0637 \u0647\u0627\u06cc \u0645\u0642\u0627\u0648\u0645 \u062f\u0631 \u0628\u0631\u0627\u0628\u0631 \u062e\u0637\u0627 \u06cc\u0627 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0628\u0633\u0627\u0632\u06cc\u062f.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627\u060c \u0631\u0648\u0634 \u0646\u0635\u0628 \u0633\u0631\u0648\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u062f\u0631 CentOS 8 \u0631\u0627 \u0645\u0648\u0631\u062f \u0628\u062d\u062b \u0642\u0631\u0627\u0631 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f. \u0642\u0628\u0644 \u0627\u0632 \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0633\u062e\u0647 \u0628\u0631\u0627\u06cc \u0646\u0635\u0628\u060c \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0634\u0645\u0627 \u0627\u0632 \u0622\u0646 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f.<\/p>\n<p>\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u0635\u0648\u0644 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.<\/p>\n<h2 id=\"prerequisites\"><span class=\"ez-toc-section\" id=\"%d9%be%db%8c%d8%b4_%d9%86%db%8c%d8%a7%d8%b2%d9%87%d8%a7\"><\/span>\u067e\u06cc\u0634 \u0646\u06cc\u0627\u0632\u0647\u0627 <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0633\u062a\u0647 \u0647\u0627 \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f\u060c \u0628\u0627\u06cc\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 root \u06cc\u0627 \u06a9\u0627\u0631\u0628\u0631 \u0628\u0627 \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a sudo \u0648\u0627\u0631\u062f \u0634\u0648\u06cc\u062f.<\/p>\n<h2 id=\"installing-postgresql-on-centos-8\"><span class=\"ez-toc-section\" id=\"%d9%86%d8%b5%d8%a8_postgresql_%d8%af%d8%b1_centos_8\"><\/span>\u0646\u0635\u0628 PostgreSQL \u062f\u0631 CentOS 8 <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0632\u0645\u0627\u0646 \u0646\u06af\u0627\u0631\u0634 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647\u060c \u062f\u0648 \u0646\u0633\u062e\u0647 \u0627\u0632 \u0633\u0631\u0648\u0631 PostgreSQL \u0628\u0631\u0627\u06cc \u0646\u0635\u0628 \u0627\u0632 \u0645\u062e\u0627\u0632\u0646 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f CentOS \u0645\u0648\u062c\u0648\u062f \u0627\u0633\u062a: \u0646\u0633\u062e\u0647 9.6 \u0648 10.0.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0641\u0647\u0631\u0633\u062a \u06a9\u0631\u062f\u0646 \u062c\u0631\u06cc\u0627\u0646 \u0647\u0627\u06cc \u0645\u0627\u0698\u0648\u0644 PostgreSQL \u0645\u0648\u062c\u0648\u062f\u060c \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">dnf module list postgresql<\/code><\/pre>\n<p>\u062e\u0631\u0648\u062c\u06cc \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u0645\u0627\u0698\u0648\u0644 postgresql \u0628\u0627 \u062f\u0648 \u062c\u0631\u06cc\u0627\u0646 \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0627\u0633\u062a.  \u0647\u0631 \u062c\u0631\u06cc\u0627\u0646 \u062f\u0627\u0631\u0627\u06cc \u062f\u0648 \u067e\u0631\u0648\u0641\u0627\u06cc\u0644 \u0627\u0633\u062a: \u0633\u0631\u0648\u0631 \u0648 \u0645\u0634\u062a\u0631\u06cc.  \u062c\u0631\u06cc\u0627\u0646 10 \u0628\u0627 \u0633\u0631\u0648\u0631 \u0646\u0645\u0627\u06cc\u0647 \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0627\u0633\u062a:<\/p>\n<pre tabindex=\"0\"><code class=\"language-output\" data-lang=\"output\">CentOS-8 - AppStream\nName          Stream    Profiles              Summary                                                 \npostgresql    10 [d]    client, server [d]    PostgreSQL server and client module                     \npostgresql    9.6       client, server [d]    PostgreSQL server and client module \n<\/code><\/pre>\n<ol>\n<li>\n<p>\u0628\u0631\u0627\u06cc \u0646\u0635\u0628 \u0627\u0633\u062a\u0631\u06cc\u0645 \u067e\u06cc\u0634 \u0641\u0631\u0636\u060c \u0633\u0631\u0648\u0631 PostgreSQL \u0646\u0633\u062e\u0647 10.0 \u0631\u0627 \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo dnf install @postgresql:10<\/code><\/pre>\n<\/li>\n<li>\n<p>\u0628\u0631\u0627\u06cc \u0646\u0635\u0628 \u0633\u0631\u0648\u0631 PostgreSQL \u0646\u0633\u062e\u0647 9.6 \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo dnf install @postgresql:9.6 <\/code><\/pre>\n<\/li>\n<\/ol>\n<p>\u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0633\u062a\u0647 contrib \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0686\u0646\u062f\u06cc\u0646 \u0648\u06cc\u0698\u06af\u06cc \u0627\u0636\u0627\u0641\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0633\u06cc\u0633\u062a\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo dnf install postgresql-contrib<\/code><\/pre>\n<p>\u067e\u0633 \u0627\u0632 \u0627\u062a\u0645\u0627\u0645 \u0646\u0635\u0628\u060c \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0631\u0627 \u0628\u0627 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0645\u0642\u062f\u0627\u0631\u062f\u0647\u06cc \u0627\u0648\u0644\u06cc\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo postgresql-setup initdb<\/code><\/pre>\n<pre tabindex=\"0\"><code class=\"language-output\" data-lang=\"output\">Initializing database ... OK\n<\/code><\/pre>\n<p>\u0633\u0631\u0648\u06cc\u0633 PostgreSQL \u0631\u0627 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f \u0648 \u0622\u0646 \u0631\u0627 \u0641\u0639\u0627\u0644 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u062f\u0631 \u0647\u0646\u06af\u0627\u0645 \u0628\u0648\u062a \u0634\u0631\u0648\u0639 \u0634\u0648\u062f:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo systemctl enable --now postgresql<\/code><\/pre>\n<p>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <code>psql<\/code> \u0627\u0628\u0632\u0627\u0631\u06cc \u0628\u0631\u0627\u06cc \u062a\u0623\u06cc\u06cc\u062f \u0646\u0635\u0628 \u0628\u0627 \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u0633\u0631\u0648\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0648 \u0686\u0627\u067e \u0646\u0633\u062e\u0647 \u0622\u0646:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo -u postgres psql -c \"SELECT version();\"<\/code><\/pre>\n<pre tabindex=\"0\"><code class=\"language-output\" data-lang=\"output\">PostgreSQL 10.6 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 8.2.1 20180905 (Red Hat 8.2.1-3), 64-bit\n<\/code><\/pre>\n<h2 id=\"postgresql-roles-and-authentication-methods\"><span class=\"ez-toc-section\" id=\"%d9%86%d9%82%d8%b4_%d9%87%d8%a7%db%8c_postgresql_%d9%88_%d8%b1%d9%88%d8%b4_%d9%87%d8%a7%db%8c_%d8%a7%d8%ad%d8%b1%d8%a7%d8%b2_%d9%87%d9%88%db%8c%d8%aa\"><\/span>\u0646\u0642\u0634 \u0647\u0627\u06cc PostgreSQL \u0648 \u0631\u0648\u0634 \u0647\u0627\u06cc \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>PostgreSQL \u0645\u062c\u0648\u0632\u0647\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u0641\u0647\u0648\u0645 \u0646\u0642\u0634 \u0647\u0627 \u06a9\u0646\u062a\u0631\u0644 \u0645\u06cc \u06a9\u0646\u062f.  \u06cc\u06a9 \u0646\u0642\u0634 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0646\u0634\u0627\u0646 \u062f\u0647\u0646\u062f\u0647 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06cc\u0627 \u06af\u0631\u0648\u0647\u06cc \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627\u0634\u062f.<\/p>\n<p>PostgreSQL \u0627\u0632 \u0686\u0646\u062f\u06af\u0627\u0646\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f <a href=\"https:\/\/www.postgresql.org\/docs\/10.0\/static\/auth-methods.html\" target=\"_blank\" rel=\"noopener\">\u0631\u0648\u0634 \u0647\u0627\u06cc \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a<\/a><br \/>\n.  \u0645\u062a\u062f\u0627\u0648\u0644 \u062a\u0631\u06cc\u0646 \u0631\u0648\u0634 \u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0639\u0628\u0627\u0631\u062a\u0646\u062f \u0627\u0632:<\/p>\n<ul>\n<li>\u0627\u0639\u062a\u0645\u0627\u062f &#8211; \u06cc\u06a9 \u0646\u0642\u0634 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u062f\u0648\u0646 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0645\u062a\u0635\u0644 \u0634\u0648\u062f\u060c \u062a\u0627 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0634\u0631\u0627\u06cc\u0637 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u062f\u0631 \u0622\u0646 \u0648\u062c\u0648\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f <code>pg_hba.conf<\/code> \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0646\u062f.<\/li>\n<li>\u0631\u0645\u0632 \u0639\u0628\u0648\u0631 &#8211; \u06cc\u06a9 \u0646\u0642\u0634 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0627 \u0627\u0631\u0627\u0626\u0647 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0645\u062a\u0635\u0644 \u0634\u0648\u062f.  \u0631\u0645\u0632\u0647\u0627\u06cc \u0639\u0628\u0648\u0631 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0631\u062f <code>scram-sha-256<\/code>\u060c <code>md5<\/code>\u060c \u0648 <code>password<\/code> (\u0645\u062a\u0646 \u0648\u0627\u0636\u062d).<\/li>\n<li>Ident &#8211; \u0641\u0642\u0637 \u062f\u0631 \u0627\u062a\u0635\u0627\u0644\u0627\u062a TCP\/IP \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u0634\u0648\u062f.  \u0628\u0627 \u0628\u0647 \u062f\u0633\u062a \u0622\u0648\u0631\u062f\u0646 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0639\u0627\u0645\u0644 \u0645\u0634\u062a\u0631\u06cc\u060c \u0628\u0627 \u0646\u0642\u0634\u0647 \u0628\u0631\u062f\u0627\u0631\u06cc \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0627\u062e\u062a\u06cc\u0627\u0631\u06cc \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>Peer &#8211; \u0647\u0645\u0627\u0646\u0646\u062f Ident\u060c \u0627\u0645\u0627 \u0641\u0642\u0637 \u062f\u0631 \u0627\u062a\u0635\u0627\u0644\u0627\u062a \u0645\u062d\u0644\u06cc \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u0634\u0648\u062f.<\/li>\n<\/ul>\n<p>\u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0645\u0634\u062a\u0631\u06cc PostgreSQL \u062f\u0631 \u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0646\u0627\u0645\u06af\u0630\u0627\u0631\u06cc \u0634\u062f\u0647 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0627\u0633\u062a <code>pg_hba.conf<\/code>.  \u0628\u0647 \u0637\u0648\u0631 \u067e\u06cc\u0634 \u0641\u0631\u0636\u060c \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644\u0627\u062a \u0645\u062d\u0644\u06cc\u060c PostgreSQL \u062a\u0646\u0638\u06cc\u0645 \u0634\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u0631\u0648\u0634 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0647\u0645\u062a\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u062f.<\/p>\n<p>\u0627\u06cc\u0646 <code>postgres<\/code> \u0648\u0642\u062a\u06cc \u0633\u0631\u0648\u0631 PostgreSQL \u0631\u0627 \u0646\u0635\u0628 \u0645\u06cc \u06a9\u0646\u06cc\u062f\u060c \u06a9\u0627\u0631\u0628\u0631 \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f.  \u0627\u06cc\u0646 \u06a9\u0627\u0631\u0628\u0631 \u0627\u0628\u0631\u06a9\u0627\u0631\u0628\u0631 \u0628\u0631\u0627\u06cc \u0646\u0645\u0648\u0646\u0647 PostgreSQL \u0627\u0633\u062a.  \u0645\u0639\u0627\u062f\u0644 \u06a9\u0627\u0631\u0628\u0631 \u0631\u06cc\u0634\u0647 MySQL \u0627\u0633\u062a.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u0631\u0648\u0631 PostgreSQL \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 <code>postgres<\/code> \u06a9\u0627\u0631\u0628\u0631\u060c \u0627\u0628\u062a\u062f\u0627 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0633\u0648\u0626\u06cc\u0686 \u06a9\u0646\u06cc\u062f \u0648 \u0633\u067e\u0633 \u0628\u0647 \u0627\u0639\u0644\u0627\u0646 PostgreSQL \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>psql<\/code> \u0633\u0648\u062f\u0645\u0646\u062f\u06cc:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo su - postgres<\/code><code class=\"terminal-line\" prefix=\"$\">psql<\/code><\/pre>\n<p>\u0627\u0632 \u0627\u06cc\u0646\u062c\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0627 \u0646\u0645\u0648\u0646\u0647 PostgreSQL \u062a\u0639\u0627\u0645\u0644 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f.  \u0628\u0631\u0627\u06cc \u062e\u0631\u0648\u062c \u0627\u0632 \u067e\u0648\u0633\u062a\u0647 PostgreSQL\u060c \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f:<\/p>\n<pre tabindex=\"0\"><code class=\"language-psql\" data-lang=\"psql\">\\q\n<\/code><\/pre>\n<p>\u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u062f\u0648\u0646 \u062a\u0639\u0648\u06cc\u0636 \u06a9\u0627\u0631\u0628\u0631 \u0628\u0627 \u062f\u0633\u062a\u0648\u0631 PostgreSQL \u0628\u0647 \u0627\u0639\u0644\u0627\u0646 PostgreSQL \u062f\u0633\u062a\u0631\u0633\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f <code>sudo<\/code><br \/>\n\u062f\u0633\u062a\u0648\u0631:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo -u postgres psql<\/code><\/pre>\n<p>\u0628\u0647 \u0637\u0648\u0631 \u0645\u0639\u0645\u0648\u0644 <code>postgres<\/code> \u06a9\u0627\u0631\u0628\u0631 \u0641\u0642\u0637 \u0627\u0632 localhost.<\/p>\n<h2 id=\"creating-postgresql-role-and-database\"><span class=\"ez-toc-section\" id=\"%d8%a7%db%8c%d8%ac%d8%a7%d8%af_%d9%86%d9%82%d8%b4_%d9%88_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87_postgresql\"><\/span>\u0627\u06cc\u062c\u0627\u062f \u0646\u0642\u0634 \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0641\u0642\u0637 \u0627\u0628\u0631\u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0648 \u0646\u0642\u0634 \u0647\u0627 \u0628\u0627 <code>CREATEROLE<\/code> \u0627\u0645\u062a\u06cc\u0627\u0632 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0646\u0642\u0634 \u0647\u0627\u06cc \u062c\u062f\u06cc\u062f\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u062f.<\/p>\n<p>\u062f\u0631 \u0645\u062b\u0627\u0644 \u0632\u06cc\u0631 \u06cc\u06a9 \u0646\u0642\u0634 \u062c\u062f\u06cc\u062f \u0628\u0627 \u0646\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>john<\/code>\u060c \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u06cc \u0628\u0647 \u0646\u0627\u0645 <code>johndb<\/code>\u060c \u0648 \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a\u06cc \u0631\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0639\u0637\u0627 \u06a9\u0646\u06cc\u062f.<\/p>\n<ol>\n<li>\n<p>\u0627\u0628\u062a\u062f\u0627 \u0628\u0647 \u067e\u0648\u0633\u062a\u0647 PostgreSQL \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo -u postgres psql<\/code><\/pre>\n<\/li>\n<li>\n<p>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u06cc\u06a9 \u0646\u0642\u0634 PostgreSQL \u062c\u062f\u06cc\u062f \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"highlight\">\n<pre tabindex=\"0\" class=\"chroma\"><code class=\"language-sql\" data-lang=\"sql\"><span class=\"line\"><span class=\"cl\"><span class=\"k\">CREATE<\/span><span class=\"w\"> <\/span><span class=\"k\">ROLE<\/span><span class=\"w\"> <\/span><span class=\"n\">john<\/span><span class=\"p\">;<\/span><\/span><\/span><\/code><\/pre>\n<\/div>\n<\/li>\n<li>\n<p>\u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f:<\/p>\n<div class=\"highlight\">\n<pre tabindex=\"0\" class=\"chroma\"><code class=\"language-sql\" data-lang=\"sql\"><span class=\"line\"><span class=\"cl\"><span class=\"k\">CREATE<\/span><span class=\"w\"> <\/span><span class=\"k\">DATABASE<\/span><span class=\"w\"> <\/span><span class=\"n\">johndb<\/span><span class=\"p\">;<\/span><\/span><\/span><\/code><\/pre>\n<\/div>\n<\/li>\n<li>\n<p>\u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u06a9\u0648\u0626\u0631\u06cc \u0632\u06cc\u0631 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0645\u062a\u06cc\u0627\u0632 \u0628\u062f\u0647\u06cc\u062f:<\/p>\n<div class=\"highlight\">\n<pre tabindex=\"0\" class=\"chroma\"><code class=\"language-sql\" data-lang=\"sql\"><span class=\"line\"><span class=\"cl\"><span class=\"k\">GRANT<\/span><span class=\"w\"> <\/span><span class=\"k\">ALL<\/span><span class=\"w\"> <\/span><span class=\"k\">PRIVILEGES<\/span><span class=\"w\"> <\/span><span class=\"k\">ON<\/span><span class=\"w\"> <\/span><span class=\"k\">DATABASE<\/span><span class=\"w\"> <\/span><span class=\"n\">johndb<\/span><span class=\"w\"> <\/span><span class=\"k\">TO<\/span><span class=\"w\"> <\/span><span class=\"n\">john<\/span><span class=\"p\">;<\/span><\/span><\/span><\/code><\/pre>\n<\/div>\n<\/li>\n<\/ol>\n<h2 id=\"enable-remote-access-to-postgresql-server\"><span class=\"ez-toc-section\" id=\"%d8%af%d8%b3%d8%aa%d8%b1%d8%b3%db%8c_%d8%a7%d8%b2_%d8%b1%d8%a7%d9%87_%d8%af%d9%88%d8%b1_%d8%a8%d9%87_%d8%b3%d8%b1%d9%88%d8%b1_postgresql_%d8%b1%d8%a7_%d9%81%d8%b9%d8%a7%d9%84_%da%a9%d9%86%db%8c%d8%af\"><\/span>\u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 \u0633\u0631\u0648\u0631 PostgreSQL \u0631\u0627 \u0641\u0639\u0627\u0644 \u06a9\u0646\u06cc\u062f <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u0647 \u0637\u0648\u0631 \u067e\u06cc\u0634 \u0641\u0631\u0636\u060c \u0633\u0631\u0648\u0631 PostgreSQL \u0641\u0642\u0637 \u062f\u0631 \u0631\u0627\u0628\u0637 \u0645\u062d\u0644\u06cc \u06af\u0648\u0634 \u0645\u06cc \u062f\u0647\u062f <code>127.0.0.1<\/code>.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0641\u0639\u0627\u0644 \u06a9\u0631\u062f\u0646 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 \u0633\u0631\u0648\u0631 PostgreSQL \u062e\u0648\u062f\u060c \u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo nano \/var\/lib\/pgsql\/data\/postgresql.conf<\/code><\/pre>\n<p>\u0628\u0647 \u067e\u0627\u06cc\u06cc\u0646 \u0627\u0633\u06a9\u0631\u0648\u0644 \u06a9\u0646\u06cc\u062f <code>CONNECTIONS AND AUTHENTICATION<\/code> \u0628\u062e\u0634 \u0648 \u062e\u0637 \u0632\u06cc\u0631 \u0631\u0627 \u0627\u0636\u0627\u0641\u0647\/\u0648\u06cc\u0631\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"code-label\">\/var\/lib\/pgsql\/data\/postgresql.conf<\/div>\n<div class=\"highlight\">\n<pre tabindex=\"0\" class=\"chroma\"><code class=\"language-cfg\" data-lang=\"cfg\"><span class=\"line\"><span class=\"cl\"><span class=\"c1\">#------------------------------------------------------------------------------<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"c1\"># CONNECTIONS AND AUTHENTICATION<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"c1\">#------------------------------------------------------------------------------<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"c1\"># - Connection Settings -<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">\n<\/span><\/span><span class=\"line hl\"><span class=\"cl\"><span class=\"na\">listen_addresses<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'*'     # what IP address(es) to listen on;<\/span><\/span><\/span><\/code><\/pre>\n<\/div>\n<p>\u0641\u0627\u06cc\u0644 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u06cc\u062f \u0648 \u0633\u0631\u0648\u06cc\u0633 PostgreSQL \u0631\u0627 \u0645\u062c\u062f\u062f\u0627\u064b \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo systemctl restart postgresql<\/code><\/pre>\n<p>\u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0631\u0627 \u0628\u0627 <code>ss<\/code> \u0633\u0648\u062f\u0645\u0646\u062f\u06cc:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">ss -nlt | grep 5432<\/code><\/pre>\n<pre tabindex=\"0\"><code class=\"language-output\" data-lang=\"output\">LISTEN   0    128    0.0.0.0:5432    0.0.0.0:*       \nLISTEN   0    128    [::]:5432      [::]:*  \n<\/code><\/pre>\n<p>\u062e\u0631\u0648\u062c\u06cc \u0628\u0627\u0644\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u0633\u0631\u0648\u0631 PostgreSQL \u062f\u0631 \u062d\u0627\u0644 \u06af\u0648\u0634 \u062f\u0627\u062f\u0646 \u0628\u0647 \u067e\u0648\u0631\u062a \u067e\u06cc\u0634 \u0641\u0631\u0636 \u062f\u0631 \u0647\u0645\u0647 \u0627\u06cc\u0646\u062a\u0631\u0641\u06cc\u0633 \u0647\u0627 (0.0.0.0) \u0627\u0633\u062a.<\/p>\n<p>\u0622\u062e\u0631\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0633\u0631\u0648\u0631 \u0628\u0631\u0627\u06cc \u067e\u0630\u06cc\u0631\u0634 \u0627\u062a\u0635\u0627\u0644\u0627\u062a \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0627 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u0622\u0646 \u0627\u0633\u062a <code>pg_hba.conf<\/code> \u0641\u0627\u06cc\u0644.<\/p>\n<p>\u062f\u0631 \u0632\u06cc\u0631 \u0686\u0646\u062f \u0646\u0645\u0648\u0646\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0645\u0648\u0627\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u062e\u062a\u0644\u0641 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f:<\/p>\n<div class=\"code-label\">\/var\/lib\/pgsql\/data\/pg_hba.conf<\/div>\n<div class=\"highlight\">\n<pre tabindex=\"0\" class=\"chroma\"><code class=\"language-cfg\" data-lang=\"cfg\"><span class=\"line\"><span class=\"cl\"><span class=\"c1\"># TYPE  DATABASE        USER            ADDRESS                 METHOD<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"c1\"># The user jane can access all databases from all locations using an md5 password<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"na\">host    all             jane            0.0.0.0\/0                md5<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"c1\"># The user jane can access only the janedb database from all locations using an md5 password<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"na\">host    janedb          jane            0.0.0.0\/0                md5<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"c1\"># The user jane can access all databases from a trusted location (192.168.1.134) without a password<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"na\">host    all             jane            192.168.1.134            trust<\/span>\n<\/span><\/span><\/code><\/pre>\n<\/div>\n<h2 id=\"conclusion\"><span class=\"ez-toc-section\" id=\"%d9%86%d8%aa%db%8c%d8%ac%d9%87\"><\/span>\u0646\u062a\u06cc\u062c\u0647 <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>CentOS 8 \u062f\u0648 \u0646\u0633\u062e\u0647 PostgreSQL \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f: 9.6 \u0648 10.0.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u0628\u0647 \u0633\u0627\u06cc\u062a \u0645\u0631\u0627\u062c\u0639\u0647 \u06a9\u0646\u06cc\u062f <a href=\"https:\/\/www.postgresql.org\/docs\/10.0\/static\/index.html\" target=\"_blank\" rel=\"noopener\">PostgreSQL Documentation<\/a><\/p>\n<p>\u0627\u06af\u0631 \u0645\u0634\u06a9\u0644\u06cc \u062f\u0627\u0631\u06cc\u062f \u06cc\u0627 \u0628\u0627\u0632\u062e\u0648\u0631\u062f\u06cc \u062f\u0627\u0631\u06cc\u062f\u060c \u062f\u0631 \u0632\u06cc\u0631 \u0646\u0638\u0631 \u062f\u0647\u06cc\u062f.<\/p>\n<div class=\"flex flex-wrap my-8\">\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 centos postgresql<\/div>\n<\/div>\n\n<div>\u0628\u0631\u0627\u06cc \u0646\u06af\u0627\u0631\u0634 \u0628\u062e\u0634\u0647\u0627\u06cc\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u0645\u062a\u0646 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0627\u0632 \u062a\u0631\u062c\u0645\u0647 \u0645\u0627\u0634\u06cc\u0646\u06cc \u06cc\u0627 \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc GPT \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u0628\u0627\u0634\u062f <br \/>\n\u0644\u0637\u0641\u0627 \u062f\u0631 \u0635\u0648\u0631\u062a \u0648\u062c\u0648\u062f \u0645\u0634\u06a9\u0644 \u062f\u0631 \u0645\u062a\u0646 \u06cc\u0627 \u0645\u0641\u0647\u0648\u0645 \u0646\u0628\u0648\u062f\u0646 \u062a\u0648\u0636\u06cc\u062d\u0627\u062a\u060c \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062f\u06a9\u0645\u0647 \u06af\u0632\u0627\u0631\u0634 \u0646\u0648\u0634\u062a\u0627\u0631 \u06cc\u0627 \u062f\u0631\u062c \u0646\u0638\u0631 \u0631\u0648\u06cc \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0645\u0627 \u0631\u0627 \u0627\u0632 \u062c\u0632\u06cc\u06cc\u0627\u062a \u0645\u0634\u06a9\u0644 \u0645\u0634\u0627\u0647\u062f\u0647 \u0634\u062f\u0647 \u0645\u0637\u0644\u0639 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0628\u0647 \u0622\u0646 \u0631\u0633\u06cc\u062f\u06af\u06cc \u06a9\u0646\u06cc\u0645\n<\/div>\n<p>\u0632\u0645\u0627\u0646 \u0627\u0646\u062a\u0634\u0627\u0631: 1402-12-27 12:22:02<br \/>\n<\/p>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-center kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;center&quot;,&quot;id&quot;:&quot;10096&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;\u0627\u0645\u062a\u06cc\u0627\u0632 \u0634\u0645\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628&quot;,&quot;legend&quot;:&quot;0\\\/5 (0 \u0631\u0627\u06cc)&quot;,&quot;size&quot;:&quot;30&quot;,&quot;title&quot;:&quot;\u0631\u0648\u0634 \u0646\u0635\u0628 PostgreSQL \u062f\u0631 CentOS 8&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} ({count} \u0631\u0627\u06cc)&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 24px;\">\n            <span class=\"kksr-muted\">\u0627\u0645\u062a\u06cc\u0627\u0632 \u0634\u0645\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">\u0632\u0645\u0627\u0646 \u0644\u0627\u0632\u0645 \u0628\u0631\u0627\u06cc \u0645\u0637\u0627\u0644\u0639\u0647: <\/span> <span class=\"rt-time\"> 4<\/span> <span class=\"rt-label rt-postfix\">\u062f\u0642\u06cc\u0642\u0647<\/span><\/span>PostgreSQL \u06cc\u0627 Postgres \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0634\u06cc-\u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0647\u0645\u0647 \u0645\u0646\u0638\u0648\u0631\u0647 \u0645\u0646\u0628\u0639 \u0628\u0627\u0632 \u0628\u0627 \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0645\u062d\u06cc\u0637 \u0647\u0627\u06cc \u0645\u0642\u0627\u0648\u0645 \u062f\u0631 \u0628\u0631\u0627\u0628\u0631 \u062e\u0637\u0627 \u06cc\u0627 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0628\u0633\u0627\u0632\u06cc\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627\u060c \u0631\u0648\u0634 \u0646\u0635\u0628 \u0633\u0631\u0648\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u062f\u0631 CentOS 8 \u0631\u0627 \u0645\u0648\u0631\u062f \u0628\u062d\u062b \u0642\u0631\u0627\u0631 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":10097,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[202,95,1686],"tags":[2611,506,2529,2537,2536,2539,1868],"class_list":["post-10096","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-os","category-linux","category-ai","tag-postgresql","tag-506","tag-2529","tag--linux","tag-2536","tag-2539"],"acf":[],"_links":{"self":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts\/10096","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/comments?post=10096"}],"version-history":[{"count":0,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts\/10096\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media\/10097"}],"wp:attachment":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media?parent=10096"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/categories?post=10096"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/tags?post=10096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}