{"id":11160,"date":"2023-12-29T11:22:37","date_gmt":"2023-12-29T07:52:37","guid":{"rendered":"https:\/\/rasanegar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/"},"modified":"2023-12-29T11:22:37","modified_gmt":"2023-12-29T07:52:37","slug":"%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7","status":"publish","type":"post","link":"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/","title":{"rendered":"\u0631\u0648\u0634 \u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc Ubuntu + \u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u0648\u062b\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647"},"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%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#postgresql_%da%86%db%8c%d8%b3%d8%aa%d8%9f\" >PostgreSQL \u0686\u06cc\u0633\u062a\u061f<\/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%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#%d8%b1%d9%88%d8%b4_%d9%86%d8%b5%d8%a8_postgresql_%d8%b1%d9%88%db%8c_%d8%a7%d9%88%d8%a8%d9%88%d9%86%d8%aa%d9%88\" >\u0631\u0648\u0634 \u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><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%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#1_postgresql_%d8%b1%d8%a7_%d9%86%d8%b5%d8%a8_%da%a9%d9%86%db%8c%d8%af\" >1. PostgreSQL \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><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%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#2_%d9%88%d8%b6%d8%b9%db%8c%d8%aa_postgresql_%d8%b1%d8%a7_%d8%a8%d8%b1%d8%b1%d8%b3%db%8c_%da%a9%d9%86%db%8c%d8%af\" >2. \u0648\u0636\u0639\u06cc\u062a PostgreSQL \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><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%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#3_%d8%a8%d9%87_postgresql_%d9%85%d8%aa%d8%b5%d9%84_%d8%b4%d9%88%db%8c%d8%af\" >3. \u0628\u0647 PostgreSQL \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><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%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#4_%d8%b1%d9%85%d8%b2_%d8%b9%d8%a8%d9%88%d8%b1_%da%a9%d8%a7%d8%b1%d8%a8%d8%b1_%d8%b1%d8%a7_%d8%aa%d8%ba%db%8c%db%8c%d8%b1_%d8%af%d9%87%db%8c%d8%af\" >4. \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#5_%db%8c%da%a9_%da%a9%d8%a7%d8%b1%d8%a8%d8%b1_%d8%a7%db%8c%d8%ac%d8%a7%d8%af_%da%a9%d9%86%db%8c%d8%af_%d8%b1%d9%88%db%8c_postgresql\" >5. \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u0631\u0648\u06cc PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#6_%db%8c%da%a9_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87_%d8%a7%db%8c%d8%ac%d8%a7%d8%af_%da%a9%d9%86%db%8c%d8%af_%d8%b1%d9%88%db%8c_postgresql\" >6. \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u0631\u0648\u06cc PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#7_%d8%b3%d8%b1%d9%88%d8%b1_postgresql_%d8%b1%d8%a7_%d9%be%db%8c%da%a9%d8%b1%d8%a8%d9%86%d8%af%db%8c_%da%a9%d9%86%db%8c%d8%af\" >7. \u0633\u0631\u0648\u0631 PostgreSQL \u0631\u0627 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#8_%db%8c%da%a9_%d8%a7%d8%aa%d8%b5%d8%a7%d9%84_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87_%d8%a7%d8%b2_%d8%b1%d8%a7%d9%87_%d8%af%d9%88%d8%b1_%d8%b1%d8%a7%d9%87_%d8%a7%d9%86%d8%af%d8%a7%d8%b2%db%8c_%da%a9%d9%86%db%8c%d8%af\" >8. \u06cc\u06a9 \u0627\u062a\u0635\u0627\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#9_pgadmin_%d8%b1%d8%a7_%d9%86%d8%b5%d8%a8_%da%a9%d9%86%db%8c%d8%af\" >9. pgAdmin \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#%d8%b9%db%8c%d8%a8_%db%8c%d8%a7%d8%a8%db%8c_%d9%86%d8%b5%d8%a8_postgresql\" >\u0639\u06cc\u0628 \u06cc\u0627\u0628\u06cc \u0646\u0635\u0628 PostgreSQL<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#1_%d8%a7%d9%85%da%a9%d8%a7%d9%86_%d8%a7%d8%aa%d8%b5%d8%a7%d9%84_%d8%a8%d9%87_%d8%b3%d8%b1%d9%88%d8%b1_postgresql_%d9%88%d8%ac%d9%88%d8%af_%d9%86%d8%af%d8%a7%d8%b1%d8%af\" >1. \u0627\u0645\u06a9\u0627\u0646 \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u0633\u0631\u0648\u0631 PostgreSQL \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#2_%d9%85%d8%b4%da%a9%d9%84%d8%a7%d8%aa_%d8%a7%d8%aa%d8%b5%d8%a7%d9%84_postgresql_%d8%a7%d8%b2_%d9%85%db%8c%d8%b2%d8%a8%d8%a7%d9%86_%d8%b1%d8%a7%d9%87_%d8%af%d9%88%d8%b1\" >2. \u0645\u0634\u06a9\u0644\u0627\u062a \u0627\u062a\u0635\u0627\u0644 PostgreSQL \u0627\u0632 \u0645\u06cc\u0632\u0628\u0627\u0646 \u0631\u0627\u0647 \u062f\u0648\u0631<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#3_%d9%85%d8%b4%da%a9%d9%84%d8%a7%d8%aa_%d9%88%d8%b1%d9%88%d8%af_pgadmin\" >3. \u0645\u0634\u06a9\u0644\u0627\u062a \u0648\u0631\u0648\u062f pgAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#4_%d8%aa%d8%b6%d8%a7%d8%af_%d9%86%d8%b3%d8%ae%d9%87_postgresql\" >4. \u062a\u0636\u0627\u062f \u0646\u0633\u062e\u0647 PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#5_%d8%a7%d9%85%da%a9%d8%a7%d9%86_%d8%a7%db%8c%d8%ac%d8%a7%d8%af_%da%a9%d8%a7%d8%b1%d8%a8%d8%b1_%db%8c%d8%a7_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87_postgresql_%d9%88%d8%ac%d9%88%d8%af_%d9%86%d8%af%d8%a7%d8%b1%d8%af\" >5. \u0627\u0645\u06a9\u0627\u0646 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0627\u0631\u0628\u0631 \u06cc\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#%d9%86%d8%aa%db%8c%d8%ac%d9%87\" >\u0646\u062a\u06cc\u062c\u0647<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#%d8%b1%d9%88%d8%b4_%d9%86%d8%b5%d8%a8_postgresql_%d8%b1%d9%88%db%8c_%d8%b3%d9%88%d8%a7%d9%84%d8%a7%d8%aa_%d9%85%d8%aa%d8%af%d8%a7%d9%88%d9%84_%d8%a7%d9%88%d8%a8%d9%88%d9%86%d8%aa%d9%88\" >\u0631\u0648\u0634 \u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc \u0633\u0648\u0627\u0644\u0627\u062a \u0645\u062a\u062f\u0627\u0648\u0644 \u0627\u0648\u0628\u0648\u0646\u062a\u0648<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#%da%a9%d8%ac%d8%a7_postgres_%d9%86%d8%b5%d8%a8_%d8%b4%d8%af%d9%87_%d8%a7%d8%b3%d8%aa_%d8%b1%d9%88%db%8c_%d8%a7%d9%88%d8%a8%d9%88%d9%86%d8%aa%d9%88%d8%9f\" >\u06a9\u062c\u0627 Postgres \u0646\u0635\u0628 \u0634\u062f\u0647 \u0627\u0633\u062a \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648\u061f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#%da%86%da%af%d9%88%d9%86%d9%87_%d8%a8%d9%81%d9%87%d9%85%d9%85_postgresql_%d9%86%d8%b5%d8%a8_%d8%b4%d8%af%d9%87_%d8%a7%d8%b3%d8%aa%d8%9f_%d8%b1%d9%88%db%8c_%d8%a7%d9%88%d8%a8%d9%88%d9%86%d8%aa%d9%88%d8%9f\" >\u0686\u06af\u0648\u0646\u0647 \u0628\u0641\u0647\u0645\u0645 PostgreSQL \u0646\u0635\u0628 \u0634\u062f\u0647 \u0627\u0633\u062a\u061f \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648\u061f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-postgresql-%d8%b1%d9%88%db%8c-ubuntu-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d9%84%d8%b9%d9%85%d9%84-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a8%d8%b1%d8%a7\/#%d8%a2%db%8c%d8%a7_%d8%a8%d8%a7%db%8c%d8%af_%d8%a7%d8%b2_postgresql_13_%db%8c%d8%a7_14_%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87_%da%a9%d9%86%d9%85%d8%9f\" >\u0622\u06cc\u0627 \u0628\u0627\u06cc\u062f \u0627\u0632 PostgreSQL 13 \u06cc\u0627 14 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0645\u061f<\/a><\/li><\/ul><\/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\"> 11<\/span> <span class=\"rt-label rt-postfix\">\u062f\u0642\u06cc\u0642\u0647<\/span><\/span><p> <br \/>\n<\/p>\n<div class=\"post-content\">\n<p>PostgreSQL \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627\u0628\u0637\u0647\u200c\u0627\u06cc \u0645\u0646\u0628\u0639 \u0628\u0627\u0632 \u0645\u062d\u0628\u0648\u0628 (RDBMS) \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0645\u0642\u06cc\u0627\u0633\u200c\u067e\u0630\u06cc\u0631\u06cc \u0648 \u06a9\u0627\u0631\u0627\u06cc\u06cc \u0622\u0646 \u062f\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062d\u062c\u0645 \u0632\u06cc\u0627\u062f\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0634\u0646\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<p>\u0628\u0647 \u062f\u0644\u06cc\u0644 \u0639\u0645\u0644\u06a9\u0631\u062f \u0628\u0627\u0644\u0627\u060c PostgreSQL \u0628\u0631\u0627\u06cc \u0648\u0628 \u0633\u0627\u06cc\u062a \u0647\u0627 \u06cc\u0627 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0633\u0627\u0632\u0645\u0627\u0646\u06cc \u0627\u06cc\u062f\u0647 \u0622\u0644 \u0627\u0633\u062a.  \u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0632\u0628\u0627\u0646 \u0647\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0645\u062e\u062a\u0644\u0641 \u0627\u0632 \u062c\u0645\u0644\u0647 PHP \u0648 Python \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0631\u0648\u0634 \u0646\u0635\u0628 PostgreSQL \u0631\u0627 \u062a\u0648\u0636\u06cc\u062d \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f \u0631\u0648\u06cc<strong>  \u0627\u0648\u0628\u0648\u0646\u062a\u0648 20.04 <\/strong>\u0648 \u0628\u0639\u062f.  \u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0646\u0635\u0628 pgAdmin \u0631\u0627 \u067e\u0648\u0634\u0634 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f process \u0648 \u0631\u0627\u0647 \u062d\u0644 \u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0645\u0634\u06a9\u0644\u0627\u062a \u0631\u0627\u06cc\u062c PostgreSQL.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<div class=\"protip\">\n<h2 class=\"featured-snippet title\"><span class=\"ez-toc-section\" id=\"postgresql_%da%86%db%8c%d8%b3%d8%aa%d8%9f\"><\/span><span class=\"ez-toc-section\" id=\"What_Is_PostgreSQL\"><\/span>PostgreSQL \u0686\u06cc\u0633\u062a\u061f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>  PostgreSQL \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc (RDBMS) \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0639\u0645\u0644\u06a9\u0631\u062f\u0634 \u0645\u062d\u0628\u0648\u0628\u06cc\u062a \u062f\u0627\u0631\u062f.  \u0628\u0631\u062e\u0644\u0627\u0641 DBMS \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f\u060c \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0633\u0627\u062e\u062a\u0627\u0631 \u0645\u0646\u0637\u0642\u06cc \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u06a9\u0627\u0631\u0622\u0645\u062f\u062a\u0631 \u0645\u0631\u062a\u0628 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\n\u0631\u0627\u0647 \u062d\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0633\u06cc\u0627\u0631 \u06a9\u0627\u0631\u0622\u0645\u062f \u0648 \u0642\u0627\u062f\u0631 \u0628\u0647 \u0631\u0633\u06cc\u062f\u06af\u06cc \u0628\u0647 \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u060c \u0628\u0631\u0627\u06cc \u0634\u0631\u06a9\u062a \u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0639\u0627\u0644\u06cc \u0627\u0633\u062a.  \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0627\u06cc\u0646\u060c \u0631\u0627\u06cc\u06af\u0627\u0646\u060c \u0645\u0646\u0628\u0639 \u0628\u0627\u0632 \u0648 \u0633\u0627\u0632\u06af\u0627\u0631 \u0628\u0627 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0627\u0633\u062a.<\/p>\n<\/p><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-how-to-install-postgresql-on-ubuntu\"><span class=\"ez-toc-section\" id=\"%d8%b1%d9%88%d8%b4_%d9%86%d8%b5%d8%a8_postgresql_%d8%b1%d9%88%db%8c_%d8%a7%d9%88%d8%a8%d9%88%d9%86%d8%aa%d9%88\"><\/span><span class=\"ez-toc-section\" id=\"How_to_Install_PostgreSQL_on_Ubuntu\"><\/span>\u0631\u0648\u0634 \u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0642\u0628\u0644 \u0627\u0632 \u0627\u062f\u0627\u0645\u0647\u060c \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u0633\u0631\u0648\u0631 \u062e\u0635\u0648\u0635\u06cc \u0645\u062c\u0627\u0632\u06cc \u0634\u0645\u0627 (VPS) \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f <strong>\u0627\u0648\u0628\u0648\u0646\u062a\u0648 20.04 <\/strong>\u0648 \u06cc\u0627 \u0628\u0639\u062f.  \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a\u060c \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u0645\u0627 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f <a href=\"https:\/\/support.hostinger.com\/en\/articles\/4965922-how-to-change-the-operating-system-for-your-vps\" link=\"internal\" rel=\"follow noopener\" class=\"broken_link\" target=\"_blank\">\u062a\u063a\u06cc\u06cc\u0631 \u0633\u06cc\u0633\u062a\u0645 \u0639\u0627\u0645\u0644 \u062f\u0631 \u0647\u0627\u0633\u062a\u06cc\u0646\u06aferVPS<\/a>.<\/p>\n<h3 class=\"wp-block-heading\" id=\"h-1-install-postgresql\"><span class=\"ez-toc-section\" id=\"1_postgresql_%d8%b1%d8%a7_%d9%86%d8%b5%d8%a8_%da%a9%d9%86%db%8c%d8%af\"><\/span><span class=\"ez-toc-section\" id=\"1_Install_PostgreSQL\"><\/span>1. PostgreSQL \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0646\u0635\u0628 PostgreSQL \u0634\u0627\u0645\u0644 \u0627\u062c\u0631\u0627\u06cc \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0627\u0633\u062a \u0631\u0648\u06cc \u0645\u0627\u0634\u06cc\u0646 \u0634\u0645\u0627  \u0628\u0631\u0627\u06cc \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062d\u0644\u06cc\u060c \u0622\u0646\u0647\u0627 \u0631\u0627 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062a\u0631\u0645\u06cc\u0646\u0627\u0644\u060c \u062e\u0637 \u0641\u0631\u0645\u0627\u0646 \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u06cc\u06a9 \u0645\u0627\u0634\u06cc\u0646 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0645\u0627\u0646\u0646\u062f VPS\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 SSH \u06cc\u0627 \u062a\u0631\u0645\u06cc\u0646\u0627\u0644 \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f. \u0647\u0627\u0633\u062a\u06cc\u0646\u06afer \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0639\u062a\u0628\u0627\u0631 \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0631\u0627\u0647 \u062f\u0648\u0631 \u062e\u0648\u062f \u0631\u0627 \u0628\u0627 \u067e\u06cc\u0645\u0627\u06cc\u0634 \u0628\u0647 \u0622\u0646 \u0628\u06cc\u0627\u0628\u0646\u062f <strong>\u0646\u0645\u0627\u06cc \u06a9\u0644\u06cc VPS<\/strong> \u2192 <strong>\u062f\u0633\u062a\u0631\u0633\u06cc SSH <\/strong>\u062f\u0631 hPanel<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"440\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" alt=\"\u0627\u0639\u062a\u0628\u0627\u0631 \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 VPS SSH \u062f\u0631 \u0645\u0646\u0648\u06cc \u0646\u0645\u0627\u06cc \u06a9\u0644\u06cc hPanel VPS\" class=\"wp-image-93039\" srcset=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/VPS-SSH-access-credentials-in-hPanel-VPS-overview-menu.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/VPS-SSH-access-credentials-in-hPanel-VPS-overview-menu-300x129.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/VPS-SSH-access-credentials-in-hPanel-VPS-overview-menu-150x64.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/VPS-SSH-access-credentials-in-hPanel-VPS-overview-menu-768x330.webp 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/figure>\n<\/div>\n<p>\u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0633\u062a\u0647 \u0647\u0627\u06cc PostgreSQL Ubuntu \u0631\u0627 \u0627\u0632 \u0645\u062e\u0632\u0646 \u0645\u062d\u0644\u06cc \u06cc\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062f\u06cc\u0631 \u0628\u0633\u062a\u0647 APT \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f.  \u0645\u0627 \u062f\u0648\u0645\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u062f\u0631\u06cc\u0627\u0641\u062a \u0622\u062e\u0631\u06cc\u0646 \u0646\u0633\u062e\u0647 \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<p>VPS \u0645\u0627 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0646\u06cc\u0632 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f.  \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0627\u06af\u0631 \u06cc\u06a9 NoSQL DBMS \u0631\u0627 \u062a\u0631\u062c\u06cc\u062d \u0645\u06cc \u062f\u0647\u06cc\u062f\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f MongoDB \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f. <\/p>\n<p><strong>\u06af\u0632\u06cc\u0646\u0647 1 &#8211; \u0646\u0635\u0628 \u0627\u0632 \u0645\u062e\u0632\u0646 APT<\/strong><\/p>\n<p>\u0631\u0648\u0634 \u0645\u062d\u0628\u0648\u0628 \u0628\u0631\u0627\u06cc \u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648 \u0627\u0632 \u0645\u062e\u0632\u0646 \u0631\u0633\u0645\u06cc \u0627\u0632 \u0637\u0631\u06cc\u0642 <strong>\u0645\u062f\u06cc\u0631 \u0628\u0633\u062a\u0647 APT<\/strong>.  \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0631\u0627\u062d\u0644 \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f:<\/p>\n<ol>\n<li>\u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u06a9\u0644\u06cc\u062f \u0631\u0627 \u0627\u0632 \u0645\u062e\u0632\u0646 \u0631\u0633\u0645\u06cc PostgreSQL \u0628\u0647 \u0645\u062f\u06cc\u0631 \u0628\u0633\u062a\u0647 APT \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo sh -c 'echo \"deb http:\/\/apt.postgresql.org\/pub\/repos\/apt $(lsb_release -cs)-pgdg main\" &gt; \/etc\/apt\/sources.list.d\/pgdg.list'\n\nwget --quiet -O - https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | sudo gpg -<\/pre>\n<ol start=\"2\">\n<li>\u0628\u0631\u0627\u06cc \u0647\u0645\u06af\u0627\u0645 \u0633\u0627\u0632\u06cc \u062a\u0645\u0627\u0645 \u0645\u062e\u0627\u0632\u0646 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u060c APT \u0631\u0627 \u0628\u0627\u0632\u062e\u0648\u0627\u0646\u06cc \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo apt update<\/pre>\n<ol start=\"3\">\n<li>\u0622\u062e\u0631\u06cc\u0646 \u0646\u0633\u062e\u0647 PostgreSQL \u0631\u0627 \u0628\u0627 \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a APT \u0648 sudo \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo apt-get -y install postgresql<\/pre>\n<ol start=\"4\">\n<li>\u0628\u0631\u0627\u06cc \u062a\u0627\u06cc\u06cc\u062f \u0646\u0635\u0628\u060c \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre>\n<ol start=\"5\">\n<li>\u0639\u0628\u0627\u0631\u062a \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0646\u0633\u062e\u0647 PostgreSQL \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">SELECT version();<\/pre>\n<div class=\"protip\">\n<h4 class=\"title\">\u0646\u06a9\u062a\u0647 \u062d\u0631\u0641\u0647 \u0627\u06cc<\/h4>\n<p>\u0628\u0631\u0627\u06cc \u0646\u0635\u0628 \u06cc\u06a9 \u0646\u0633\u062e\u0647 \u062e\u0627\u0635\u060c \u0645\u062b\u0644\u0627\u064b \u0634\u0645\u0627\u0631\u0647 \u0631\u0627 \u062f\u0631 \u062f\u0633\u062a\u0648\u0631 \u062e\u0648\u062f \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f <strong>sudo apt-get -y postgresql-12 \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f<\/strong>.  \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644\u060c \u062f\u0633\u062a\u0648\u0631 PostgreSQL \u0646\u0633\u062e\u0647 12 \u0631\u0627 \u0646\u0635\u0628 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<\/p><\/div>\n<p><strong>\u06af\u0632\u06cc\u0646\u0647 2 &#8211; \u0646\u0635\u0628 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Local \u0645\u062e\u0632\u0646 \u0627\u0648\u0628\u0648\u0646\u062a\u0648<\/strong><\/p>\n<p>\u0631\u0648\u0634 \u0646\u0635\u0628 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 PostgreSQL \u0627\u0632 \u0645\u062e\u0632\u0646 \u0645\u062d\u0644\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.  \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0631\u0627\u062d\u0644 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u0634\u0648\u062f:<\/p>\n<ol>\n<li>\u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u0627\u0632\u0647 \u0633\u0627\u0632\u06cc \u0645\u062e\u0632\u0646 \u0627\u0648\u0628\u0648\u0646\u062a\u0648 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo apt-get update<\/pre>\n<ol start=\"2\">\n<li>\u0645\u0648\u062c\u0648\u062f \u0631\u0627 \u062a\u0623\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u062f <strong>PostgreSQL<\/strong> <strong>apt<\/strong> <strong>\u0645\u062e\u0632\u0646<\/strong> \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo apt show postgresql<\/pre>\n<ol start=\"3\">\n<li>\u0628\u0631\u0627\u06cc \u0646\u0635\u0628 \u0622\u062e\u0631\u06cc\u0646 \u0646\u0633\u062e\u0647 \u0645\u0648\u062c\u0648\u062f\u060c \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f.  \u062f\u0631 \u0645\u0648\u0631\u062f \u0645\u0627 \u0627\u06cc\u0646\u0637\u0648\u0631 \u0627\u0633\u062a <strong>\u0646\u0633\u062e\u0647 12.15<\/strong>:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo apt install postgresql postgresql-contrib<\/pre>\n<ol start=\"4\">\n<li>\u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0645\u0648\u0641\u0642\u06cc\u062a \u0622\u0645\u06cc\u0632 \u0628\u0648\u062f\u0646 \u0646\u0635\u0628 PostgreSQL\u060c \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre>\n<ol start=\"5\">\n<li>\u0633\u067e\u0633\u060c \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0646\u0633\u062e\u0647 \u0641\u0639\u0644\u06cc PostgreSQL \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">SELECT version();<\/pre>\n<p>\u062e\u0637 \u0641\u0631\u0645\u0627\u0646 \u0628\u0627\u06cc\u062f \u0646\u0634\u0627\u0646 \u062f\u0647\u062f \u06a9\u0647 <strong>\u0633\u0631\u0648\u0631 PostgreSQL \u0646\u0633\u062e\u0647 12.15<\/strong> \u0628\u0627 \u0645\u0648\u0641\u0642\u06cc\u062a \u0646\u0635\u0628 \u0634\u062f\u060c \u0645\u0634\u0627\u0628\u0647 \u0627\u06cc\u0646:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"962\" height=\"128\" src=\"data:image\/svg+xml,%3Csvg%20xmlns=\" alt=\"\u0634\u0645\u0627\u0631\u0647 \u0646\u0633\u062e\u0647 \u0646\u0635\u0628 \u0634\u062f\u0647 PostgreSQL on \u067e\u0627\u06cc\u0627\u0646\u0647\" class=\"wp-image-93040\" data-lazy-srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836345_219_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 962w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-installed-PostgreSQL-version-number-on-Terminal-300x40.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-installed-PostgreSQL-version-number-on-Terminal-150x20.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-installed-PostgreSQL-version-number-on-Terminal-768x102.webp 768w\" data-lazy-sizes=\"(max-width: 962px) 100vw, 962px\" data-lazy-src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836345_219_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" http: title=\"\"><img decoding=\"async\" width=\"962\" height=\"128\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836345_219_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" alt=\"\u0634\u0645\u0627\u0631\u0647 \u0646\u0633\u062e\u0647 \u0646\u0635\u0628 \u0634\u062f\u0647 PostgreSQL on \u067e\u0627\u06cc\u0627\u0646\u0647\" class=\"wp-image-93040\" srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836345_219_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 962w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-installed-PostgreSQL-version-number-on-Terminal-300x40.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-installed-PostgreSQL-version-number-on-Terminal-150x20.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-installed-PostgreSQL-version-number-on-Terminal-768x102.webp 768w\" sizes=\"(max-width: 962px) 100vw, 962px\" title=\"\"><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\" id=\"h-2-check-the-postgresql-status\"><span class=\"ez-toc-section\" id=\"2_%d9%88%d8%b6%d8%b9%db%8c%d8%aa_postgresql_%d8%b1%d8%a7_%d8%a8%d8%b1%d8%b1%d8%b3%db%8c_%da%a9%d9%86%db%8c%d8%af\"><\/span><span class=\"ez-toc-section\" id=\"2_Check_the_PostgreSQL_Status\"><\/span>2. \u0648\u0636\u0639\u06cc\u062a PostgreSQL \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u067e\u0633 \u0627\u0632 \u0646\u0635\u0628 PostgreSQL\u060c \u0641\u0639\u0627\u0644 \u0648 \u0641\u0639\u0627\u0644 \u0628\u0648\u062f\u0646 \u0622\u0646 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f.  \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <strong>systemctl <\/strong>\u06cc\u0627 <strong>\u0633\u0631\u0648\u06cc\u0633 <\/strong>\u0627\u0628\u0632\u0627\u0631 \u0641\u0631\u0645\u0627\u0646 \u0628\u0631\u0627\u06cc \u062a\u0623\u06cc\u06cc\u062f \u0648\u0636\u0639\u06cc\u062a \u0633\u0631\u0648\u06cc\u0633:<\/p>\n<pre class=\"wp-block-preformatted\">sudo service postgresql status\n\nsudo systemctl status postgresql<\/pre>\n<p>\u0627\u06af\u0631 PostgreSQL \u0641\u0639\u0627\u0644 \u0628\u0627\u0634\u062f\u060c \u062e\u0637 \u0641\u0631\u0645\u0627\u0646 \u0634\u0645\u0627 \u062e\u0631\u0648\u062c\u06cc \u062e\u0648\u0627\u0647\u062f \u062f\u0627\u0634\u062a <strong>\u0641\u0639\u0627\u0644 <\/strong>\u0648 <strong>\u0644\u0648\u062f \u0634\u062f\u0647<\/strong>\u060c \u0645\u0634\u0627\u0628\u0647 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"958\" height=\"185\" src=\"data:image\/svg+xml,%3Csvg%20xmlns=\" alt=\"\u0648\u0636\u0639\u06cc\u062a \u0641\u0639\u0644\u06cc \u0633\u0631\u0648\u06cc\u0633 PostgreSQL on \u067e\u0627\u06cc\u0627\u0646\u0647\" class=\"wp-image-93041\" data-lazy-srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836346_95_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 958w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-current-PostgreSQL-service-status-on-Terminal-300x58.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-current-PostgreSQL-service-status-on-Terminal-150x29.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-current-PostgreSQL-service-status-on-Terminal-768x148.webp 768w\" data-lazy-sizes=\"(max-width: 958px) 100vw, 958px\" data-lazy-src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836346_95_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" http: title=\"\"><img decoding=\"async\" width=\"958\" height=\"185\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836346_95_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" alt=\"\u0648\u0636\u0639\u06cc\u062a \u0641\u0639\u0644\u06cc \u0633\u0631\u0648\u06cc\u0633 PostgreSQL on \u067e\u0627\u06cc\u0627\u0646\u0647\" class=\"wp-image-93041\" srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836346_95_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 958w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-current-PostgreSQL-service-status-on-Terminal-300x58.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-current-PostgreSQL-service-status-on-Terminal-150x29.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-current-PostgreSQL-service-status-on-Terminal-768x148.webp 768w\" sizes=\"(max-width: 958px) 100vw, 958px\" title=\"\"><\/figure>\n<\/div>\n<p>\u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0648\u0636\u0639\u06cc\u062a \u0633\u0631\u0648\u06cc\u0633\u060c \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 PostgreSQL \u0622\u0645\u0627\u062f\u0647 \u067e\u0630\u06cc\u0631\u0634 \u0627\u062a\u0635\u0627\u0644 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0627\u0633\u062a:<\/p>\n<pre class=\"wp-block-preformatted\">sudo pg_isready<\/pre>\n<h3 class=\"wp-block-heading\" id=\"h-3-connect-to-postgresql\"><span class=\"ez-toc-section\" id=\"3_%d8%a8%d9%87_postgresql_%d9%85%d8%aa%d8%b5%d9%84_%d8%b4%d9%88%db%8c%d8%af\"><\/span><span class=\"ez-toc-section\" id=\"3_Connect_to_PostgreSQL\"><\/span>3. \u0628\u0647 PostgreSQL \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631 \u0637\u0648\u0644 \u0646\u0635\u0628\u060c PostgreSQL \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f <strong>postgres <\/strong>\u0646\u0642\u0634 \u0628\u0631\u0627\u06cc \u0648\u0631\u0648\u062f \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647  \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0628\u0647 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u0628\u0631\u060c \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">sudo su - postgres<\/pre>\n<p>\u062e\u0637 \u0641\u0631\u0645\u0627\u0646 \u0634\u0645\u0627 \u0627\u06a9\u0646\u0648\u0646 \u0628\u0627\u06cc\u062f \u0628\u0627 \u0622\u0646 \u0634\u0631\u0648\u0639 \u0634\u0648\u062f <strong>postgres<\/strong>.  \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL\u060c \u0627\u0632 \u067e\u0648\u0633\u062a\u0647 PostgreSQL \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">sudo psql<\/pre>\n<p>\u0627\u06cc\u0646 <strong>psql<\/strong> \u062f\u0633\u062a\u0648\u0631 \u06cc\u06a9 \u062c\u0644\u0633\u0647 \u062f\u0631 \u062d\u0627\u0644\u062a \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f<strong> <\/strong>\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647  \u0627\u06af\u0631 \u062f\u0633\u062a\u0648\u0631 \u067e\u06cc\u062f\u0627 \u0646\u0634\u062f\u060c \u06a9\u0644\u0627\u06cc\u0646\u062a PostgreSQL \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0628\u0647 \u0635\u0648\u0631\u062a \u062f\u0633\u062a\u06cc \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">sudo apt-get install postgresql-client<\/pre>\n<p>\u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0648\u0636\u0639\u06cc\u062a \u0627\u062a\u0635\u0627\u0644\u060c \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0639\u0644\u0627\u0646 PostgreSQL \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">\\conninfo<\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"958\" height=\"72\" src=\"data:image\/svg+xml,%3Csvg%20xmlns=\" alt=\"\u062f\u0633\u062a\u0648\u0631 conninfo \u06cc\u06a9 \u067e\u06cc\u0627\u0645 \u062a\u0627\u06cc\u06cc\u062f \u062e\u0631\u0648\u062c\u06cc \u0645\u06cc \u062f\u0647\u062f on \u067e\u0627\u06cc\u0627\u0646\u0647\" class=\"wp-image-93042\" data-lazy-srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836347_996_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 958w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-conninfo-command-outputs-a-confirmation-message-on-Terminal-300x23.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-conninfo-command-outputs-a-confirmation-message-on-Terminal-150x11.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-conninfo-command-outputs-a-confirmation-message-on-Terminal-768x58.webp 768w\" data-lazy-sizes=\"(max-width: 958px) 100vw, 958px\" data-lazy-src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836347_996_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" http: title=\"\"><img decoding=\"async\" width=\"958\" height=\"72\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836347_996_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" alt=\"\u062f\u0633\u062a\u0648\u0631 conninfo \u06cc\u06a9 \u067e\u06cc\u0627\u0645 \u062a\u0627\u06cc\u06cc\u062f \u062e\u0631\u0648\u062c\u06cc \u0645\u06cc \u062f\u0647\u062f on \u067e\u0627\u06cc\u0627\u0646\u0647\" class=\"wp-image-93042\" srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836347_996_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 958w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-conninfo-command-outputs-a-confirmation-message-on-Terminal-300x23.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-conninfo-command-outputs-a-confirmation-message-on-Terminal-150x11.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-conninfo-command-outputs-a-confirmation-message-on-Terminal-768x58.webp 768w\" sizes=\"(max-width: 958px) 100vw, 958px\" title=\"\"><\/figure>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062e\u0631\u0648\u062c \u0627\u0632 \u0627\u0639\u0644\u0627\u0646 PostgreSQL \u0648 \u0628\u0627\u0632\u06af\u0634\u062a \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0639\u0627\u062f\u06cc \u0633\u06cc\u0633\u062a\u0645\u060c \u0627\u0632 <strong>\u062e\u0631\u0648\u062c <\/strong>\u0641\u0631\u0645\u0627\u0646  \u062f\u0631 \u0636\u0645\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <strong>\\ q <\/strong>\u0628\u0631\u0627\u06cc \u062c\u062f\u0627 \u0634\u062f\u0646 \u0627\u0632 \u062c\u0644\u0633\u0647 \u062a\u0639\u0627\u0645\u0644\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647.<\/p>\n<h3 class=\"wp-block-heading\" id=\"h-4-change-user-password\"><span class=\"ez-toc-section\" id=\"4_%d8%b1%d9%85%d8%b2_%d8%b9%d8%a8%d9%88%d8%b1_%da%a9%d8%a7%d8%b1%d8%a8%d8%b1_%d8%b1%d8%a7_%d8%aa%d8%ba%db%8c%db%8c%d8%b1_%d8%af%d9%87%db%8c%d8%af\"><\/span><span class=\"ez-toc-section\" id=\"4_Change_User_Password\"><\/span>4. \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062f\u0646<strong> <\/strong>\u067e\u06cc\u0634 \u0641\u0631\u0636 <strong>postgres<\/strong> \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0646\u0642\u0634 \u0628\u0631\u0627\u06cc \u0628\u0647\u0628\u0648\u062f \u0627\u0645\u0646\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a.  \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0631\u0648\u0634 \u0627\u0646\u062c\u0627\u0645 \u0622\u0646 \u0622\u0645\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<ol>\n<li>\u0627\u0639\u0644\u0627\u0646 PostgreSQL \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0641\u0639\u0627\u0644 \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre>\n<ol start=\"2\">\n<li>\u0627\u06cc\u0646 \u0639\u0628\u0627\u0631\u062a \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f <strong>postgres<\/strong> \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u062d\u0633\u0627\u0628 \u06a9\u0627\u0631\u0628\u0631\u06cc.  \u062a\u0639\u0648\u06cc\u0636 \u0631\u0627 \u0641\u0631\u0627\u0645\u0648\u0634 \u0646\u06a9\u0646\u06cc\u062f <strong>\u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u062c\u062f\u06cc\u062f<\/strong> \u0628\u0627 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0648\u0627\u0642\u0639\u06cc \u0634\u0645\u0627:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">ALTER USER postgres PASSWORD 'NewPassword';<\/pre>\n<ol start=\"3\">\n<li>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u0628\u0627 \u0645\u0648\u0641\u0642\u06cc\u062a \u0627\u0639\u0645\u0627\u0644 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">\\p<\/pre>\n<ol start=\"4\">\n<li>\u0633\u0631\u0648\u06cc\u0633 PostgreSQL \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u062c\u062f\u062f \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo service postgresql restart<\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"155\" src=\"data:image\/svg+xml,%3Csvg%20xmlns=\" alt=\"Postgres \u062a\u0623\u06cc\u06cc\u062f\u06cc\u0647 \u0627\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u062a\u063a\u06cc\u06cc\u0631 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u062d\u0633\u0627\u0628 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f\" class=\"wp-image-93043\" data-lazy-srcset=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Postgres-returns-a-confirmation-about-the-account-password-change.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Postgres-returns-a-confirmation-about-the-account-password-change-300x45.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Postgres-returns-a-confirmation-about-the-account-password-change-150x23.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Postgres-returns-a-confirmation-about-the-account-password-change-768x116.webp 768w\" data-lazy-sizes=\"(max-width: 1024px) 100vw, 1024px\" data-lazy-src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836348_885_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" http: title=\"\"><img decoding=\"async\" width=\"1024\" height=\"155\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836348_885_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" alt=\"Postgres \u062a\u0623\u06cc\u06cc\u062f\u06cc\u0647 \u0627\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u062a\u063a\u06cc\u06cc\u0631 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u062d\u0633\u0627\u0628 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f\" class=\"wp-image-93043\" srcset=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Postgres-returns-a-confirmation-about-the-account-password-change.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Postgres-returns-a-confirmation-about-the-account-password-change-300x45.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Postgres-returns-a-confirmation-about-the-account-password-change-150x23.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Postgres-returns-a-confirmation-about-the-account-password-change-768x116.webp 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\" id=\"h-5-create-a-user-on-postgresql\"><span class=\"ez-toc-section\" id=\"5_%db%8c%da%a9_%da%a9%d8%a7%d8%b1%d8%a8%d8%b1_%d8%a7%db%8c%d8%ac%d8%a7%d8%af_%da%a9%d9%86%db%8c%d8%af_%d8%b1%d9%88%db%8c_postgresql\"><\/span><span class=\"ez-toc-section\" id=\"5_Create_a_User_on_PostgreSQL\"><\/span>5. \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u0631\u0648\u06cc PostgreSQL<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u0633\u0627\u0632\u0645\u0627\u0646\u062f\u0647\u06cc \u0645\u0646\u0627\u0633\u0628 \u062f\u0627\u062f\u0647 \u0647\u0627\u060c \u0628\u0647 \u0686\u0646\u062f\u06cc\u0646 \u06a9\u0627\u0631\u0628\u0631 PostgreSQL \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f.  \u0633\u0627\u062f\u0647 \u062a\u0631\u06cc\u0646 \u0631\u0627\u0647 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a <strong>\u062d\u0627\u0644\u062a \u062a\u0639\u0627\u0645\u0644\u06cc<\/strong>.  \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0631\u0627\u062d\u0644 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u0634\u0648\u062f:<\/p>\n<ol>\n<li>\u0633\u0648\u0626\u06cc\u0686 \u0628\u0647 <strong>postgres<\/strong> \u06a9\u0627\u0631\u0628\u0631:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo su - postgres<\/pre>\n<ol start=\"2\">\n<li>\u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 \u062c\u062f\u06cc\u062f \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">createuser --interactive<\/pre>\n<ol start=\"3\">\n<li>\u0646\u0627\u0645 \u062d\u0633\u0627\u0628 \u062c\u062f\u06cc\u062f PostgresQL \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f.  \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634\u060c \u0622\u0646 \u0627\u0633\u062a <strong>TheNewUser<\/strong>.<\/li>\n<li>\u0628\u0631\u0627\u06cc \u062a\u0627\u06cc\u06cc\u062f \u0646\u0642\u0634 \u062c\u062f\u06cc\u062f\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0648\u0627\u0631\u062f PostgreSQL \u0634\u0648\u06cc\u062f <strong>postgres<\/strong> \u062d\u0633\u0627\u0628:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre>\n<ol start=\"5\">\n<li>\u0647\u0645\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0631\u0627 \u0628\u0627 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">\\du<\/pre>\n<div>\n<p class=\"important\"><strong>\u0645\u0647\u0645!<\/strong> \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0628\u062e\u0634\u06cc \u0627\u0632 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0634\u06cc\u0648\u0647\u200c\u0647\u0627\u06cc \u0627\u0645\u0646\u06cc\u062a\u06cc \u0628\u0631\u0627\u06cc PostgreSQL\u060c \u0627\u0632 \u062f\u0627\u062f\u0646 \u0627\u0645\u062a\u06cc\u0627\u0632 \u0627\u0628\u0631\u06a9\u0627\u0631\u0628\u0631 \u0628\u0647 \u0646\u0642\u0634 \u062c\u062f\u06cc\u062f\u060c \u0645\u06af\u0631 \u062f\u0631 \u0645\u0648\u0627\u0631\u062f \u0636\u0631\u0648\u0631\u06cc\u060c \u062e\u0648\u062f\u062f\u0627\u0631\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<\/div>\n<p>\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u062e\u0631\u0648\u062c\u06cc \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627 \u0645\u0648\u0641\u0642\u06cc\u062a \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f <strong>TheNewUser<\/strong>.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"189\" src=\"data:image\/svg+xml,%3Csvg%20xmlns=\" alt=\"\u062a\u0631\u0645\u06cc\u0646\u0627\u0644 \u06a9\u0627\u0631\u0628\u0631 \u062c\u062f\u06cc\u062f PostgreSQL \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f\" class=\"wp-image-93044\" data-lazy-srcset=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-shows-the-new-PostgreSQL-user.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-shows-the-new-PostgreSQL-user-300x55.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-shows-the-new-PostgreSQL-user-150x28.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-shows-the-new-PostgreSQL-user-768x142.webp 768w\" data-lazy-sizes=\"(max-width: 1024px) 100vw, 1024px\" data-lazy-src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836349_99_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" http: title=\"\"><img decoding=\"async\" width=\"1024\" height=\"189\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836349_99_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" alt=\"\u062a\u0631\u0645\u06cc\u0646\u0627\u0644 \u06a9\u0627\u0631\u0628\u0631 \u062c\u062f\u06cc\u062f PostgreSQL \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f\" class=\"wp-image-93044\" srcset=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-shows-the-new-PostgreSQL-user.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-shows-the-new-PostgreSQL-user-300x55.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-shows-the-new-PostgreSQL-user-150x28.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-shows-the-new-PostgreSQL-user-768x142.webp 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\" id=\"h-6-create-a-database-on-postgresql\"><span class=\"ez-toc-section\" id=\"6_%db%8c%da%a9_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87_%d8%a7%db%8c%d8%ac%d8%a7%d8%af_%da%a9%d9%86%db%8c%d8%af_%d8%b1%d9%88%db%8c_postgresql\"><\/span><span class=\"ez-toc-section\" id=\"6_Create_a_Database_on_PostgreSQL\"><\/span>6. \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u0631\u0648\u06cc PostgreSQL<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>PostgreSQL \u0641\u0631\u0636 \u0645\u06cc \u06a9\u0646\u062f <a href=\"https:\/\/www.postgresql.org\/docs\/current\/user-manag.html\" data-wpel-link=\"external\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">\u0646\u0642\u0634<\/a> \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0647 \u0647\u0645\u06cc\u0646 \u0646\u0627\u0645 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.  \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u0627\u06af\u0631 \u0634\u0645\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f <strong>TheNewUser<\/strong> PostgreSQL \u0628\u0647 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627 \u0647\u0645\u0627\u0646 \u0646\u0642\u0634 \u062f\u0633\u062a\u0631\u0633\u06cc \u062e\u0648\u0627\u0647\u062f \u062f\u0627\u0634\u062a<strong> <\/strong>\u0646\u0627\u0645.<\/p>\n<div>\n<p class=\"important\"><strong>\u0645\u0647\u0645!<\/strong> PostgreSQL \u0627\u0632 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0628\u0631\u0627\u06cc \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.  \u062f\u0631 \u0645\u062b\u0627\u0644 \u0642\u0628\u0644\u06cc\u060c \u0634\u0645\u0627 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f \u06a9\u0647 \u0646\u0627\u0645\u06cc\u062f\u0647 \u0634\u0648\u062f <strong>TheNewUser<\/strong>.<\/p>\n<\/div>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0631\u0627\u062d\u0644 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0622\u0645\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<ol>\n<li>\u0628\u0631\u0627\u06cc \u062c\u0627\u0628\u062c\u0627\u06cc\u06cc \u0628\u0647 \u062d\u0627\u0644\u062a \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f <strong>postgres <\/strong>\u06a9\u0627\u0631\u0628\u0631 \u0648 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo -u postgres createdb TheNewUser<\/pre>\n<ol start=\"2\">\n<li>\u0628\u0631\u0627\u06cc \u0648\u0631\u0648\u062f \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f\u060c \u06cc\u06a9 \u062d\u0633\u0627\u0628 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0644\u06cc\u0646\u0648\u06a9\u0633 \u0628\u0627 \u0647\u0645\u06cc\u0646 \u0646\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f.  \u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u062d\u0627\u0648\u06cc \u062d\u0631\u0648\u0641 \u0628\u0632\u0631\u06af \u0627\u0633\u062a\u060c \u0622\u0646 \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f <strong>-\u0632\u0648\u0631-\u0628\u062f\u0646\u0627\u0645<\/strong> \u06af\u0632\u06cc\u0646\u0647.<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo adduser TheNewUser --force-badname<\/pre>\n<ol start=\"3\">\n<li>\u0627\u0639\u0644\u0627\u0646 \u062a\u0639\u0627\u0645\u0644\u06cc PostgreSQL \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062d\u0633\u0627\u0628 \u06a9\u0627\u0631\u0628\u0631\u06cc \u062c\u062f\u06cc\u062f \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo -u TheNewUser psql<\/pre>\n<ol start=\"4\">\n<li>\u0627\u062a\u0635\u0627\u0644 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u062a\u0623\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">\\conninfo<\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"102\" src=\"data:image\/svg+xml,%3Csvg%20xmlns=\" alt=\"\u062e\u0631\u0648\u062c\u06cc \u062a\u0631\u0645\u06cc\u0646\u0627\u0644 \u062a\u0627\u06cc\u06cc\u062f \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u06a9\u0627\u0631\u0628\u0631 \u062c\u062f\u06cc\u062f PostgreSQL \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f \u0645\u062a\u0635\u0644 \u0627\u0633\u062a\" class=\"wp-image-93045\" data-lazy-srcset=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-output-confirms-the-new-PostgreSQL-user-is-connected-to-the-new-database.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-output-confirms-the-new-PostgreSQL-user-is-connected-to-the-new-database-300x30.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-output-confirms-the-new-PostgreSQL-user-is-connected-to-the-new-database-150x15.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-output-confirms-the-new-PostgreSQL-user-is-connected-to-the-new-database-768x77.webp 768w\" data-lazy-sizes=\"(max-width: 1024px) 100vw, 1024px\" data-lazy-src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836350_256_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" http: title=\"\"><img decoding=\"async\" width=\"1024\" height=\"102\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836350_256_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" alt=\"\u062e\u0631\u0648\u062c\u06cc \u062a\u0631\u0645\u06cc\u0646\u0627\u0644 \u062a\u0627\u06cc\u06cc\u062f \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u06a9\u0627\u0631\u0628\u0631 \u062c\u062f\u06cc\u062f PostgreSQL \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f \u0645\u062a\u0635\u0644 \u0627\u0633\u062a\" class=\"wp-image-93045\" srcset=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-output-confirms-the-new-PostgreSQL-user-is-connected-to-the-new-database.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-output-confirms-the-new-PostgreSQL-user-is-connected-to-the-new-database-300x30.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-output-confirms-the-new-PostgreSQL-user-is-connected-to-the-new-database-150x15.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Terminal-output-confirms-the-new-PostgreSQL-user-is-connected-to-the-new-database-768x77.webp 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/figure>\n<\/div>\n<p>\u06a9\u0627\u0631\u0628\u0631 \u0627\u06a9\u0646\u0648\u0646 \u0628\u0627\u06cc\u062f \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f \u0645\u062a\u0635\u0644 \u0634\u0648\u062f \u0648 \u0628\u062a\u0648\u0627\u0646\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u062c\u062f\u06cc\u062f \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u062f.  \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0631\u06cc\u062f\u0627\u0631\u060c \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">CREATE TABLE buyers(usr_id INT PRIMARY KEY, usr_name VARCHAR(240) NOT NULL, usr_location VARCHAR(240) NOT NULL);<\/pre>\n<p>\u0647\u0646\u06af\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\u060c \u0634\u0634 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a PostgreSQL \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f:<\/p>\n<ul>\n<li><strong>\u06a9\u0644\u06cc\u062f \u0627\u0648\u0644\u06cc\u0647 <\/strong>&#8211; \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u0628\u0627\u0634\u062f.<\/li>\n<li><strong>\u06a9\u0644\u06cc\u062f \u062e\u0627\u0631\u062c\u06cc <\/strong>\u2013 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u0628\u0627\u06cc\u062f \u0628\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u062c\u062f\u0648\u0644 \u062f\u06cc\u06af\u0631 \u06cc\u06a9\u0633\u0627\u0646 \u0628\u0627\u0634\u062f.<\/li>\n<li><strong>\u062a\u0647\u06cc \u0646\u06cc\u0633\u062a <\/strong>&#8211; \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u062d\u0627\u0635\u0644 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u062e\u0627\u0644\u06cc \u0646\u06cc\u0633\u062a.<\/li>\n<li><strong>\u0628\u0631\u0631\u0633\u06cc<\/strong> &#8211; \u0645\u0642\u062f\u0627\u0631 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u0631\u0627 \u0637\u0648\u0631\u06cc \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0628\u0627\u06cc\u062f \u06cc\u06a9 \u0639\u0628\u0627\u0631\u062a \u0628\u0648\u0644\u06cc \u0631\u0627 \u06a9\u0647 \u06cc\u0627 &#8220;\u062f\u0631\u0633\u062a&#8221; \u06cc\u0627 &#8220;\u0646\u0627\u062f\u0631\u0633\u062a&#8221; \u0627\u0633\u062a\u060c \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u06a9\u0646\u062f.<\/li>\n<li><strong>\u0645\u0646\u062d\u0635\u0631 \u0628\u0641\u0631\u062f <\/strong>&#8211; \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u062f\u0631 \u0628\u06cc\u0646 \u062a\u0645\u0627\u0645 \u0631\u062f\u06cc\u0641 \u0647\u0627 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0647\u0633\u062a\u0646\u062f.<\/li>\n<li><strong>\u0627\u0633\u062a\u062b\u0646\u0627\u0621 <\/strong>&#8211; \u0627\u0632 \u0647\u0645\u067e\u0648\u0634\u0627\u0646\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u062f\u0631 \u062f\u0648 \u0631\u062f\u06cc\u0641 \u0647\u0646\u06af\u0627\u0645 \u0645\u0642\u0627\u06cc\u0633\u0647 \u062c\u0644\u0648\u06af\u06cc\u0631\u06cc \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<\/ul>\n<p>\u0628\u0631\u0627\u06cc \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0628\u0647 \u062c\u062f\u0648\u0644 \u062e\u0648\u062f\u060c \u0627\u0632 \u0639\u0628\u0627\u0631\u062a \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.  \u0641\u0631\u0627\u0645\u0648\u0634 \u0646\u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627 \u0631\u0627 \u0628\u0627 \u0645\u0642\u062f\u0627\u0631 \u0645\u0646\u0627\u0633\u0628 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06a9\u0646\u06cc\u062f \u0648 \u062a\u0639\u062f\u0627\u062f \u0631\u062f\u06cc\u0641 \u0647\u0627 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0622\u0646 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">INSERT INTO tablename (column1, column2, column3) VALUES (row1, row2, row3);<\/pre>\n<p>\u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062c\u062f\u0648\u0644\u060c \u0639\u0628\u0627\u0631\u062a \u0632\u06cc\u0631 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">SELECT * FROM tablename<\/pre>\n<h3 class=\"wp-block-heading\" id=\"h-7-configure-the-postgresql-server\"><span class=\"ez-toc-section\" id=\"7_%d8%b3%d8%b1%d9%88%d8%b1_postgresql_%d8%b1%d8%a7_%d9%be%db%8c%da%a9%d8%b1%d8%a8%d9%86%d8%af%db%8c_%da%a9%d9%86%db%8c%d8%af\"><\/span><span class=\"ez-toc-section\" id=\"7_Configure_the_PostgreSQL_Server\"><\/span>7. \u0633\u0631\u0648\u0631 PostgreSQL \u0631\u0627 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0633\u0631\u0648\u0631 PostgreSQL \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u06af\u0648\u0646\u0647 \u0627\u06cc \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0628\u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0646\u062f.  \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u060c \u0627\u062c\u0627\u0632\u0647 \u062f\u0647\u06cc\u062f \u0633\u0631\u0648\u0631 \u0628\u0627 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0628\u0647 \u062a\u0645\u0627\u0645 \u0622\u062f\u0631\u0633 \u0647\u0627\u06cc IP \u06af\u0648\u0634 \u062f\u0647\u062f.<\/p>\n<p>\u0642\u0628\u0644 \u0627\u0632 \u0627\u062f\u0627\u0645\u0647\u060c \u0627\u0632 <strong>\u062e\u0631\u0648\u062c <\/strong>\u062f\u0633\u062a\u0648\u0631 \u062e\u0631\u0648\u062c \u0627\u0632 \u067e\u0648\u0633\u062a\u0647 PostgreSQL \u0648 \u0628\u0627\u0632\u06af\u0634\u062a \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u0627\u0631\u0628\u0631 \u0639\u0627\u062f\u06cc \u0633\u06cc\u0633\u062a\u0645.  \u0633\u067e\u0633\u060c \u0627\u06cc\u0646 \u0645\u0631\u0627\u062d\u0644 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f:<\/p>\n<ol>\n<li>\u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0648\u06cc\u0631\u0627\u06cc\u0634\u06af\u0631 \u0645\u062a\u0646 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.  \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06a9\u0631\u062f\u0646 <strong>vim <\/strong>\u0627\u06af\u0631 \u0627\u0632 \u0648\u06cc\u0631\u0627\u06cc\u0634\u06af\u0631 \u062f\u06cc\u06af\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f \u0648 \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0631\u0627 \u0645\u0637\u0627\u0628\u0642 \u0628\u0627 \u0622\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc \u062f\u0647\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">vim \/etc\/postgresql\/14\/main\/postgresql.conf<\/pre>\n<ol start=\"2\">\n<li>\u067e\u06cc\u062f\u0627 \u06a9\u0646 <strong>\u06af\u0648\u0634_\u0622\u062f\u0631\u0633 \u0647\u0627<\/strong> \u062e\u0637<\/li>\n<li>\u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f <strong># <\/strong>\u0639\u0644\u0627\u0645\u062a \u0628\u0632\u0646\u06cc\u062f \u0648 \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u0628\u0647 \u0633\u062a\u0627\u0631\u0647 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.  \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0686\u06af\u0648\u0646\u0647 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0646\u0638\u0631 \u0628\u0631\u0633\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">listen_addresses=\"*\"<\/pre>\n<ol start=\"4\">\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <strong>:wq<\/strong> \u062f\u0633\u062a\u0648\u0631 \u0630\u062e\u06cc\u0631\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0648 \u062e\u0631\u0648\u062c <strong>vim<\/strong>.<\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"56\" src=\"data:image\/svg+xml,%3Csvg%20xmlns=\" alt=\"\u062e\u0637 \u0622\u062f\u0631\u0633 \u06af\u0648\u0634 \u062f\u0631 \u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc PostgreSQL\" class=\"wp-image-93046\" data-lazy-srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836351_856_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-listen-address-line-in-the-PostgreSQL-configuration-file-300x16.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-listen-address-line-in-the-PostgreSQL-configuration-file-150x8.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-listen-address-line-in-the-PostgreSQL-configuration-file-768x42.webp 768w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-listen-address-line-in-the-PostgreSQL-configuration-file.webp 1062w\" data-lazy-sizes=\"(max-width: 1024px) 100vw, 1024px\" data-lazy-src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836351_856_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" http: title=\"\"><img decoding=\"async\" width=\"1024\" height=\"56\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836351_856_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" alt=\"\u062e\u0637 \u0622\u062f\u0631\u0633 \u06af\u0648\u0634 \u062f\u0631 \u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc PostgreSQL\" class=\"wp-image-93046\" srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836351_856_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-listen-address-line-in-the-PostgreSQL-configuration-file-300x16.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-listen-address-line-in-the-PostgreSQL-configuration-file-150x8.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-listen-address-line-in-the-PostgreSQL-configuration-file-768x42.webp 768w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-listen-address-line-in-the-PostgreSQL-configuration-file.webp 1062w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/figure>\n<\/div>\n<ol start=\"5\">\n<li>\u062e\u0637 \u0645\u0634\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u0623\u06cc\u06cc\u062f \u0627\u0639\u062a\u0628\u0627\u0631 \u0627\u062a\u0635\u0627\u0644 \u0645\u0634\u062a\u0631\u06cc \u0628\u0647 \u0633\u0631\u0648\u0631 PostgreSQL \u062e\u0648\u062f \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f.  \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u060c \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f <strong>pg_hba.conf<\/strong> \u0641\u0627\u06cc\u0644 \u062f\u0631 \u0647\u0645\u0627\u0646 \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <strong>vim<\/strong>.  \u062f\u0633\u062a\u0648\u0631 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">vim \/etc\/postgresql\/14\/main\/pg_hba.conf<\/pre>\n<ol start=\"6\">\n<li>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u06cc\u06a9 \u062e\u0637 \u0645\u0634\u06cc \u062c\u062f\u06cc\u062f \u062f\u0631 \u067e\u0627\u06cc\u06cc\u0646 \u0641\u0627\u06cc\u0644 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">connection database user ip_address encryption<\/pre>\n<ol start=\"7\">\n<li>\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0645\u0627 \u062a\u0645\u0627\u0645 \u0627\u062a\u0635\u0627\u0644\u0627\u062a TCP\/IP \u0631\u0627 \u0627\u0632 \u0647\u0645\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0628\u0647 \u0647\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0641\u0639\u0627\u0644 \u0645\u06cc \u06a9\u0646\u06cc\u0645.  \u0627\u06cc\u0646 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0632 \u0647\u0631 \u0622\u062f\u0631\u0633 IP \u0628\u0627 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0631\u0645\u0632\u06af\u0630\u0627\u0631\u06cc \u0634\u062f\u0647 MD5 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0646\u062f.  \u0642\u0627\u0639\u062f\u0647 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">host all all 0.0.0.0\/0 md5<\/pre>\n<ol start=\"8\">\n<li>\u0628\u0631\u0627\u06cc \u0627\u0639\u0645\u0627\u0644 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a\u060c \u0633\u0631\u0648\u06cc\u0633 PostgreSQL \u0631\u0627 \u0645\u062c\u062f\u062f\u0627 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ol>\n<h3 class=\"wp-block-heading\" id=\"h-8-set-up-a-remote-database-connection\"><span class=\"ez-toc-section\" id=\"8_%db%8c%da%a9_%d8%a7%d8%aa%d8%b5%d8%a7%d9%84_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87_%d8%a7%d8%b2_%d8%b1%d8%a7%d9%87_%d8%af%d9%88%d8%b1_%d8%b1%d8%a7%d9%87_%d8%a7%d9%86%d8%af%d8%a7%d8%b2%db%8c_%da%a9%d9%86%db%8c%d8%af\"><\/span><span class=\"ez-toc-section\" id=\"8_Set_up_a_Remote_Database_Connection\"><\/span>8. \u06cc\u06a9 \u0627\u062a\u0635\u0627\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u067e\u0633 \u0627\u0632 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\u060c \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 PostgreSQL \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <strong>psql<\/strong> \u0641\u0631\u0645\u0627\u0646  \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u060c \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u062f\u0633\u062a\u0648\u0631\u06cc \u062f\u0631 \u0645\u0627\u0634\u06cc\u0646 \u06a9\u0644\u0627\u06cc\u0646\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">psql -h ip_address -p port -d database -U username<\/pre>\n<p>\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 TheNewUser \u06a9\u0647 \u062f\u0631 \u06cc\u06a9 VPS \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f <strong>185.185.185.185 <\/strong>\u0622\u062f\u0631\u0633 IP \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <strong>TheNewUser<\/strong> \u062d\u0633\u0627\u0628:<\/p>\n<pre class=\"wp-block-preformatted\">psql -h 185.185.185.185 -p 5432 -d TheNewUser -U TheNewUser<\/pre>\n<p>\u0628\u0647 \u06cc\u0627\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u067e\u0648\u0631\u062a \u067e\u06cc\u0634 \u0641\u0631\u0636 PostgreSQL \u0627\u0633\u062a <strong>5423<\/strong>.  \u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0645\u0648\u0641\u0642\u06cc\u062a \u0622\u0645\u06cc\u0632 \u0628\u0648\u062f\u0646 \u0627\u062a\u0635\u0627\u0644\u060c \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">\\conninfo<\/pre>\n<p>\u067e\u0633 \u0627\u0632 \u0627\u062a\u0635\u0627\u0644\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0631\u0633\u0627\u0644 \u06a9\u0646\u06cc\u062f.  \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 PostgreSQL \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u062e\u0648\u062f\u060c \u06cc\u06a9 \u062f\u0631\u0627\u06cc\u0648\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f \u0648 \u0645\u0627\u0698\u0648\u0644 \u0631\u0627 \u062f\u0631 \u06a9\u062f \u062e\u0648\u062f \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634\u060c \u0645\u0627 \u0628\u0647 \u0634\u0645\u0627 \u0646\u0634\u0627\u0646 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u067e\u0627\u06cc\u062a\u0648\u0646 \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 an \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f <strong>\u0627\u0648\u0628\u0648\u0646\u062a\u0648 20.04<\/strong> VPS.  \u067e\u0633 \u0627\u0632 \u0627\u062a\u0635\u0627\u0644 \u0627\u0632 \u0637\u0631\u06cc\u0642 SSH\u060c \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f:<\/p>\n<ol>\n<li>\u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f <strong>pip  \u0645\u062f\u06cc\u0631 \u0628\u0633\u062a\u0647 <\/strong>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631  \u0627\u06af\u0631 \u0642\u0628\u0644\u0627\u064b \u0622\u0646 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f\u060c \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0631\u0627 \u0631\u062f \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo apt-get install python-pip<\/pre>\n<ol start=\"2\">\n<li>\u0631\u0627 \u062f\u0627\u0646\u0644\u0648\u062f \u0648 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f <strong>psycopg2<\/strong> \u062f\u0631\u0627\u06cc\u0648\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 pip:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">pip install psycopg2-binary<\/pre>\n<ol start=\"3\">\n<li>\u062e\u0637 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0647 \u06a9\u062f \u0628\u0631\u0646\u0627\u0645\u0647 \u062e\u0648\u062f \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0645\u0627\u0698\u0648\u0644 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f \u0648 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0627\u0631\u062a\u0628\u0627\u0637 \u0628\u0631\u0642\u0631\u0627\u0631 \u06a9\u0646\u06cc\u062f.  \u0628\u0647 \u06cc\u0627\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u0645\u0637\u0627\u0628\u0642 \u0628\u0627 \u0622\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">import psycopg2\n# Connect your app to the remote database.\nconn = psycopg2.connect(host=\"182.182.182.182\", port=\"5432\", dbname=\"TestNewUser\", user=\"TestNewUser\", password=\"UserPassword\")\n# Open a cursor for database operations\ncur = conn.cursor()\n# Execute a query. Replace table with your own. \ncur.execute(\"SELECT * FROM table\")\n# Retrieve data\nrecords = cur.fetchall()<\/pre>\n<h3 class=\"wp-block-heading\" id=\"h-9-install-pgadmin\"><span class=\"ez-toc-section\" id=\"9_pgadmin_%d8%b1%d8%a7_%d9%86%d8%b5%d8%a8_%da%a9%d9%86%db%8c%d8%af\"><\/span><span class=\"ez-toc-section\" id=\"9_Install_pgAdmin\"><\/span>9. pgAdmin \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f<strong> pgAdmin<\/strong> \u0631\u0627\u0628\u0637 \u06a9\u0627\u0631\u0628\u0631\u06cc \u06af\u0631\u0627\u0641\u06cc\u06a9\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0648\u0628 \u0628\u0631\u0627\u06cc \u0633\u0627\u062f\u0647 \u06a9\u0631\u062f\u0646 \u0648\u0638\u0627\u06cc\u0641 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0634\u0645\u0627.  \u0645\u0627 \u0627\u0632 \u0645\u062f\u06cc\u0631 \u0628\u0633\u062a\u0647 APT \u0628\u0631\u0627\u06cc \u0646\u0635\u0628 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f:<\/p>\n<ol>\n<li>\u0628\u0631\u0627\u06cc \u0627\u0641\u0632\u0648\u062f\u0646 \u0645\u062e\u0632\u0646 \u0631\u0633\u0645\u06cc pgAdmin\u060c \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">curl -fsSL https:\/\/www.pgadmin.org\/static\/packages_pgadmin_org.pub | sudo gpg --dearmor -o \/etc\/apt\/trusted.gpg.d\/pgadmin.gpg\n\nsudo sh -c 'echo \"deb https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/apt\/$(lsb_release -cs) pgadmin4 main\" &gt; \/etc\/apt\/sources.list.d\/pgadmin4.list'<\/pre>\n<ol start=\"2\">\n<li>\u0644\u06cc\u0633\u062a \u0647\u0627\u06cc \u0628\u0633\u062a\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0647\u0645\u06af\u0627\u0645 \u0633\u0627\u0632\u06cc \u0645\u062e\u0632\u0646 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo apt update<\/pre>\n<ol start=\"3\">\n<li>\u0628\u0631\u0627\u06cc \u0646\u0635\u0628 pgAdmin \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo apt install pgadmin4<\/pre>\n<ol start=\"4\">\n<li>\u067e\u0633 \u0627\u0632 \u0627\u062a\u0645\u0627\u0645 \u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u0631\u0627\u0628\u0637 \u06a9\u0627\u0631\u0628\u0631\u06cc \u06af\u0631\u0627\u0641\u06cc\u06a9\u06cc\u060c \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0627\u0648\u0644\u06cc\u0647 pgAdmin \u0631\u0627 \u0628\u0627 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0622\u063a\u0627\u0632 \u06a9\u0646\u06cc\u062f:<\/li>\n<\/ol>\n<pre class=\"wp-block-preformatted\">sudo \/usr\/pgadmin4\/bin\/setup-web.sh<\/pre>\n<ol start=\"5\">\n<li>\u0622\u062f\u0631\u0633 \u0627\u06cc\u0645\u06cc\u0644 \u0648 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u062e\u0648\u062f \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f.  \u0628\u0627\u06cc\u062f \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"333\" src=\"data:image\/svg+xml,%3Csvg%20xmlns=\" alt=\"\u0627\u0633\u06a9\u0631\u06cc\u067e\u062a bash \u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc pgAdmin\" class=\"wp-image-93047\" data-lazy-srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836353_372_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-bash-script-to-initiate-pgAdmin-configuration-300x97.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-bash-script-to-initiate-pgAdmin-configuration-150x49.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-bash-script-to-initiate-pgAdmin-configuration-768x249.webp 768w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-bash-script-to-initiate-pgAdmin-configuration.webp 1238w\" data-lazy-sizes=\"(max-width: 1024px) 100vw, 1024px\" data-lazy-src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836353_372_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" http: title=\"\"><img decoding=\"async\" width=\"1024\" height=\"333\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836353_372_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" alt=\"\u0627\u0633\u06a9\u0631\u06cc\u067e\u062a bash \u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc pgAdmin\" class=\"wp-image-93047\" srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836353_372_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-bash-script-to-initiate-pgAdmin-configuration-300x97.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-bash-script-to-initiate-pgAdmin-configuration-150x49.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-bash-script-to-initiate-pgAdmin-configuration-768x249.webp 768w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-bash-script-to-initiate-pgAdmin-configuration.webp 1238w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/figure>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u0631\u0627\u0628\u0637 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0648\u0628 pgAdmin\u060c \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0631 \u0646\u0648\u0627\u0631 \u0622\u062f\u0631\u0633 \u0645\u0631\u0648\u0631\u06af\u0631 \u0648\u0628 \u062e\u0648\u062f \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">185.185.185.185\/pgadmin4<\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"851\" height=\"543\" src=\"data:image\/svg+xml,%3Csvg%20xmlns=\" alt=\"\u0635\u0641\u062d\u0647 \u0648\u0631\u0648\u062f \u0628\u0631\u0627\u06cc pgAdmin GUI \u0628\u0627 \u062f\u06a9\u0645\u0647 \u0648\u0631\u0648\u062f \u0628\u0631\u062c\u0633\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a\" class=\"wp-image-93048\" data-lazy-srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836355_152_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 851w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Login-screen-for-pgAdmin-GUI-with-the-login-button-highlighted-300x191.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Login-screen-for-pgAdmin-GUI-with-the-login-button-highlighted-150x96.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Login-screen-for-pgAdmin-GUI-with-the-login-button-highlighted-768x490.webp 768w\" data-lazy-sizes=\"(max-width: 851px) 100vw, 851px\" data-lazy-src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836355_152_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" http: title=\"\"><img decoding=\"async\" width=\"851\" height=\"543\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836355_152_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" alt=\"\u0635\u0641\u062d\u0647 \u0648\u0631\u0648\u062f \u0628\u0631\u0627\u06cc pgAdmin GUI \u0628\u0627 \u062f\u06a9\u0645\u0647 \u0648\u0631\u0648\u062f \u0628\u0631\u062c\u0633\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a\" class=\"wp-image-93048\" srcset=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836355_152_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp 851w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Login-screen-for-pgAdmin-GUI-with-the-login-button-highlighted-300x191.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Login-screen-for-pgAdmin-GUI-with-the-login-button-highlighted-150x96.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/Login-screen-for-pgAdmin-GUI-with-the-login-button-highlighted-768x490.webp 768w\" sizes=\"(max-width: 851px) 100vw, 851px\" title=\"\"><\/figure>\n<\/div>\n<p>\u0622\u062f\u0631\u0633 IP \u0631\u0627 \u0628\u0627 VPS \u062e\u0648\u062f \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06a9\u0646\u06cc\u062f.  \u0633\u067e\u0633 \u0622\u062f\u0631\u0633 \u0627\u06cc\u0645\u06cc\u0644 \u0648 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u062e\u0648\u062f \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f.  \u06a9\u0644\u06cc\u06a9 <strong>\u0648\u0627\u0631\u062f \u0634\u062f\u0646<\/strong> \u0628\u0631\u0627\u06cc \u0648\u0631\u0648\u062f \u0628\u0647<strong> <\/strong>\u062f\u0627\u0634\u0628\u0648\u0631\u062f \u0627\u0635\u0644\u06cc pgAdmin.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 PostgreSQL\u060c \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f <strong>\u0627\u0641\u0632\u0648\u062f\u0646 \u0633\u0631\u0648\u0631 \u062c\u062f\u06cc\u062f<\/strong> \u0648 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0631\u0627 \u0627\u062f\u0627\u0645\u0647 \u062f\u0647\u06cc\u062f process.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"824\" src=\"data:image\/svg+xml,%3Csvg%20xmlns=\" alt=\"\u067e\u0646\u062c\u0631\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0627\u0635\u0644\u06cc pgAdmin \u0628\u0627 \u062f\u06a9\u0645\u0647 Add New Server \u0628\u0631\u062c\u0633\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a\" class=\"wp-image-93049\" data-lazy-srcset=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-main-management-window-for-pgAdmin-with-the-Add-New-Server-button-highlighted.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-main-management-window-for-pgAdmin-with-the-Add-New-Server-button-highlighted-300x241.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-main-management-window-for-pgAdmin-with-the-Add-New-Server-button-highlighted-150x121.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-main-management-window-for-pgAdmin-with-the-Add-New-Server-button-highlighted-768x618.webp 768w\" data-lazy-sizes=\"(max-width: 1024px) 100vw, 1024px\" data-lazy-src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836357_254_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" http: title=\"\"><img decoding=\"async\" width=\"1024\" height=\"824\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703836357_254_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-PostgreSQL-on-Ubuntu-\u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc-\u0645\u062f\u06cc\u0631\u06cc\u062a.webp.webp\" alt=\"\u067e\u0646\u062c\u0631\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0627\u0635\u0644\u06cc pgAdmin \u0628\u0627 \u062f\u06a9\u0645\u0647 Add New Server \u0628\u0631\u062c\u0633\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a\" class=\"wp-image-93049\" srcset=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-main-management-window-for-pgAdmin-with-the-Add-New-Server-button-highlighted.webp 1024w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-main-management-window-for-pgAdmin-with-the-Add-New-Server-button-highlighted-300x241.webp 300w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-main-management-window-for-pgAdmin-with-the-Add-New-Server-button-highlighted-150x121.webp 150w,https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/03\/The-main-management-window-for-pgAdmin-with-the-Add-New-Server-button-highlighted-768x618.webp 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\" id=\"h-troubleshooting-postgresql-installation\"><span class=\"ez-toc-section\" id=\"%d8%b9%db%8c%d8%a8_%db%8c%d8%a7%d8%a8%db%8c_%d9%86%d8%b5%d8%a8_postgresql\"><\/span><span class=\"ez-toc-section\" id=\"Troubleshooting_PostgreSQL_Installation\"><\/span>\u0639\u06cc\u0628 \u06cc\u0627\u0628\u06cc \u0646\u0635\u0628 PostgreSQL<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0628\u062e\u0634\u060c \u0645\u0633\u0627\u0626\u0644 \u0631\u0627\u06cc\u062c \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0646\u0635\u0628 PostgreSQL \u0648 \u0631\u0627\u0647 \u062d\u0644 \u0647\u0627\u06cc \u0622\u0646 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.<\/p>\n<h3 class=\"wp-block-heading\" id=\"h-1-unable-to-connect-to-postgresql-server\"><span class=\"ez-toc-section\" id=\"1_%d8%a7%d9%85%da%a9%d8%a7%d9%86_%d8%a7%d8%aa%d8%b5%d8%a7%d9%84_%d8%a8%d9%87_%d8%b3%d8%b1%d9%88%d8%b1_postgresql_%d9%88%d8%ac%d9%88%d8%af_%d9%86%d8%af%d8%a7%d8%b1%d8%af\"><\/span><span class=\"ez-toc-section\" id=\"1_Unable_to_Connect_to_PostgreSQL_Server\"><\/span>1. \u0627\u0645\u06a9\u0627\u0646 \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u0633\u0631\u0648\u0631 PostgreSQL \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0633\u06cc\u0633\u062a\u0645 \u0645\u0634\u062a\u0631\u06cc \u0628\u0647 \u062f\u0631\u0633\u062a\u06cc \u0628\u0647 \u0627\u06cc\u0646\u062a\u0631\u0646\u062a \u0645\u062a\u0635\u0644 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631.  \u0627\u06af\u0631 \u0645\u0634\u06a9\u0644 \u0627\u062a\u0635\u0627\u0644 \u0627\u06cc\u0646\u062a\u0631\u0646\u062a \u0646\u06cc\u0633\u062a\u060c \u0633\u0627\u06cc\u0631 \u062f\u0644\u0627\u06cc\u0644 \u0631\u0627\u06cc\u062c \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u062e\u0637\u0627 \u0634\u0627\u0645\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u063a\u06cc\u0631\u0641\u0639\u0627\u0644 \u06cc\u0627 \u0645\u062c\u0648\u0632 \u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0646\u0627\u062f\u0631\u0633\u062a \u0627\u0633\u062a.<\/p>\n<p>\u0648\u0636\u0639\u06cc\u062a PostgreSQL \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u0648 \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u0647\u0633\u062a <strong>\u0644\u0648\u062f \u0634\u062f\u0647 <\/strong>\u0648 <strong>\u0641\u0639\u0627\u0644<\/strong>.  \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0622\u0646 \u0631\u0627 \u0631\u06cc\u0633\u062a\u0627\u0631\u062a \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">sudo systemctl restart postgresql<\/pre>\n<p>\u0627\u06af\u0631 \u06a9\u0627\u0631 \u0646\u06a9\u0631\u062f\u060c \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0645\u062c\u0648\u0632\u0647\u0627\u06cc \u067e\u0648\u0634\u0647 \u0648 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc PostgreSQL \u0631\u0648\u06cc \u062a\u0646\u0638\u06cc\u0645 \u0634\u062f\u0647 \u0627\u0646\u062f \u06cc\u0627 \u062e\u06cc\u0631 <strong>0700<\/strong> \u0648 <strong>0600<\/strong>.  \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">ls \/var\/lib\/postgresql\/main<\/pre>\n<p>\u0633\u067e\u0633\u060c \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <strong>chmod <\/strong>\u062f\u0633\u062a\u0648\u0631 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u062c\u0648\u0632\u0647\u0627\u06cc \u0622\u0646\u0647\u0627.<\/p>\n<h3 class=\"wp-block-heading\" id=\"h-2-postgresql-connection-issues-from-remote-host\"><span class=\"ez-toc-section\" id=\"2_%d9%85%d8%b4%da%a9%d9%84%d8%a7%d8%aa_%d8%a7%d8%aa%d8%b5%d8%a7%d9%84_postgresql_%d8%a7%d8%b2_%d9%85%db%8c%d8%b2%d8%a8%d8%a7%d9%86_%d8%b1%d8%a7%d9%87_%d8%af%d9%88%d8%b1\"><\/span><span class=\"ez-toc-section\" id=\"2_PostgreSQL_Connection_Issues_from_Remote_Host\"><\/span>2. \u0645\u0634\u06a9\u0644\u0627\u062a \u0627\u062a\u0635\u0627\u0644 PostgreSQL \u0627\u0632 \u0645\u06cc\u0632\u0628\u0627\u0646 \u0631\u0627\u0647 \u062f\u0648\u0631<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u06cc\u06a9 \u062e\u0637 \u0645\u0634\u06cc \u0627\u062a\u0635\u0627\u0644 \u0627\u0634\u062a\u0628\u0627\u0647 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0634\u062f\u0647 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0627\u0639\u062b \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0634\u0648\u062f host \u0645\u0634\u06a9\u0644\u0627\u062a\u06cc \u06a9\u0647 \u0645\u0627\u0646\u0639 \u0627\u0632 \u062f\u0633\u062a\u0631\u0633\u06cc \u0634\u0645\u0627 \u0628\u0647 \u0633\u0631\u0648\u0631 PostgreSQL \u0645\u06cc \u0634\u0648\u062f.  \u0628\u0631\u0627\u06cc \u062d\u0644 \u0622\u0646\u060c \u062e\u0648\u062f \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f <strong>pg_hba.conf<\/strong> \u0641\u0627\u06cc\u0644 \u0648 \u0633\u06cc\u0627\u0633\u062a \u062f\u0633\u062a\u0631\u0633\u06cc \u0631\u0627 \u0627\u0632 \u0622\u062f\u0631\u0633 IP \u0647\u0631 \u0645\u0634\u062a\u0631\u06cc \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">host all all 0.0.0.0\/0 md5<\/pre>\n<p>\u0633\u067e\u0633\u060c \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f <strong>\u06af\u0648\u0634_\u0622\u062f\u0631\u0633 <\/strong>\u0627\u0631\u0632\u0634 \u062f\u0631 \u0634\u0645\u0627 <strong>postgres.conf <\/strong>\u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc.  \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u062f\u0627\u0631\u0627\u06cc \u06cc\u06a9 <strong>\u0633\u062a\u0627\u0631\u0647<\/strong> \u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u0627\u06cc\u0646\u06a9\u0647 PostgreSQL \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u062a\u0645\u0627\u0645 \u0622\u062f\u0631\u0633 \u0647\u0627\u06cc IP \u06af\u0648\u0634 \u062f\u0647\u062f.<\/p>\n<p>\u0627\u06af\u0631 \u06a9\u0627\u0631 \u0646\u06a9\u0631\u062f\u060c \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0641\u0627\u06cc\u0631\u0648\u0627\u0644 \u0634\u0645\u0627 \u067e\u0648\u0631\u062a \u06af\u0648\u0634 \u062f\u0627\u062f\u0646 PostgreSQL \u0631\u0627 \u0645\u06cc \u0628\u0646\u062f\u062f.  \u0628\u0631\u0627\u06cc \u0633\u0631\u0648\u0631 \u0627\u0648\u0628\u0648\u0646\u062a\u0648\u060c \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f <strong>ufw <\/strong>\u062f\u0633\u062a\u0648\u0631:<\/p>\n<pre class=\"wp-block-preformatted\">sudo ufw status verbose<\/pre>\n<p>\u0627\u06af\u0631 \u0627\u062a\u0635\u0627\u0644 \u0627\u0632 \u0648 \u0628\u0647 \u067e\u0648\u0631\u062a <strong>5432<\/strong> \u063a\u06cc\u0631 \u0641\u0639\u0627\u0644 \u0627\u0633\u062a\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0622\u0646 \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">sudo ufw allow 5432\/tcp <\/pre>\n<div class=\"protip\">\n<h4 class=\"title\">\u062f\u0631\u0628\u0627\u0631\u0647 \u0641\u0627\u06cc\u0631\u0648\u0627\u0644 \u0627\u0648\u0628\u0648\u0646\u062a\u0648 \u0628\u06cc\u0634\u062a\u0631 \u0628\u062f\u0627\u0646\u06cc\u062f<\/h4>\n<p>  \u0628\u0631\u0627\u06cc \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0631\u0648\u0634 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0641\u0627\u06cc\u0631\u0648\u0627\u0644 \u0627\u0648\u0628\u0648\u0646\u062a\u0648 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0641\u0627\u06cc\u0631\u0648\u0627\u0644 \u0628\u062f\u0648\u0646 \u0639\u0627\u0631\u0636\u0647 (UFW) \u0645\u0642\u0627\u0644\u0647 \u062f\u06cc\u06af\u0631 \u0645\u0627 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<\/p><\/div>\n<h3 class=\"wp-block-heading\" id=\"h-3-pgadmin-login-issues\"><span class=\"ez-toc-section\" id=\"3_%d9%85%d8%b4%da%a9%d9%84%d8%a7%d8%aa_%d9%88%d8%b1%d9%88%d8%af_pgadmin\"><\/span><span class=\"ez-toc-section\" id=\"3_pgAdmin_Login_Issues\"><\/span>3. \u0645\u0634\u06a9\u0644\u0627\u062a \u0648\u0631\u0648\u062f pgAdmin<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0645\u0634\u06a9\u0644\u0627\u062a \u0648\u0631\u0648\u062f pgAdmin \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0647 \u062f\u0644\u06cc\u0644 \u06cc\u06a9 \u062e\u0637\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u062e \u062f\u0647\u062f.  \u0627\u06af\u0631 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0634\u0628\u06a9\u0647 \u0627\u0633\u062a\u060c \u0631\u0627\u0647 \u062d\u0644 \u0647\u0627\u06cc \u0642\u0628\u0644\u06cc \u0631\u0627 \u0627\u0645\u062a\u062d\u0627\u0646 \u06a9\u0646\u06cc\u062f \u0648 pgAdmin \u0631\u0627 \u0645\u062c\u062f\u062f\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0627\u06af\u0631 \u0645\u0634\u06a9\u0644 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0627\u0639\u062a\u0628\u0627\u0631 \u0648\u0631\u0648\u062f \u0628\u0647 \u062d\u0633\u0627\u0628 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0627\u0633\u062a\u060c \u0622\u0646 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f <strong>psql <\/strong>\u062c\u0644\u0633\u0647<strong> <\/strong>\u0648 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0639\u0628\u0627\u0631\u062a \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0631\u0627 \u0628\u0627\u0632\u0646\u0634\u0627\u0646\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">ALTER USER username WITH PASSWORD 'new_password';<\/pre>\n<p>\u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u06af\u0631 \u06a9\u0627\u0631\u0628\u0631 \u0622\u0646 \u0631\u0627 \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0627 \u0645\u0634\u06a9\u0644\u0627\u062a \u0648\u0631\u0648\u062f \u0645\u0648\u0627\u062c\u0647 \u0634\u0648\u06cc\u062f<strong> \u0648\u0627\u0631\u062f \u0634\u062f\u0646<\/strong> \u0627\u0645\u062a\u06cc\u0627\u0632  \u0628\u0631\u0627\u06cc \u0627\u0639\u0637\u0627\u06cc \u06cc\u06a9\u060c \u0627\u0632 \u0639\u0628\u0627\u0631\u062a \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">ALTER USER username WITH LOGIN;<\/pre>\n<h3 class=\"wp-block-heading\" id=\"h-4-postgresql-version-conflict\"><span class=\"ez-toc-section\" id=\"4_%d8%aa%d8%b6%d8%a7%d8%af_%d9%86%d8%b3%d8%ae%d9%87_postgresql\"><\/span><span class=\"ez-toc-section\" id=\"4_PostgreSQL_Version_Conflict\"><\/span>4. \u062a\u0636\u0627\u062f \u0646\u0633\u062e\u0647 PostgreSQL<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062a\u0636\u0627\u062f \u0646\u0633\u062e\u0647 \u0632\u0645\u0627\u0646\u06cc \u0631\u062e \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 PostgreSQL \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06cc\u0627 \u0633\u0627\u06cc\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627 \u0646\u0627\u0633\u0627\u0632\u06af\u0627\u0631 \u0628\u0627\u0634\u062f.  \u0639\u0644\u062a \u0631\u0627\u06cc\u062c \u0622\u0646 \u0634\u0627\u0645\u0644 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0646\u0634\u062f\u0646 PostgreSQL \u0627\u0633\u062a \u06a9\u0647 \u0645\u0646\u062c\u0631 \u0628\u0647 \u0639\u062f\u0645 \u062a\u0637\u0627\u0628\u0642 \u0646\u0633\u062e\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u062d\u0644 \u0622\u0646\u060c PostgreSQL \u0631\u0627 \u0627\u0632 \u0645\u062e\u0632\u0646 \u0631\u0633\u0645\u06cc APT \u062f\u0648\u0628\u0627\u0631\u0647 \u0646\u0635\u0628 \u06cc\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u062f.  \u0647\u0645\u0686\u0646\u06cc\u0646\u060c \u0647\u0645\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0634\u062e\u0635 \u062b\u0627\u0644\u062b \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u062f \u0632\u06cc\u0631\u0627 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0642\u062f\u06cc\u0645\u06cc \u0628\u0627\u0634\u0646\u062f.<\/p>\n<p>\u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u062c\u062f\u06cc\u062f\u062a\u0631\u06cc\u0646 \u0646\u0633\u062e\u0647 \u0631\u0627 \u062f\u0631 \u0645\u062d\u06cc\u0637 \u062a\u0648\u0633\u0639\u0647 \u0622\u0632\u0645\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0627\u0632 \u0645\u0634\u06a9\u0644\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 \u062f\u0631 \u0633\u0631\u0648\u0631 \u0632\u0646\u062f\u0647 \u062c\u0644\u0648\u06af\u06cc\u0631\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<h3 class=\"wp-block-heading\" id=\"h-5-unable-to-create-postgresql-user-or-database\"><span class=\"ez-toc-section\" id=\"5_%d8%a7%d9%85%da%a9%d8%a7%d9%86_%d8%a7%db%8c%d8%ac%d8%a7%d8%af_%da%a9%d8%a7%d8%b1%d8%a8%d8%b1_%db%8c%d8%a7_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87_postgresql_%d9%88%d8%ac%d9%88%d8%af_%d9%86%d8%af%d8%a7%d8%b1%d8%af\"><\/span><span class=\"ez-toc-section\" id=\"5_Unable_to_Create_PostgreSQL_User_or_Database\"><\/span>5. \u0627\u0645\u06a9\u0627\u0646 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0627\u0631\u0628\u0631 \u06cc\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 \u062f\u0633\u062a\u0648\u0631 \u0646\u0627\u062f\u0631\u0633\u062a \u0627\u063a\u0644\u0628 \u0628\u0627\u0639\u062b \u0627\u06cc\u062c\u0627\u062f \u062e\u0637\u0627\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 PostgreSQL \u0648 \u0627\u06cc\u062c\u0627\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.  \u0628\u0631\u0627\u06cc \u0631\u0641\u0639 \u0622\u0646\u060c \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u062f\u0633\u062a\u0648\u0631 \u0634\u0645\u0627 \u0628\u0627 \u0646\u0642\u0637\u0647 \u0648\u06cc\u0631\u06af\u0648\u0644 \u0628\u0647 \u067e\u0627\u06cc\u0627\u0646 \u0645\u06cc \u0631\u0633\u062f (<strong>;<\/strong>).<\/p>\n<p>\u0647\u0645\u0686\u0646\u06cc\u0646\u060c \u0628\u0627\u06cc\u062f \u062f\u0633\u062a\u0648\u0631 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <strong>postgres<\/strong> \u06a9\u0627\u0631\u0628\u0631 \u0648 <strong>psql <\/strong>\u062e\u0637 \u0641\u0631\u0645\u0627\u0646.  \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u060c \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre>\n<p>\u0627\u06af\u0631 \u062a\u0631\u0645\u06cc\u0646\u0627\u0644 \u0634\u0645\u0627 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f\u060c \u0628\u0627\u06cc\u062f \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f.<\/p>\n<pre class=\"wp-block-preformatted\">postgres=#<\/pre>\n<div class=\"protip\">\n<h4 class=\"title\">\u062f\u0631\u0628\u0627\u0631\u0647 PostgreSQL \u0648 VPS \u0628\u06cc\u0634\u062a\u0631 \u0628\u06cc\u0627\u0645\u0648\u0632\u06cc\u062f<\/h4>\n<p>\u0631\u0648\u0634 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc VPS<br \/>\nVPS \u0686\u06cc\u0633\u062a<br \/>\n\u0631\u0648\u0634 \u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc CentOS7<\/p>\n<\/p><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-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>PostgreSQL \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u0646\u0628\u0639 \u0628\u0627\u0632 \u0648 \u062c\u0627\u0645\u0639\u0647 \u0645\u062d\u0648\u0631 \u0627\u0633\u062a.  \u0627\u0632 \u06cc\u06a9 \u0633\u0627\u062e\u062a\u0627\u0631 \u0645\u0646\u0637\u0642\u06cc \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0645\u0648\u062b\u0631 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0627\u062f\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0633\u0627\u062f\u0647 \u06a9\u0631\u062f\u0646 \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0645\u0631\u0627\u062d\u0644 \u0646\u0635\u0628 PostgreSQL \u0631\u0627 \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645 \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648 20.04 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062e\u0637 \u0641\u0631\u0645\u0627\u0646 \u0644\u06cc\u0646\u0648\u06a9\u0633.  \u0627\u06cc\u0646 \u0647\u0645 \u062e\u0644\u0627\u0635\u0647:<\/p>\n<ol>\n<li>PostgreSQL \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062e\u0632\u0646 \u0631\u0633\u0645\u06cc \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f <strong>APT<\/strong>.<\/li>\n<li>\u0627\u062c\u0631\u0627 \u06a9\u0646 <strong>\u0648\u0636\u0639\u06cc\u062a systemctl <\/strong>\u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0627\u06cc\u0646\u06a9\u0647 Postgresql \u0641\u0639\u0627\u0644 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631.<\/li>\n<li>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062d\u0633\u0627\u0628 PostgreSQL \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f <strong>sudo su \u2013 postgres<\/strong>.<\/li>\n<li>\u0628\u0631\u0627\u06cc \u0628\u0647\u0628\u0648\u062f \u0627\u0645\u0646\u06cc\u062a\u060c \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u062d\u0633\u0627\u0628 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n<li>\u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 PostgreSQL \u062c\u062f\u06cc\u062f \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <strong>\u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0628 <\/strong>\u0641\u0631\u0645\u0627\u0646<\/li>\n<li>\u0633\u0631\u0648\u0631 PostgreSQL \u0631\u0627 \u0628\u0627 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u062e\u0637 \u0645\u0634\u06cc \u0627\u062a\u0635\u0627\u0644 \u0622\u0646 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u06cc\u06a9 \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0631\u0627\u0647 \u062f\u0648\u0631 \u062e\u0648\u062f \u0631\u0627 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f.<\/li>\n<li>pgAdmin \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0631\u0627\u0626\u0647 \u06cc\u06a9 \u0631\u0627\u0628\u0637 \u06a9\u0627\u0631\u0628\u0631\u06cc \u06af\u0631\u0627\u0641\u06cc\u06a9\u06cc \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ol>\n<p>\u0628\u0631\u0627\u06cc \u062c\u0644\u0648\u06af\u06cc\u0631\u06cc \u0627\u0632 \u0645\u0634\u06a9\u0644\u0627\u062a\u060c \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u062e\u0637\u200c\u0645\u0634\u06cc\u200c\u0647\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0648 \u0627\u0639\u062a\u0628\u0627\u0631\u0646\u0627\u0645\u0647 \u0648\u0631\u0648\u062f pgAdmin \u0628\u0647 \u062f\u0631\u0633\u062a\u06cc \u062a\u0646\u0638\u06cc\u0645 \u0634\u062f\u0647\u200c\u0627\u0646\u062f.  \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0627\u06cc\u0646\u060c \u0628\u0631\u0627\u06cc \u062c\u0644\u0648\u06af\u06cc\u0631\u06cc \u0627\u0632 \u0645\u0634\u06a9\u0644\u0627\u062a \u0646\u0627\u0633\u0627\u0632\u06af\u0627\u0631\u06cc\u060c \u0622\u062e\u0631\u06cc\u0646 \u0646\u0633\u062e\u0647 RDBMS \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 APT \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n<h2 class=\"wp-block-heading\" id=\"h-how-to-install-postgresql-on-ubuntu-faq\"><span class=\"ez-toc-section\" id=\"%d8%b1%d9%88%d8%b4_%d9%86%d8%b5%d8%a8_postgresql_%d8%b1%d9%88%db%8c_%d8%b3%d9%88%d8%a7%d9%84%d8%a7%d8%aa_%d9%85%d8%aa%d8%af%d8%a7%d9%88%d9%84_%d8%a7%d9%88%d8%a8%d9%88%d9%86%d8%aa%d9%88\"><\/span><span class=\"ez-toc-section\" id=\"How_to_Install_PostgreSQL_on_Ubuntu_FAQ\"><\/span>\u0631\u0648\u0634 \u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc \u0633\u0648\u0627\u0644\u0627\u062a \u0645\u062a\u062f\u0627\u0648\u0644 \u0627\u0648\u0628\u0648\u0646\u062a\u0648<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0628\u062e\u0634 \u0628\u0647 \u0686\u0646\u062f\u06cc\u0646 \u0633\u0648\u0627\u0644 \u0645\u062a\u062f\u0627\u0648\u0644 \u062f\u0631 \u0645\u0648\u0631\u062f \u0646\u0635\u0628 PostgreSQL \u067e\u0627\u0633\u062e \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f \u0631\u0648\u06cc \u06cc\u06a9 \u0633\u0631\u0648\u0631 \u0627\u0648\u0628\u0648\u0646\u062a\u0648<\/p>\n<div class=\"schema-faq wp-block-yoast-faq-block\">\n<div class=\"schema-faq-section\" id=\"faq-question-1693491145690\">\n<h3 class=\"schema-faq-question\"><span class=\"ez-toc-section\" id=\"%da%a9%d8%ac%d8%a7_postgres_%d9%86%d8%b5%d8%a8_%d8%b4%d8%af%d9%87_%d8%a7%d8%b3%d8%aa_%d8%b1%d9%88%db%8c_%d8%a7%d9%88%d8%a8%d9%88%d9%86%d8%aa%d9%88%d8%9f\"><\/span><span class=\"ez-toc-section\" id=\"Where_Is_Postgres_Installed_on_Ubuntu\"><\/span>\u06a9\u062c\u0627 Postgres \u0646\u0635\u0628 \u0634\u062f\u0647 \u0627\u0633\u062a \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648\u061f <span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p class=\"schema-faq-answer\">\u062f\u0631 \u0627\u0648\u0628\u0648\u0646\u062a\u0648\u060c \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u0627\u0635\u0644\u06cc \u0633\u0631\u0648\u0631 PostgreSQL \u062f\u0631 <strong>\/usr\/lib\/postgresql\/<version\/bin\/postgres <\/strong>\u0641\u0647\u0631\u0633\u062a \u0631\u0627\u0647\u0646\u0645\u0627.  \u062a\u0645\u0627\u0645 \u062e\u0648\u0634\u0647 \u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u0631 \u0622\u0646 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f <strong>\/var\/lib\/postgresql\/main<\/strong> \u0641\u0647\u0631\u0633\u062a \u0631\u0627\u0647\u0646\u0645\u0627.  \u062f\u0631 \u0647\u0645\u06cc\u0646 \u062d\u0627\u0644\u060c \u062a\u0646\u0638\u06cc\u0645\u0627\u062a PostgreSQL \u062f\u0631 <strong>\/etc\/postgresql\/main\/postgresql.conf <\/strong>\u0641\u0627\u06cc\u0644.<\/p>\n<\/p><\/div>\n<div class=\"schema-faq-section\" id=\"faq-question-1693491155361\">\n<h3 class=\"schema-faq-question\"><span class=\"ez-toc-section\" id=\"%da%86%da%af%d9%88%d9%86%d9%87_%d8%a8%d9%81%d9%87%d9%85%d9%85_postgresql_%d9%86%d8%b5%d8%a8_%d8%b4%d8%af%d9%87_%d8%a7%d8%b3%d8%aa%d8%9f_%d8%b1%d9%88%db%8c_%d8%a7%d9%88%d8%a8%d9%88%d9%86%d8%aa%d9%88%d8%9f\"><\/span><span class=\"ez-toc-section\" id=\"How_Do_I_Know_if_PostgreSQL_Is_Installed_on_Ubuntu\"><\/span>\u0686\u06af\u0648\u0646\u0647 \u0628\u0641\u0647\u0645\u0645 PostgreSQL \u0646\u0635\u0628 \u0634\u062f\u0647 \u0627\u0633\u062a\u061f \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648\u061f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p class=\"schema-faq-answer\">\u0633\u0627\u062f\u0647 \u062a\u0631\u06cc\u0646 \u0631\u0627\u0647 \u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0622\u06cc\u0627 PostgreSQL \u0646\u0635\u0628 \u0634\u062f\u0647 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631 \u0631\u0648\u06cc \u06cc\u06a9 \u0633\u0631\u0648\u0631 \u0627\u0648\u0628\u0648\u0646\u062a\u0648 \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f <strong>sudo -u postgres psql<\/strong> \u06cc\u0627 <strong>\u06a9\u062f\u0627\u0645 psql<\/strong>.  \u062a\u0631\u0645\u06cc\u0646\u0627\u0644 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u0635\u0628 \u0628\u0627\u06cc\u062f \u0645\u0633\u06cc\u0631 \u0646\u0635\u0628 \u0631\u0627 \u062e\u0631\u0648\u062c\u06cc \u062f\u0647\u062f.<\/p>\n<\/p><\/div>\n<div class=\"schema-faq-section\" id=\"faq-question-1693491165378\">\n<h3 class=\"schema-faq-question\"><span class=\"ez-toc-section\" id=\"%d8%a2%db%8c%d8%a7_%d8%a8%d8%a7%db%8c%d8%af_%d8%a7%d8%b2_postgresql_13_%db%8c%d8%a7_14_%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87_%da%a9%d9%86%d9%85%d8%9f\"><\/span><span class=\"ez-toc-section\" id=\"Should_I_Use_PostgreSQL_13_or_14\"><\/span>\u0622\u06cc\u0627 \u0628\u0627\u06cc\u062f \u0627\u0632 PostgreSQL 13 \u06cc\u0627 14 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0645\u061f<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p class=\"schema-faq-answer\">PostgreSQL 14 \u062f\u0627\u0631\u0627\u06cc \u0645\u0642\u06cc\u0627\u0633 \u0628\u0646\u062f\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647\u0628\u0648\u062f \u06cc\u0627\u0641\u062a\u0647 \u0627\u0633\u062a.  PostgreSQL 14 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0634\u0631\u06a9\u062a \u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0628\u0627 \u0627\u062a\u0635\u0627\u0644\u0627\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0646\u0627\u0633\u0628 \u062a\u0631 \u0645\u06cc \u06a9\u0646\u062f.  \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u0628\u0631\u0627\u06cc \u0622\u062e\u0631\u06cc\u0646 \u0648\u06cc\u0698\u06af\u06cc\u200c\u0647\u0627\u060c \u067e\u06cc\u0634\u0631\u0641\u062a\u200c\u0647\u0627 \u0648 \u0648\u0635\u0644\u0647\u200c\u0647\u0627 \u0627\u0632 \u062c\u062f\u06cc\u062f\u062a\u0631\u06cc\u0646 \u0646\u0633\u062e\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<\/p><\/div><\/div><\/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-29 11:22:04<br \/>\n<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;11160&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 \u0631\u0648\u06cc Ubuntu + \u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u0648\u062b\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647&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\"> 11<\/span> <span class=\"rt-label rt-postfix\">\u062f\u0642\u06cc\u0642\u0647<\/span><\/span>PostgreSQL \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627\u0628\u0637\u0647\u200c\u0627\u06cc \u0645\u0646\u0628\u0639 \u0628\u0627\u0632 \u0645\u062d\u0628\u0648\u0628 (RDBMS) \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0645\u0642\u06cc\u0627\u0633\u200c\u067e\u0630\u06cc\u0631\u06cc \u0648 \u06a9\u0627\u0631\u0627\u06cc\u06cc \u0622\u0646 \u062f\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062d\u062c\u0645 \u0632\u06cc\u0627\u062f\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0634\u0646\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a. \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0639\u0645\u0644\u06a9\u0631\u062f \u0628\u0627\u0644\u0627\u060c PostgreSQL \u0628\u0631\u0627\u06cc \u0648\u0628 \u0633\u0627\u06cc\u062a \u0647\u0627 \u06cc\u0627 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0633\u0627\u0632\u0645\u0627\u0646\u06cc \u0627\u06cc\u062f\u0647 \u0622\u0644 \u0627\u0633\u062a. \u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0632\u0628\u0627\u0646 \u0647\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":10793,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[606,643,2752,445],"tags":[33,2751,2747,2746],"class_list":{"0":"post-11160","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-howto","8":"category-guides","9":"category-vps","10":"category-kb","11":"tag-wordpress","12":"tag--wordpress","14":"tag-2746"},"acf":[],"_links":{"self":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts\/11160","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=11160"}],"version-history":[{"count":0,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts\/11160\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media\/10793"}],"wp:attachment":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media?parent=11160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/categories?post=11160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/tags?post=11160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}