{"id":27863,"date":"2023-05-04T08:04:41","date_gmt":"2023-05-04T05:04:41","guid":{"rendered":"https:\/\/linuxthebest.net\/?p=27863"},"modified":"2023-05-03T10:04:53","modified_gmt":"2023-05-03T07:04:53","slug":"yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux","status":"publish","type":"post","link":"https:\/\/linuxthebest.net\/uk\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/","title":{"rendered":"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0432 Linux"},"content":{"rendered":"<p>PostgreSQL \u0442\u0430\u043a\u043e\u0436 \u043d\u0430\u0437\u0438\u0432\u0430\u0454\u0442\u044c\u0441\u044f Postgres &#8211; \u0446\u0435 \u043f\u043e\u0442\u0443\u0436\u043d\u0430 \u043e\u0431&#8217;\u0454\u043a\u0442\u043d\u043e-\u0440\u0435\u043b\u044f\u0446\u0456\u0439\u043d\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445 \u0437 \u0432\u0456\u0434\u043a\u0440\u0438\u0442\u0438\u043c \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u043c \u043a\u043e\u0434\u043e\u043c. \u0426\u0435 \u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u0438\u0445 \u043a\u043e\u0440\u043f\u043e\u0440\u0430\u0442\u0438\u0432\u043d\u043e\u0433\u043e \u0440\u0456\u0432\u043d\u044f \u0437 \u0442\u0430\u043a\u0438\u043c\u0438 \u0444\u0443\u043d\u043a\u0446\u0456\u044f\u043c\u0438, \u044f\u043a \u0432\u0435\u0434\u0435\u043d\u043d\u044f \u0436\u0443\u0440\u043d\u0430\u043b\u0443 \u0437 \u0432\u0438\u043f\u0435\u0440\u0435\u0434\u0436\u0435\u043d\u043d\u044f\u043c \u0437\u0430\u043f\u0438\u0441\u0443 \u0434\u043b\u044f \u0437\u0430\u0431\u0435\u0437\u043f\u0435\u0447\u0435\u043d\u043d\u044f \u0432\u0456\u0434\u043c\u043e\u0432\u043e\u0441\u0442\u0456\u0439\u043a\u043e\u0441\u0442\u0456, \u0430\u0441\u0438\u043d\u0445\u0440\u043e\u043d\u043d\u0430 \u0440\u0435\u043f\u043b\u0456\u043a\u0430\u0446\u0456\u044f, \u0431\u0430\u0433\u0430\u0442\u043e\u0432\u0435\u0440\u0441\u0456\u0439\u043d\u0438\u0439 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u044c \u043f\u0430\u0440\u0430\u043b\u0435\u043b\u0456\u0437\u043c\u0443 (MVCC), \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0435 \u043a\u043e\u043f\u0456\u044e\u0432\u0430\u043d\u043d\u044f \u043e\u043d\u043b\u0430\u0439\u043d\/\u0433\u0430\u0440\u044f\u0447\u0435 \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0435 \u043a\u043e\u043f\u0456\u044e\u0432\u0430\u043d\u043d\u044f, \u0432\u0456\u0434\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044f \u0437\u0430 \u0442\u043e\u0447\u043a\u0430\u043c\u0438, \u043f\u043b\u0430\u043d\u0443\u0432\u0430\u043b\u044c\u043d\u0438\u043a\/\u043e\u043f\u0442\u0438\u043c\u0456\u0437\u0430\u0442\u043e\u0440 \u0437\u0430\u043f\u0438\u0442\u0456\u0432, \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u0456 \u043f\u0440\u043e\u0441\u0442\u043e\u0440\u0438, \u0432\u043a\u043b\u0430\u0434\u0435\u043d\u0456 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0456\u0457 (\u0442\u043e\u0447\u043a\u0438 \u0437\u0431\u0435\u0440\u0435\u0436\u0435\u043d\u043d\u044f) \u0442\u043e\u0449\u043e.<\/p>\n<p>\u041e\u0441\u0442\u0430\u043d\u043d\u044f \u0432\u0435\u0440\u0441\u0456\u044f Postgres 15.2 \u0431\u0443\u043b\u0430 \u0432\u0438\u043f\u0443\u0449\u0435\u043d\u0430 9 \u043b\u044e\u0442\u043e\u0433\u043e 2023 \u0440\u043e\u043a\u0443 \u0433\u043b\u043e\u0431\u0430\u043b\u044c\u043d\u043e\u044e \u0433\u0440\u0443\u043f\u043e\u044e \u0440\u043e\u0437\u0440\u043e\u0431\u043d\u0438\u043a\u0456\u0432 PostgreSQL.<\/p>\n<h2>\u041e\u0441\u043e\u0431\u043b\u0438\u0432\u043e\u0441\u0442\u0456 PostgreSQL<\/h2>\n<p>\u041e\u0441\u043e\u0431\u043b\u0438\u0432\u043e\u0441\u0442\u0456 \u043d\u043e\u0432\u043e\u0457 \u0432\u0435\u0440\u0441\u0456\u0457 \u0442\u0430\u043a\u0456:<\/p>\n<ul>\n<li>\u041b\u043e\u0433\u0456\u0447\u043d\u0430 \u0440\u0435\u043f\u043b\u0456\u043a\u0430\u0446\u0456\u044f: \u0426\u044f \u0444\u0443\u043d\u043a\u0446\u0456\u044f \u0434\u0430\u0454 \u0437\u043c\u043e\u0433\u0443 \u0440\u0435\u043f\u043b\u0456\u043a\u0443\u0432\u0430\u0442\u0438 \u043e\u043a\u0440\u0435\u043c\u0456 \u043e\u0431&#8217;\u0454\u043a\u0442\u0438 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445 (\u0447\u0438 \u0442\u043e \u0440\u044f\u0434\u043a\u0438, \u0442\u0430\u0431\u043b\u0438\u0446\u0456, \u0447\u0438 \u0442\u043e \u0432\u0438\u0431\u0456\u0440\u043a\u043e\u0432\u0456 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445) \u043d\u0430 \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0438\u0445 \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u0445. \u0412\u043e\u043d\u0430 \u0437\u0430\u0431\u0435\u0437\u043f\u0435\u0447\u0443\u0454 \u0431\u0456\u043b\u044c\u0448\u0438\u0439 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u044c \u043d\u0430\u0434 \u0440\u0435\u043f\u043b\u0456\u043a\u0430\u0446\u0456\u0454\u044e \u0434\u0430\u043d\u0438\u0445. \u0420\u0435\u0430\u043b\u0456\u0437\u0443\u0454\u0442\u044c\u0441\u044f \u0437\u0430 \u0434\u043e\u043f\u043e\u043c\u043e\u0433\u043e\u044e \u043c\u043e\u0434\u0435\u043b\u0456 \u0432\u0438\u0434\u0430\u0432\u0435\u0446\u044c-\u043f\u0456\u0434\u043f\u0438\u0441\u043d\u0438\u043a.<\/li>\n<li>Quorum Commit \u0434\u043b\u044f \u0441\u0438\u043d\u0445\u0440\u043e\u043d\u043d\u043e\u0457 \u0440\u0435\u043f\u043b\u0456\u043a\u0430\u0446\u0456\u0457: \u0423 \u0446\u0456\u0439 \u0444\u0443\u043d\u043a\u0446\u0456\u0457 dba \u0442\u0435\u043f\u0435\u0440 \u043c\u043e\u0436\u0435 \u0432\u043a\u0430\u0437\u0430\u0442\u0438 \u043a\u0456\u043b\u044c\u043a\u0456\u0441\u0442\u044c \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0438\u0445 \u0441\u0435\u0440\u0432\u0435\u0440\u0456\u0432, \u044f\u043a\u0456 \u043f\u0456\u0434\u0442\u0432\u0435\u0440\u0434\u0436\u0443\u044e\u0442\u044c, \u0449\u043e \u0437\u043c\u0456\u043d\u0438 \u0432 \u0431\u0430\u0437\u0456 \u0434\u0430\u043d\u0438\u0445 \u0431\u0443\u043b\u0438 \u0437\u0440\u043e\u0431\u043b\u0435\u043d\u0456, \u0442\u0430\u043a \u0449\u043e \u0434\u0430\u043d\u0456 \u043c\u043e\u0436\u043d\u0430 \u0432\u0432\u0430\u0436\u0430\u0442\u0438 \u0431\u0435\u0437\u043f\u0435\u0447\u043d\u043e \u0437\u0430\u043f\u0438\u0441\u0430\u043d\u0438\u043c\u0438.<\/li>\n<li>\u0410\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0456\u043a\u0430\u0446\u0456\u044f SCRAM-SHA-256: \u041f\u043e\u043a\u0440\u0430\u0449\u0435\u043d\u043e \u0431\u0435\u0437\u043f\u0435\u043a\u0443 \u043f\u043e\u0440\u0456\u0432\u043d\u044f\u043d\u043e \u0437 \u043d\u0430\u044f\u0432\u043d\u043e\u044e \u0430\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0456\u043a\u0430\u0446\u0456\u0454\u044e \u0442\u0430 \u0437\u0431\u0435\u0440\u0456\u0433\u0430\u043d\u043d\u044f\u043c \u043f\u0430\u0440\u043e\u043b\u0456\u0432 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0456 MD5.<\/li>\n<li>\u041f\u043e\u043a\u0440\u0430\u0449\u0435\u043d\u0435 \u043f\u0430\u0440\u0430\u043b\u0435\u043b\u044c\u043d\u0435 \u0432\u0438\u043a\u043e\u043d\u0430\u043d\u043d\u044f \u0437\u0430\u043f\u0438\u0442\u0456\u0432.<\/li>\n<li>\u0414\u0435\u043a\u043b\u0430\u0440\u0430\u0442\u0438\u0432\u043d\u0435 \u0440\u043e\u0437\u0431\u0438\u0442\u0442\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044c.<\/li>\n<li>\u041f\u0456\u0434\u0442\u0440\u0438\u043c\u043a\u0430 \u043f\u043e\u0432\u043d\u043e\u0442\u0435\u043a\u0441\u0442\u043e\u0432\u043e\u0433\u043e \u043f\u043e\u0448\u0443\u043a\u0443 \u0434\u043b\u044f JSON \u0456 JSONB.<\/li>\n<\/ul>\n<p>\u0423 \u0446\u0456\u0439 \u0441\u0442\u0430\u0442\u0442\u0456 \u043c\u0438 \u0440\u043e\u0437\u043f\u043e\u0432\u0456\u043c\u043e, \u044f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL 15 \u0437\u0430 \u0434\u043e\u043f\u043e\u043c\u043e\u0433\u043e\u044e \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044f \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u0445 \u043a\u043e\u0434\u0456\u0432 \u0443 \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445 Linux. \u0422\u0456, \u0445\u0442\u043e \u0448\u0443\u043a\u0430\u0454 \u043f\u0440\u043e\u0441\u0442\u0443 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0443 \u0437 \u043c\u0435\u043d\u0435\u0434\u0436\u0435\u0440\u0430 \u043f\u0430\u043a\u0435\u0442\u0456\u0432 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u0430, \u043c\u0438 \u0440\u043e\u0437\u0433\u043b\u044f\u0434\u0430\u043b\u0438 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0443 PostgreSQL 15 \u043d\u0430 Rocky Linux \u0456 AlmaLinux:<\/p>\n<blockquote><p><a class=\"fasc-button fasc-size-medium fasc-type-popout fasc-rounded-medium\" style=\"background-color: #33809e; color: #ffffff;\" target=\"_blank\" rel=\"nofollow noopener\" href=\"https:\/\/linuxthebest.net\/uk\/yak-vstanovyty-postgresql-15-na-rocky-linux-ta-almalinux\/\">\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL 15 \u043d\u0430 Rocky Linux \u0442\u0430 AlmaLinux<\/a><\/p><\/blockquote>\n<h2>\u0412\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044f PostgreSQL \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443<\/h2>\n<p>\u041e\u0441\u043a\u0456\u043b\u044c\u043a\u0438 postgres \u0454 \u0431\u0430\u0437\u043e\u044e \u0434\u0430\u043d\u0438\u0445 \u0437 \u0432\u0456\u0434\u043a\u0440\u0438\u0442\u0438\u043c \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u043c \u043a\u043e\u0434\u043e\u043c, \u0457\u0457 \u043c\u043e\u0436\u043d\u0430 \u0437\u0456\u0431\u0440\u0430\u0442\u0438 \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u0445 \u0442\u0435\u043a\u0441\u0442\u0456\u0432 \u0432\u0456\u0434\u043f\u043e\u0432\u0456\u0434\u043d\u043e \u0434\u043e \u0441\u0432\u043e\u0457\u0445 \u043f\u043e\u0442\u0440\u0435\u0431. \u041c\u0438 \u043c\u043e\u0436\u0435\u043c\u043e \u043d\u0430\u043b\u0430\u0448\u0442\u0443\u0432\u0430\u0442\u0438 \u043f\u0440\u043e\u0446\u0435\u0441 \u0437\u0431\u0438\u0440\u0430\u043d\u043d\u044f \u0442\u0430 \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044f, \u0434\u043e\u0434\u0430\u0432\u0448\u0438 \u043e\u0434\u0438\u043d \u0430\u0431\u043e \u043a\u0456\u043b\u044c\u043a\u0430 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0456\u0432 \u043a\u043e\u043c\u0430\u043d\u0434\u043d\u043e\u0433\u043e \u0440\u044f\u0434\u043a\u0430 \u0434\u043b\u044f \u0440\u0456\u0437\u043d\u0438\u0445 \u0434\u043e\u0434\u0430\u0442\u043a\u043e\u0432\u0438\u0445 \u0444\u0443\u043d\u043a\u0446\u0456\u0439.<\/p>\n<p>\u041e\u0441\u043d\u043e\u0432\u043d\u043e\u044e \u043f\u0435\u0440\u0435\u0432\u0430\u0433\u043e\u044e \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u0430\u043d\u043d\u044f \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438 \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0454 \u0442\u0435, \u0449\u043e \u0457\u0457 \u043c\u043e\u0436\u043d\u0430 \u0437\u043d\u0430\u0447\u043d\u043e\u044e \u043c\u0456\u0440\u043e\u044e \u043d\u0430\u043b\u0430\u0448\u0442\u0443\u0432\u0430\u0442\u0438 \u0432 \u043f\u0440\u043e\u0446\u0435\u0441\u0456 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438.<\/p>\n<p><strong>1.<\/strong> \u0421\u043f\u043e\u0447\u0430\u0442\u043a\u0443 \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0456\u0442\u044c \u043d\u0435\u043e\u0431\u0445\u0456\u0434\u043d\u0456 \u043f\u043e\u043f\u0435\u0440\u0435\u0434\u043d\u0456 \u043a\u043e\u043c\u043f\u043e\u043d\u0435\u043d\u0442\u0438, \u0442\u0430\u043a\u0456 \u044f\u043a gcc, readline-devel \u0456 zlib-devel, \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u043e\u0432\u0443\u044e\u0447\u0438 \u043c\u0435\u043d\u0435\u0434\u0436\u0435\u0440 \u043f\u0430\u043a\u0435\u0442\u0456\u0432, \u044f\u043a \u043f\u043e\u043a\u0430\u0437\u0430\u043d\u043e \u043d\u0430 \u043c\u0430\u043b\u044e\u043d\u043a\u0443.<\/p>\n<pre><code class=\"language-bash\" data-line=\"\"># yum install gcc zlib-devel readline-devel &nbsp;&nbsp;&nbsp;&nbsp;[On RHEL\/CentOS]\n# apt install gcc zlib1g-dev libreadline6-dev&nbsp;&nbsp; [On Debian\/Ubuntu]<\/code><\/pre>\n<p><strong>2.<\/strong> \u0417\u0430\u0432\u0430\u043d\u0442\u0430\u0436\u0442\u0435 tar-\u0444\u0430\u0439\u043b \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0437 \u043e\u0444\u0456\u0446\u0456\u0439\u043d\u043e\u0433\u043e \u0441\u0430\u0439\u0442\u0443 postgres \u0437\u0430 \u0434\u043e\u043f\u043e\u043c\u043e\u0433\u043e\u044e \u043d\u0430\u0441\u0442\u0443\u043f\u043d\u043e\u0457 \u043a\u043e\u043c\u0430\u043d\u0434\u0438 wget \u0431\u0435\u0437\u043f\u043e\u0441\u0435\u0440\u0435\u0434\u043d\u044c\u043e \u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u0456.<\/p>\n<pre><code class=\"language-bash\" data-line=\"\"># wget https:\/\/ftp.postgresql.org\/pub\/source\/v15.2\/postgresql-15.2.tar.bz2<\/code><\/pre>\n<p><strong>3.<\/strong>&nbsp;\u0412\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u043e\u0432\u0443\u0439\u0442\u0435 \u043a\u043e\u043c\u0430\u043d\u0434\u0443 tar \u0434\u043b\u044f \u0432\u0438\u043b\u0443\u0447\u0435\u043d\u043d\u044f \u0437\u0430\u0432\u0430\u043d\u0442\u0430\u0436\u0435\u043d\u043e\u0433\u043e \u0444\u0430\u0439\u043b\u0443 tarball. \u0411\u0443\u0434\u0435 \u0441\u0442\u0432\u043e\u0440\u0435\u043d\u043e \u043d\u043e\u0432\u0438\u0439 \u043a\u0430\u0442\u0430\u043b\u043e\u0433 \u0437 \u0456\u043c\u0435\u043d\u0435\u043c postgresql-15.2.<\/p>\n<pre><code class=\"language-bash\" data-line=\"\"># tar -xvf postgresql-15.2.tar.bz2\n# cd postgresql-15.2\n# ls -l<\/code><\/pre>\n<p><strong><em>\u0417\u0440\u0430\u0437\u043e\u043a \u0432\u0438\u0432\u0435\u0434\u0435\u043d\u043d\u044f<\/em><\/strong><\/p>\n<pre><code class=\"language-bash\" data-line=\"\">total 780\n-rw-r--r--&nbsp; 1 1107 1107&nbsp;&nbsp;&nbsp; 397 Feb&nbsp; 6 16:39 aclocal.m4\ndrwxrwxrwx&nbsp; 2 1107 1107&nbsp;&nbsp; 4096 Feb&nbsp; 6 16:50 config\n-rwxr-xr-x&nbsp; 1 1107 1107 601519 Feb&nbsp; 6 16:39 configure\n-rw-r--r--&nbsp; 1 1107 1107&nbsp; 89258 Feb&nbsp; 6 16:39 configure.ac\ndrwxrwxrwx 61 1107 1107&nbsp;&nbsp; 4096 Feb&nbsp; 6 16:50 contrib\n-rw-r--r--&nbsp; 1 1107 1107&nbsp;&nbsp; 1192 Feb&nbsp; 6 16:39 COPYRIGHT\ndrwxrwxrwx&nbsp; 3 1107 1107&nbsp;&nbsp;&nbsp;&nbsp; 87 Feb&nbsp; 6 16:50 doc\n-rw-r--r--&nbsp; 1 1107 1107&nbsp;&nbsp; 4264 Feb&nbsp; 6 16:39 GNUmakefile.in\n-rw-r--r--&nbsp; 1 1107 1107&nbsp;&nbsp;&nbsp; 277 Feb&nbsp; 6 16:39 HISTORY\n-rw-r--r--&nbsp; 1 1107 1107&nbsp; 63842 Feb&nbsp; 6 16:51 INSTALL\n-rw-r--r--&nbsp; 1 1107 1107&nbsp;&nbsp; 1875 Feb&nbsp; 6 16:39 Makefile\n-rw-r--r--&nbsp; 1 1107 1107&nbsp;&nbsp; 1213 Feb&nbsp; 6 16:39 README\ndrwxrwxrwx 16 1107 1107&nbsp;&nbsp; 4096 Feb&nbsp; 6 16:51 src<\/code><\/pre>\n<p><strong>4.<\/strong> \u041d\u0430\u0441\u0442\u0443\u043f\u043d\u0438\u043c \u043a\u0440\u043e\u043a\u043e\u043c \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0438 \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044f \u0454 \u043a\u043e\u043d\u0444\u0456\u0433\u0443\u0440\u0443\u0432\u0430\u043d\u043d\u044f \u0437\u0430\u0432\u0430\u043d\u0442\u0430\u0436\u0435\u043d\u043e\u0433\u043e \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0448\u043b\u044f\u0445\u043e\u043c \u0432\u0438\u0431\u043e\u0440\u0443 \u043e\u043f\u0446\u0456\u0439 \u0432\u0456\u0434\u043f\u043e\u0432\u0456\u0434\u043d\u043e \u0434\u043e \u0432\u0430\u0448\u0438\u0445 \u043f\u043e\u0442\u0440\u0435\u0431. \u0412\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u043e\u0432\u0443\u0439\u0442\u0435 .\/configure &#8211;help \u0434\u043b\u044f \u043e\u0442\u0440\u0438\u043c\u0430\u043d\u043d\u044f \u0434\u043e\u0432\u0456\u0434\u043a\u0438 \u0449\u043e\u0434\u043e \u0440\u0456\u0437\u043d\u0438\u0445 \u043e\u043f\u0446\u0456\u0439.<\/p>\n<pre><code class=\"language-bash\" data-line=\"\"># .\/configure --help\n\n`configure&#039; configures PostgreSQL 15.2 to adapt to many kinds of systems.&nbsp;\n\nUsage: .\/configure [OPTION]... [VAR=VALUE]...\n&nbsp;\nTo assign environment variables (e.g., CC, CFLAGS...), specify them asVAR=VALUE.&nbsp; See below for descriptions of some of the useful variables.\n&nbsp;\nDefaults for the options are specified in brackets.\n&nbsp;\nConfiguration:\n&nbsp; -h, --help&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; display this help and exit\n&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; --help=short&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; display options specific to this package\n&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; --help=recursive&nbsp;&nbsp;&nbsp; display the short help of all the included packages\n&nbsp; -V, --version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; display version information and exit\n&nbsp; -q, --quiet, --silent&nbsp;&nbsp; do not print `checking ...&#039; messages\n &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --cache-file=FILE&nbsp;&nbsp; cache test results in FILE [disabled]\n&nbsp; -C, --config-cache&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; alias for `--cache-file=config.cache&#039;\n&nbsp; -n, --no-create&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; do not create output files\n &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --srcdir=DIR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; find the sources in DIR [configure dir or `..&#039;]\n&nbsp;\nInstallation directories:\n&nbsp; --prefix=PREFIX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; install architecture-independent files in PREFIX\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[\/usr\/local\/pgsql]\n&nbsp; --exec-prefix=EPREFIX&nbsp;&nbsp; install architecture-dependent files in EPREFIX\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [PREFIX]\n....<\/code><\/pre>\n<p><strong>5.<\/strong> \u0422\u0435\u043f\u0435\u0440 \u0441\u0442\u0432\u043e\u0440\u0456\u0442\u044c \u043a\u0430\u0442\u0430\u043b\u043e\u0433, \u0443 \u044f\u043a\u0438\u0439 \u0432\u0438 \u0445\u043e\u0447\u0435\u0442\u0435 \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 \u0444\u0430\u0439\u043b\u0438 postgres, \u0456 \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u043e\u0432\u0443\u0439\u0442\u0435 \u043e\u043f\u0446\u0456\u044e prefix \u0443 configure.<\/p>\n<pre><code class=\"language-bash\" data-line=\"\"># mkdir \/opt\/PostgreSQL# .\/configure --prefix=\/opt\/PostgreSQL<\/code><\/pre>\n<p><strong><em>\u0417\u0440\u0430\u0437\u043e\u043a \u0432\u0438\u0432\u0435\u0434\u0435\u043d\u043d\u044f<\/em><\/strong><\/p>\n<pre><code class=\"language-bash\" data-line=\"\">checking build system type... x86_64-pc-linux-gnu\nchecking host system type... x86_64-pc-linux-gnu\nchecking which template to use... linux\nchecking whether NLS is wanted... no\nchecking for default port number... 5432\nchecking for block size... 8kB\nchecking for segment size... 1GB\nchecking for WAL block size... 8kB\nchecking for gcc... gcc\nchecking whether the C compiler works... yes\nchecking for C compiler default output file name... a.out\nchecking for suffix of executables... \nchecking whether we are cross compiling... no\nchecking for suffix of object files... o\nchecking whether we are using the GNU C compiler... yes\nchecking whether gcc accepts -g... yes\nchecking for gcc option to accept ISO C89... none needed\nchecking for gcc option to accept ISO C99... none needed\nchecking for g++... g++\nchecking whether we are using the GNU C++ compiler... yes\nchecking whether g++ accepts -g... yes\nchecking for gawk... gawk\nchecking whether gcc supports -Wdeclaration-after-statement, for CFLAGS... yes\nchecking whether gcc supports -Werror=vla, for CFLAGS... yes\nchecking whether gcc supports -Werror=unguarded-availability-new, for CFLAGS... no....<\/code><\/pre>\n<h2>\u0421\u0442\u0432\u043e\u0440\u0435\u043d\u043d\u044f PostgreSQL \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u0445 \u0442\u0435\u043a\u0441\u0442\u0456\u0432<\/h2>\n<p><strong>6.<\/strong> \u041f\u0456\u0441\u043b\u044f \u043d\u0430\u043b\u0430\u0448\u0442\u0443\u0432\u0430\u043d\u043d\u044f \u043c\u0438 \u043f\u0440\u0438\u0441\u0442\u0443\u043f\u0438\u043c\u043e \u0434\u043e \u0441\u043a\u043b\u0430\u0434\u0430\u043d\u043d\u044f PostgreSQL \u0437\u0430 \u0434\u043e\u043f\u043e\u043c\u043e\u0433\u043e\u044e \u0442\u0430\u043a\u043e\u0457 \u043a\u043e\u043c\u0430\u043d\u0434\u0438 make.<\/p>\n<pre><code class=\"language-bash\" data-line=\"\"># make<\/code><\/pre>\n<p>\u041f\u0456\u0441\u043b\u044f \u0437\u0430\u0432\u0435\u0440\u0448\u0435\u043d\u043d\u044f \u043f\u0440\u043e\u0446\u0435\u0441\u0443 \u0441\u043a\u043b\u0430\u0434\u0430\u043d\u043d\u044f \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0456\u0442\u044c postgresql \u0437\u0430 \u0434\u043e\u043f\u043e\u043c\u043e\u0433\u043e\u044e \u0442\u0430\u043a\u043e\u0457 \u043a\u043e\u043c\u0430\u043d\u0434\u0438.<\/p>\n<pre><code class=\"language-bash\" data-line=\"\"># make install<\/code><\/pre>\n<p>Postgresql 15 \u0431\u0443\u043b\u043e \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u043e \u0432 \u043a\u0430\u0442\u0430\u043b\u043e\u0433 \/opt\/PostgreSQL.<\/p>\n<h2>\u0421\u0442\u0432\u043e\u0440\u0435\u043d\u043d\u044f \u043a\u043e\u0440\u0438\u0441\u0442\u0443\u0432\u0430\u0447\u0430 Postgres<\/h2>\n<p><strong>7.<\/strong> \u0422\u0435\u043f\u0435\u0440 \u0441\u0442\u0432\u043e\u0440\u0456\u0442\u044c \u043a\u043e\u0440\u0438\u0441\u0442\u0443\u0432\u0430\u0447\u0430 postgres \u0456 \u043a\u0430\u0442\u0430\u043b\u043e\u0433, \u044f\u043a\u0438\u0439 \u0431\u0443\u0434\u0435 \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u043e\u0432\u0443\u0432\u0430\u0442\u0438\u0441\u044f \u044f\u043a \u043a\u0430\u0442\u0430\u043b\u043e\u0433 \u0434\u0430\u043d\u0438\u0445 \u0434\u043b\u044f \u0456\u043d\u0456\u0446\u0456\u0430\u043b\u0456\u0437\u0430\u0446\u0456\u0457 \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445. \u0412\u043b\u0430\u0441\u043d\u0438\u043a\u043e\u043c \u0446\u044c\u043e\u0433\u043e \u043a\u0430\u0442\u0430\u043b\u043e\u0433\u0443 \u0434\u0430\u043d\u0438\u0445 \u043c\u0430\u0454 \u0431\u0443\u0442\u0438 \u043a\u043e\u0440\u0438\u0441\u0442\u0443\u0432\u0430\u0447 postgres, \u043f\u0440\u0430\u0432\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0443 \u043c\u0430\u044e\u0442\u044c \u0431\u0443\u0442\u0438 700, \u0430 \u0442\u0430\u043a\u043e\u0436 \u0437\u0430\u0434\u0430\u0439\u0442\u0435 \u0448\u043b\u044f\u0445 \u0434\u043b\u044f \u0434\u0432\u0456\u0439\u043a\u043e\u0432\u0438\u0445 \u0444\u0430\u0439\u043b\u0456\u0432 postgresql \u0434\u043b\u044f \u043d\u0430\u0448\u043e\u0457 \u0437\u0440\u0443\u0447\u043d\u043e\u0441\u0442\u0456.<\/p>\n<pre><code class=\"language-bash\" data-line=\"\"># useradd postgres\n# passwd postgres\n# mkdir -p \/pgdatabase\/data\n# chown -R postgres. \/pgdatabase\/data\n# echo &#039;export PATH=$PATH:\/opt\/PostgreSQL\/bin&#039; &gt; \/etc\/profile.d\/postgres.sh\n# source \/etc\/profile.d\/postgres.sh<\/code><\/pre>\n<h2>\u0406\u043d\u0456\u0446\u0456\u0430\u043b\u0456\u0437\u0430\u0446\u0456\u044f \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445 Postgres<\/h2>\n<p><strong>8.<\/strong> \u0422\u0435\u043f\u0435\u0440 \u0456\u043d\u0456\u0446\u0456\u0430\u043b\u0456\u0437\u0443\u0439\u0442\u0435 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u0438\u0445 \u0437\u0430 \u0434\u043e\u043f\u043e\u043c\u043e\u0433\u043e\u044e \u043d\u0430\u0441\u0442\u0443\u043f\u043d\u043e\u0457 \u043a\u043e\u043c\u0430\u043d\u0434\u0438 \u0432 \u044f\u043a\u043e\u0441\u0442\u0456 \u043a\u043e\u0440\u0438\u0441\u0442\u0443\u0432\u0430\u0447\u0430 postgres, \u043f\u0435\u0440\u0448 \u043d\u0456\u0436 \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u043e\u0432\u0443\u0432\u0430\u0442\u0438 \u0431\u0443\u0434\u044c-\u044f\u043a\u0456 \u043a\u043e\u043c\u0430\u043d\u0434\u0438 postgres.<\/p>\n<pre><code class=\"language-bash\" data-line=\"\"># su postgres\n$ initdb -D \/pgdatabase\/data\/ -U postgres -W<\/code><\/pre>\n<p>\u0414\u0435 -D &#8211; \u0446\u0435 \u043c\u0456\u0441\u0446\u0435 \u0440\u043e\u0437\u0442\u0430\u0448\u0443\u0432\u0430\u043d\u043d\u044f \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0430 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445 \u0430\u0431\u043e, \u043c\u043e\u0436\u043d\u0430 \u0441\u043a\u0430\u0437\u0430\u0442\u0438, \u0446\u0435 \u043a\u0430\u0442\u0430\u043b\u043e\u0433 \u0434\u0430\u043d\u0438\u0445, \u0432 \u044f\u043a\u043e\u043c\u0443 \u043c\u0438 \u0445\u043e\u0447\u0435\u043c\u043e \u0456\u043d\u0456\u0446\u0456\u0430\u043b\u0456\u0437\u0443\u0432\u0430\u0442\u0438 \u043a\u043b\u0430\u0441\u0442\u0435\u0440 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445, -U &#8211; \u0456\u043c&#8217;\u044f \u0441\u0443\u043f\u0435\u0440\u043a\u043e\u0440\u0438\u0441\u0442\u0443\u0432\u0430\u0447\u0430 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445 \u0456 -W &#8211; \u0437\u0430\u043f\u0438\u0442 \u043f\u0430\u0440\u043e\u043b\u044f \u0434\u043b\u044f \u0441\u0443\u043f\u0435\u0440\u043a\u043e\u0440\u0438\u0441\u0442\u0443\u0432\u0430\u0447\u0430 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445.<\/p>\n<div class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"27865\" data-permalink=\"https:\/\/linuxthebest.net\/uk\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/initialize-postgres-database\/\" data-orig-file=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/initialize-postgres-database.png?fit=823%2C474&amp;ssl=1\" data-orig-size=\"823,474\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Initialize-Postgres-Database\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/initialize-postgres-database.png?fit=823%2C474&amp;ssl=1\" class=\"aligncenter size-full wp-image-27865 lazyload\" data-src=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/initialize-postgres-database.png?resize=823%2C474&#038;ssl=1\" alt=\"\" width=\"823\" height=\"474\" data-srcset=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/initialize-postgres-database.png?w=823&amp;ssl=1 823w, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/initialize-postgres-database.png?resize=300%2C173&amp;ssl=1 300w, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/initialize-postgres-database.png?resize=768%2C442&amp;ssl=1 768w\" data-sizes=\"(max-width: 823px) 100vw, 823px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 823px; --smush-placeholder-aspect-ratio: 823\/474;\" \/><\/div>\n<p>\u0414\u043b\u044f \u043e\u0442\u0440\u0438\u043c\u0430\u043d\u043d\u044f \u0434\u043e\u0434\u0430\u0442\u043a\u043e\u0432\u043e\u0457 \u0456\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0456\u0457 \u0442\u0430 \u043e\u043f\u0446\u0456\u0439 \u043c\u0438 \u043c\u043e\u0436\u0435\u043c\u043e \u0437\u0432\u0435\u0440\u043d\u0443\u0442\u0438\u0441\u044f \u0434\u043e initdb &#8211;help.<\/p>\n<p><strong>9.<\/strong> \u041f\u0456\u0441\u043b\u044f \u0456\u043d\u0456\u0446\u0456\u0430\u043b\u0456\u0437\u0430\u0446\u0456\u0457 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445, \u0437\u0430\u043f\u0443\u0441\u043a\u0443 \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0430 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445, \u0430\u0431\u043e \u044f\u043a\u0449\u043e \u0432\u0430\u043c \u043f\u043e\u0442\u0440\u0456\u0431\u043d\u043e \u0437\u043c\u0456\u043d\u0438\u0442\u0438 \u043f\u043e\u0440\u0442 \u0430\u0431\u043e \u0430\u0434\u0440\u0435\u0441\u0443 \u0434\u043b\u044f \u043f\u0440\u043e\u0441\u043b\u0443\u0445\u043e\u0432\u0443\u0432\u0430\u043d\u043d\u044f \u0441\u0435\u0440\u0432\u0435\u0440\u0430, \u0432\u0456\u0434\u0440\u0435\u0434\u0430\u0433\u0443\u0439\u0442\u0435 \u0444\u0430\u0439\u043b \/pgdatabase\/data\/postgresql.conf \u0443 \u043a\u0430\u0442\u0430\u043b\u043e\u0437\u0456 data \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445.<\/p>\n<div class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"27866\" data-permalink=\"https:\/\/linuxthebest.net\/uk\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/configure-postgresql-port\/\" data-orig-file=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/configure-postgresql-port.png?fit=707%2C287&amp;ssl=1\" data-orig-size=\"707,287\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Configure-PostgreSQL-Port\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/configure-postgresql-port.png?fit=707%2C287&amp;ssl=1\" class=\"aligncenter size-full wp-image-27866 lazyload\" data-src=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/configure-postgresql-port.png?resize=707%2C287&#038;ssl=1\" alt=\"\" width=\"707\" height=\"287\" data-srcset=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/configure-postgresql-port.png?w=707&amp;ssl=1 707w, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/configure-postgresql-port.png?resize=300%2C122&amp;ssl=1 300w\" data-sizes=\"(max-width: 707px) 100vw, 707px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 707px; --smush-placeholder-aspect-ratio: 707\/287;\" \/><\/div>\n<pre><code class=\"language-bash\" data-line=\"\">$ pg_ctl -D \/pgdatabase\/data\/ start<\/code><\/pre>\n<div class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"27867\" data-permalink=\"https:\/\/linuxthebest.net\/uk\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/start-postgres-database\/\" data-orig-file=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/start-postgres-database.png?fit=846%2C220&amp;ssl=1\" data-orig-size=\"846,220\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Start-Postgres-Database\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/start-postgres-database.png?fit=846%2C220&amp;ssl=1\" class=\"aligncenter size-full wp-image-27867 lazyload\" data-src=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/start-postgres-database.png?resize=846%2C220&#038;ssl=1\" alt=\"\" width=\"846\" height=\"220\" data-srcset=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/start-postgres-database.png?w=846&amp;ssl=1 846w, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/start-postgres-database.png?resize=300%2C78&amp;ssl=1 300w, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/start-postgres-database.png?resize=768%2C200&amp;ssl=1 768w\" data-sizes=\"(max-width: 846px) 100vw, 846px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 846px; --smush-placeholder-aspect-ratio: 846\/220;\" \/><\/div>\n<p><strong>10.<\/strong> \u041f\u0456\u0441\u043b\u044f \u0437\u0430\u043f\u0443\u0441\u043a\u0443 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445 \u043f\u0435\u0440\u0435\u0432\u0456\u0440\u0442\u0435 \u0441\u0442\u0430\u043d \u043f\u0440\u043e\u0446\u0435\u0441\u0443 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 postgres \u0437\u0430 \u0434\u043e\u043f\u043e\u043c\u043e\u0433\u043e\u044e \u0442\u0430\u043a\u0438\u0445 \u043a\u043e\u043c\u0430\u043d\u0434 ps \u0456 netstat.<\/p>\n<pre><code class=\"language-bash\" data-line=\"\">$ ps -ef |grep -i postgres\n$ netstat -apn |grep -i 51751<\/code><\/pre>\n<div class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"27868\" data-permalink=\"https:\/\/linuxthebest.net\/uk\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/verify-postgresql-database\/\" data-orig-file=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/verify-postgresql-database.png?fit=831%2C286&amp;ssl=1\" data-orig-size=\"831,286\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Verify-PostgreSQL-Database\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/verify-postgresql-database.png?fit=831%2C286&amp;ssl=1\" class=\"aligncenter size-full wp-image-27868 lazyload\" data-src=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/verify-postgresql-database.png?resize=831%2C286&#038;ssl=1\" alt=\"\" width=\"831\" height=\"286\" data-srcset=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/verify-postgresql-database.png?w=831&amp;ssl=1 831w, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/verify-postgresql-database.png?resize=300%2C103&amp;ssl=1 300w, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/verify-postgresql-database.png?resize=768%2C264&amp;ssl=1 768w\" data-sizes=\"(max-width: 831px) 100vw, 831px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 831px; --smush-placeholder-aspect-ratio: 831\/286;\" \/><\/div>\n<p>\u041c\u0438 \u0431\u0430\u0447\u0438\u043c\u043e, \u0449\u043e \u043a\u043b\u0430\u0441\u0442\u0435\u0440 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445 \u043f\u0440\u0430\u0446\u044e\u0454 \u043d\u043e\u0440\u043c\u0430\u043b\u044c\u043d\u043e, \u0430 \u0436\u0443\u0440\u043d\u0430\u043b\u0438 \u0437\u0430\u043f\u0443\u0441\u043a\u0443 \u043c\u043e\u0436\u043d\u0430 \u0437\u043d\u0430\u0439\u0442\u0438 \u0432 \u043c\u0456\u0441\u0446\u0456, \u0437\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043e\u043c\u0443 \u0437 \u043e\u043f\u0446\u0456\u0454\u044e -l \u043f\u0456\u0434 \u0447\u0430\u0441 \u0437\u0430\u043f\u0443\u0441\u043a\u0443 \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0430 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445.<\/p>\n<p><strong>11.<\/strong> \u0422\u0435\u043f\u0435\u0440 \u043f\u0456\u0434\u043a\u043b\u044e\u0447\u0456\u0442\u044c\u0441\u044f \u0434\u043e \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445 \u0456 \u0441\u0442\u0432\u043e\u0440\u0456\u0442\u044c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u0438\u0445 \u0437\u0430 \u0434\u043e\u043f\u043e\u043c\u043e\u0433\u043e\u044e \u0442\u0430\u043a\u0438\u0445 \u043a\u043e\u043c\u0430\u043d\u0434.<\/p>\n<pre><code class=\"language-bash\" data-line=\"\">$ psql -p 51751\npostgres=# create database test;\npostgres=# \\l to list all databases in cluster\npostgres=# \\q to quit form postgres console<\/code><\/pre>\n<div class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"27869\" data-permalink=\"https:\/\/linuxthebest.net\/uk\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/connect-postgresql-database\/\" data-orig-file=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/connect-postgresql-database.png?fit=705%2C321&amp;ssl=1\" data-orig-size=\"705,321\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Connect-PostgreSQL-Database\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/connect-postgresql-database.png?fit=705%2C321&amp;ssl=1\" class=\"aligncenter size-full wp-image-27869 lazyload\" data-src=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/connect-postgresql-database.png?resize=705%2C321&#038;ssl=1\" alt=\"\" width=\"705\" height=\"321\" data-srcset=\"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/connect-postgresql-database.png?w=705&amp;ssl=1 705w, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/connect-postgresql-database.png?resize=300%2C137&amp;ssl=1 300w\" data-sizes=\"(max-width: 705px) 100vw, 705px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 705px; --smush-placeholder-aspect-ratio: 705\/321;\" \/><\/div>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL \u0442\u0430\u043a\u043e\u0436 \u043d\u0430\u0437\u0438\u0432\u0430\u0454\u0442\u044c\u0441\u044f Postgres &#8211; \u0446\u0435 \u043f\u043e\u0442\u0443\u0436\u043d\u0430 \u043e\u0431&#8217;\u0454\u043a\u0442\u043d\u043e-\u0440\u0435\u043b\u044f\u0446\u0456\u0439\u043d\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445 \u0437 \u0432\u0456\u0434\u043a\u0440\u0438\u0442\u0438\u043c \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u043c \u043a\u043e\u0434\u043e\u043c. \u0426\u0435 \u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u0438\u0445 \u043a\u043e\u0440\u043f\u043e\u0440\u0430\u0442\u0438\u0432\u043d\u043e\u0433\u043e \u0440\u0456\u0432\u043d\u044f \u0437 \u0442\u0430\u043a\u0438\u043c\u0438 \u0444\u0443\u043d\u043a\u0446\u0456\u044f\u043c\u0438, \u044f\u043a \u0432\u0435\u0434\u0435\u043d\u043d\u044f \u0436\u0443\u0440\u043d\u0430\u043b\u0443 \u0437 \u0432\u0438\u043f\u0435\u0440\u0435\u0434\u0436\u0435\u043d\u043d\u044f\u043c \u0437\u0430\u043f\u0438\u0441\u0443 \u0434\u043b\u044f \u0437\u0430\u0431\u0435\u0437\u043f\u0435\u0447\u0435\u043d\u043d\u044f \u0432\u0456\u0434\u043c\u043e\u0432\u043e\u0441\u0442\u0456\u0439\u043a\u043e\u0441\u0442\u0456, \u0430\u0441\u0438\u043d\u0445\u0440\u043e\u043d\u043d\u0430 \u0440\u0435\u043f\u043b\u0456\u043a\u0430\u0446\u0456\u044f, \u0431\u0430\u0433\u0430\u0442\u043e\u0432\u0435\u0440\u0441\u0456\u0439\u043d\u0438\u0439 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u044c \u043f\u0430\u0440\u0430\u043b\u0435\u043b\u0456\u0437\u043c\u0443 (MVCC), \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0435 \u043a\u043e\u043f\u0456\u044e\u0432\u0430\u043d\u043d\u044f \u043e\u043d\u043b\u0430\u0439\u043d\/\u0433\u0430\u0440\u044f\u0447\u0435 \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0435 \u043a\u043e\u043f\u0456\u044e\u0432\u0430\u043d\u043d\u044f, \u0432\u0456\u0434\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044f \u0437\u0430 \u0442\u043e\u0447\u043a\u0430\u043c\u0438, \u043f\u043b\u0430\u043d\u0443\u0432\u0430\u043b\u044c\u043d\u0438\u043a\/\u043e\u043f\u0442\u0438\u043c\u0456\u0437\u0430\u0442\u043e\u0440 \u0437\u0430\u043f\u0438\u0442\u0456\u0432, \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u0456 \u043f\u0440\u043e\u0441\u0442\u043e\u0440\u0438, \u0432\u043a\u043b\u0430\u0434\u0435\u043d\u0456 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0456\u0457 (\u0442\u043e\u0447\u043a\u0438 \u0437\u0431\u0435\u0440\u0435\u0436\u0435\u043d\u043d\u044f) \u0442\u043e\u0449\u043e. [&hellip;]<\/p>\n","protected":false},"author":3227,"featured_media":27864,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[211,604,396],"tags":[76,3957,3631],"class_list":["post-27863","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-terminal","category-programmy","category-rabochee-okruzhenie","tag-linux","tag-postgres","tag-postgresql"],"blocksy_meta":[],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"uk","enabled_languages":["ru","uk"],"languages":{"ru":{"title":true,"content":true,"excerpt":false},"uk":{"title":true,"content":true,"excerpt":false}}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0432 Linux<\/title>\n<meta name=\"description\" content=\"PostgreSQL \u0442\u0430\u043a\u043e\u0436 \u043d\u0430\u0437\u0438\u0432\u0430\u0454\u0442\u044c\u0441\u044f Postgres - \u0446\u0435 \u043f\u043e\u0442\u0443\u0436\u043d\u0430 \u043e\u0431&#039;\u0454\u043a\u0442\u043d\u043e-\u0440\u0435\u043b\u044f\u0446\u0456\u0439\u043d\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445 \u0437 \u0432\u0456\u0434\u043a\u0440\u0438\u0442\u0438\u043c \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u043c \u043a\u043e\u0434\u043e\u043c\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/\" \/>\n<meta property=\"og:locale\" content=\"uk_UA\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0432 Linux\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL \u0442\u0430\u043a\u043e\u0436 \u043d\u0430\u0437\u0438\u0432\u0430\u0454\u0442\u044c\u0441\u044f Postgres - \u0446\u0435 \u043f\u043e\u0442\u0443\u0436\u043d\u0430 \u043e\u0431&#039;\u0454\u043a\u0442\u043d\u043e-\u0440\u0435\u043b\u044f\u0446\u0456\u0439\u043d\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445 \u0437 \u0432\u0456\u0434\u043a\u0440\u0438\u0442\u0438\u043c \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u043c \u043a\u043e\u0434\u043e\u043c\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"LinuxTheBest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/UserAndLINUX\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-04T05:04:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/postgres-logo-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"walle9054\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@UserAndLINUX\" \/>\n<meta name=\"twitter:site\" content=\"@UserAndLINUX\" \/>\n<meta name=\"twitter:label1\" content=\"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e\" \/>\n\t<meta name=\"twitter:data1\" content=\"walle9054\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u041f\u0440\u0438\u0431\u043b. \u0447\u0430\u0441 \u0447\u0438\u0442\u0430\u043d\u043d\u044f\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u0445\u0432\u0438\u043b\u0438\u043d\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/\"},\"author\":{\"name\":\"walle9054\",\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/#\\\/schema\\\/person\\\/4ef8b04b8a00956d024e66df7f488c3b\"},\"headline\":\"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0432 Linux\",\"datePublished\":\"2023-05-04T05:04:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/\"},\"wordCount\":1228,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/linuxthebest.net\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/postgres-logo-1.png?fit=1920%2C1080&ssl=1\",\"keywords\":[\"linux\",\"Postgres\",\"PostgreSQL\"],\"articleSection\":[\"\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438\",\"\u041f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u044b\",\"\u0420\u0430\u0431\u043e\u0447\u0435\u0435 \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u0435\"],\"inLanguage\":\"uk\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/\",\"url\":\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/\",\"name\":\"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0432 Linux\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/linuxthebest.net\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/postgres-logo-1.png?fit=1920%2C1080&ssl=1\",\"datePublished\":\"2023-05-04T05:04:41+00:00\",\"description\":\"PostgreSQL \u0442\u0430\u043a\u043e\u0436 \u043d\u0430\u0437\u0438\u0432\u0430\u0454\u0442\u044c\u0441\u044f Postgres - \u0446\u0435 \u043f\u043e\u0442\u0443\u0436\u043d\u0430 \u043e\u0431'\u0454\u043a\u0442\u043d\u043e-\u0440\u0435\u043b\u044f\u0446\u0456\u0439\u043d\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445 \u0437 \u0432\u0456\u0434\u043a\u0440\u0438\u0442\u0438\u043c \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u043c \u043a\u043e\u0434\u043e\u043c\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/#breadcrumb\"},\"inLanguage\":\"uk\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"uk\",\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/linuxthebest.net\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/postgres-logo-1.png?fit=1920%2C1080&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/linuxthebest.net\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/postgres-logo-1.png?fit=1920%2C1080&ssl=1\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f\",\"item\":\"https:\\\/\\\/linuxthebest.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438\",\"item\":\"https:\\\/\\\/linuxthebest.net\\\/terminal\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u041a\u0430\u043a \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c PostgreSQL \u0438\u0437 \u0438\u0441\u0445\u043e\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0430 \u0432 Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/#website\",\"url\":\"https:\\\/\\\/linuxthebest.net\\\/\",\"name\":\"LinuxTheBest\",\"description\":\"\u0412\u0430\u0448 \u043f\u0440\u043e\u0432\u0456\u0434\u043d\u0438\u043a \u0443 \u0434\u0438\u0432\u043e\u0432\u0438\u0436\u043d\u0438\u0439 \u0441\u0432\u0456\u0442 Linux\",\"publisher\":{\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/linuxthebest.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"uk\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/#organization\",\"name\":\"UALinux\",\"url\":\"https:\\\/\\\/linuxthebest.net\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"uk\",\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/linuxthebest.net\\\/wp-content\\\/uploads\\\/2010\\\/06\\\/UALinux.png\",\"contentUrl\":\"https:\\\/\\\/linuxthebest.net\\\/wp-content\\\/uploads\\\/2010\\\/06\\\/UALinux.png\",\"width\":270,\"height\":73,\"caption\":\"UALinux\"},\"image\":{\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/UserAndLINUX\",\"https:\\\/\\\/x.com\\\/UserAndLINUX\",\"https:\\\/\\\/www.linkedin.com\\\/groups\\\/7487863\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/linuxthebest.net\\\/#\\\/schema\\\/person\\\/4ef8b04b8a00956d024e66df7f488c3b\",\"name\":\"walle9054\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"uk\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ca1cd3a0da5794e9defce526252afa41fcd26be7662ae17e81bf6e994b1b2c1d?s=96&d=wavatar&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ca1cd3a0da5794e9defce526252afa41fcd26be7662ae17e81bf6e994b1b2c1d?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ca1cd3a0da5794e9defce526252afa41fcd26be7662ae17e81bf6e994b1b2c1d?s=96&d=wavatar&r=g\",\"caption\":\"walle9054\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0432 Linux","description":"PostgreSQL \u0442\u0430\u043a\u043e\u0436 \u043d\u0430\u0437\u0438\u0432\u0430\u0454\u0442\u044c\u0441\u044f Postgres - \u0446\u0435 \u043f\u043e\u0442\u0443\u0436\u043d\u0430 \u043e\u0431'\u0454\u043a\u0442\u043d\u043e-\u0440\u0435\u043b\u044f\u0446\u0456\u0439\u043d\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445 \u0437 \u0432\u0456\u0434\u043a\u0440\u0438\u0442\u0438\u043c \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u043c \u043a\u043e\u0434\u043e\u043c","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/","og_locale":"uk_UA","og_type":"article","og_title":"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0432 Linux","og_description":"PostgreSQL \u0442\u0430\u043a\u043e\u0436 \u043d\u0430\u0437\u0438\u0432\u0430\u0454\u0442\u044c\u0441\u044f Postgres - \u0446\u0435 \u043f\u043e\u0442\u0443\u0436\u043d\u0430 \u043e\u0431'\u0454\u043a\u0442\u043d\u043e-\u0440\u0435\u043b\u044f\u0446\u0456\u0439\u043d\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445 \u0437 \u0432\u0456\u0434\u043a\u0440\u0438\u0442\u0438\u043c \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u043c \u043a\u043e\u0434\u043e\u043c","og_url":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/","og_site_name":"LinuxTheBest","article_publisher":"https:\/\/www.facebook.com\/UserAndLINUX","article_published_time":"2023-05-04T05:04:41+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/postgres-logo-1.png","type":"image\/png"}],"author":"walle9054","twitter_card":"summary_large_image","twitter_creator":"@UserAndLINUX","twitter_site":"@UserAndLINUX","twitter_misc":{"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e":"walle9054","\u041f\u0440\u0438\u0431\u043b. \u0447\u0430\u0441 \u0447\u0438\u0442\u0430\u043d\u043d\u044f":"8 \u0445\u0432\u0438\u043b\u0438\u043d"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/#article","isPartOf":{"@id":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/"},"author":{"name":"walle9054","@id":"https:\/\/linuxthebest.net\/#\/schema\/person\/4ef8b04b8a00956d024e66df7f488c3b"},"headline":"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0432 Linux","datePublished":"2023-05-04T05:04:41+00:00","mainEntityOfPage":{"@id":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/"},"wordCount":1228,"commentCount":0,"publisher":{"@id":"https:\/\/linuxthebest.net\/#organization"},"image":{"@id":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/postgres-logo-1.png?fit=1920%2C1080&ssl=1","keywords":["linux","Postgres","PostgreSQL"],"articleSection":["\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438","\u041f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u044b","\u0420\u0430\u0431\u043e\u0447\u0435\u0435 \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u0435"],"inLanguage":"uk","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/","url":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/","name":"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL \u0437 \u0432\u0438\u0445\u0456\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0443 \u0432 Linux","isPartOf":{"@id":"https:\/\/linuxthebest.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/#primaryimage"},"image":{"@id":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/postgres-logo-1.png?fit=1920%2C1080&ssl=1","datePublished":"2023-05-04T05:04:41+00:00","description":"PostgreSQL \u0442\u0430\u043a\u043e\u0436 \u043d\u0430\u0437\u0438\u0432\u0430\u0454\u0442\u044c\u0441\u044f Postgres - \u0446\u0435 \u043f\u043e\u0442\u0443\u0436\u043d\u0430 \u043e\u0431'\u0454\u043a\u0442\u043d\u043e-\u0440\u0435\u043b\u044f\u0446\u0456\u0439\u043d\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445 \u0437 \u0432\u0456\u0434\u043a\u0440\u0438\u0442\u0438\u043c \u0432\u0438\u0445\u0456\u0434\u043d\u0438\u043c \u043a\u043e\u0434\u043e\u043c","breadcrumb":{"@id":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/#breadcrumb"},"inLanguage":"uk","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/"]}]},{"@type":"ImageObject","inLanguage":"uk","@id":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/#primaryimage","url":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/postgres-logo-1.png?fit=1920%2C1080&ssl=1","contentUrl":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/postgres-logo-1.png?fit=1920%2C1080&ssl=1","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/linuxthebest.net\/yak-vstanoviti-postgresql-z-vihidnogo-kodu-v-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f","item":"https:\/\/linuxthebest.net\/"},{"@type":"ListItem","position":2,"name":"\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438","item":"https:\/\/linuxthebest.net\/terminal\/"},{"@type":"ListItem","position":3,"name":"\u041a\u0430\u043a \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c PostgreSQL \u0438\u0437 \u0438\u0441\u0445\u043e\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0430 \u0432 Linux"}]},{"@type":"WebSite","@id":"https:\/\/linuxthebest.net\/#website","url":"https:\/\/linuxthebest.net\/","name":"LinuxTheBest","description":"\u0412\u0430\u0448 \u043f\u0440\u043e\u0432\u0456\u0434\u043d\u0438\u043a \u0443 \u0434\u0438\u0432\u043e\u0432\u0438\u0436\u043d\u0438\u0439 \u0441\u0432\u0456\u0442 Linux","publisher":{"@id":"https:\/\/linuxthebest.net\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linuxthebest.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"uk"},{"@type":"Organization","@id":"https:\/\/linuxthebest.net\/#organization","name":"UALinux","url":"https:\/\/linuxthebest.net\/","logo":{"@type":"ImageObject","inLanguage":"uk","@id":"https:\/\/linuxthebest.net\/#\/schema\/logo\/image\/","url":"https:\/\/linuxthebest.net\/wp-content\/uploads\/2010\/06\/UALinux.png","contentUrl":"https:\/\/linuxthebest.net\/wp-content\/uploads\/2010\/06\/UALinux.png","width":270,"height":73,"caption":"UALinux"},"image":{"@id":"https:\/\/linuxthebest.net\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/UserAndLINUX","https:\/\/x.com\/UserAndLINUX","https:\/\/www.linkedin.com\/groups\/7487863\/"]},{"@type":"Person","@id":"https:\/\/linuxthebest.net\/#\/schema\/person\/4ef8b04b8a00956d024e66df7f488c3b","name":"walle9054","image":{"@type":"ImageObject","inLanguage":"uk","@id":"https:\/\/secure.gravatar.com\/avatar\/ca1cd3a0da5794e9defce526252afa41fcd26be7662ae17e81bf6e994b1b2c1d?s=96&d=wavatar&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ca1cd3a0da5794e9defce526252afa41fcd26be7662ae17e81bf6e994b1b2c1d?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ca1cd3a0da5794e9defce526252afa41fcd26be7662ae17e81bf6e994b1b2c1d?s=96&d=wavatar&r=g","caption":"walle9054"}}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/05\/postgres-logo-1.png?fit=1920%2C1080&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p7Dc7N-7fp","jetpack-related-posts":[{"id":24761,"url":"https:\/\/linuxthebest.net\/uk\/yak-vstanovyty-postgresql-15-na-rocky-linux-ta-almalinux\/","url_meta":{"origin":27863,"position":0},"title":"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PostgreSQL 15 \u043d\u0430 Rocky Linux \u0442\u0430 AlmaLinux","author":"walle9054","date":"2022-10-26","format":false,"excerpt":"{:ru}PostgreSQL \u2014 \u0447\u0440\u0435\u0437\u0432\u044b\u0447\u0430\u0439\u043d\u043e \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u0430\u044f \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u043c\u0438 \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 (RDBMS) \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u043c \u043a\u043e\u0434\u043e\u043c, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442 \u0443\u0436\u0435 \u0431\u043e\u043b\u0435\u0435 30 \u043b\u0435\u0442. \u041e\u043d \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u0435\u0442 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0443 \u044f\u0437\u044b\u043a\u0430 SQL, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439 CRUD (\u0441\u043e\u0437\u0434\u0430\u0442\u044c, \u043f\u0440\u043e\u0447\u0438\u0442\u0430\u0442\u044c, \u043e\u0431\u043d\u043e\u0432\u0438\u0442\u044c, \u0443\u0434\u0430\u043b\u0438\u0442\u044c). PostgreSQL \u0437\u0430\u0440\u0430\u0431\u043e\u0442\u0430\u043b \u043f\u0440\u043e\u0447\u043d\u0443\u044e \u0440\u0435\u043f\u0443\u0442\u0430\u0446\u0438\u044e \u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u0441\u0432\u043e\u0435\u0439 \u043d\u0430\u0434\u0435\u0436\u043d\u043e\u0441\u0442\u0438, \u0433\u0438\u0431\u043a\u043e\u0441\u0442\u0438 \u0438 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438. \u042d\u0442\u043e\u2026","rel":"","context":"\u0423 &quot;\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438&quot;","block_context":{"text":"\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438","link":"https:\/\/linuxthebest.net\/uk\/terminal\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2022\/10\/postgresql-logo.png?fit=1200%2C750&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2022\/10\/postgresql-logo.png?fit=1200%2C750&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2022\/10\/postgresql-logo.png?fit=1200%2C750&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2022\/10\/postgresql-logo.png?fit=1200%2C750&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2022\/10\/postgresql-logo.png?fit=1200%2C750&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":29401,"url":"https:\/\/linuxthebest.net\/uk\/yak-vstanoviti-pgadmin-4-na-debian-11\/","url_meta":{"origin":27863,"position":1},"title":"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 PgAdmin 4 \u043d\u0430 Debian 11","author":"walle9054","date":"2023-08-28","format":false,"excerpt":"{:ru}pgAdmin - \u044d\u0442\u043e \u043c\u043e\u0449\u043d\u043e\u0435 \u0438 \u043c\u043d\u043e\u0433\u043e\u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0435 \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0441 \u0443\u0434\u043e\u0431\u043d\u044b\u043c \u0432\u0435\u0431-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441\u043e\u043c. \u042d\u0442\u043e \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u043e\u0434\u043d\u043e\u0439 \u0438\u0437 \u0441\u0430\u043c\u044b\u0445 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c \u0420\u0421\u0423\u0411\u0414 \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u043c \u043a\u043e\u0434\u043e\u043c - PostgreSQL. pgAdmin \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u043a\u0430\u043a \u043d\u043e\u0432\u0438\u0447\u043a\u0430\u043c\u0438, \u0442\u0430\u043a \u0438 \u043e\u043f\u044b\u0442\u043d\u044b\u043c\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f\u043c\u0438 Postgres. \u0412 pgAdmin \u0438\u043c\u0435\u044e\u0442\u0441\u044f \u0442\u0430\u043a\u0438\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438, \u043a\u0430\u043a Query Tool, ERD Tool \u0434\u043b\u044f \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f\u2026","rel":"","context":"\u0423 &quot;\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438&quot;","block_context":{"text":"\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438","link":"https:\/\/linuxthebest.net\/uk\/terminal\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/08\/pgadmin_welcome.png?fit=850%2C536&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/08\/pgadmin_welcome.png?fit=850%2C536&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/08\/pgadmin_welcome.png?fit=850%2C536&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/08\/pgadmin_welcome.png?fit=850%2C536&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":33531,"url":"https:\/\/linuxthebest.net\/uk\/yak-vstanoviti-opennms-na-ubuntu\/","url_meta":{"origin":27863,"position":2},"title":"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 OpenNMS \u043d\u0430 Ubuntu","author":"walle9054","date":"2024-04-15","format":false,"excerpt":"{:ru}OpenNMS - \u044d\u0442\u043e \u043c\u043e\u0449\u043d\u0430\u044f \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0430 \u0434\u043b\u044f \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0441\u0435\u0442\u044c\u044e \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u043c \u043a\u043e\u0434\u043e\u043c, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u0435\u0442 \u043f\u043e\u043b\u043d\u044b\u0439 \u043d\u0430\u0431\u043e\u0440 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 \u0434\u043b\u044f \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u044f \u0438 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u0432\u0430\u0448\u0435\u0439 \u0441\u0435\u0442\u0435\u0432\u043e\u0439 \u0438\u043d\u0444\u0440\u0430\u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b. \u0411\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u043c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u0443\u0435\u043c\u043e\u0439 \u0430\u0440\u0445\u0438\u0442\u0435\u043a\u0442\u0443\u0440\u0435, \u0433\u0438\u0431\u043a\u0438\u043c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044f\u043c \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0438 \u043e\u0431\u0448\u0438\u0440\u043d\u043e\u0439 \u044d\u043a\u043e\u0441\u0438\u0441\u0442\u0435\u043c\u0435 \u043f\u043b\u0430\u0433\u0438\u043d\u043e\u0432 OpenNMS \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0441\u0435\u0442\u0435\u0432\u044b\u043c \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0442\u043e\u0440\u0430\u043c \u043f\u0440\u043e\u0430\u043a\u0442\u0438\u0432\u043d\u043e \u0432\u044b\u044f\u0432\u043b\u044f\u0442\u044c \u0438 \u0443\u0441\u0442\u0440\u0430\u043d\u044f\u0442\u044c \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044f \u043e\u043f\u0442\u0438\u043c\u0430\u043b\u044c\u043d\u0443\u044e \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438\u2026","rel":"","context":"\u0423 &quot;\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438&quot;","block_context":{"text":"\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438","link":"https:\/\/linuxthebest.net\/uk\/terminal\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2024\/04\/opennms.jpg?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2024\/04\/opennms.jpg?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2024\/04\/opennms.jpg?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2024\/04\/opennms.jpg?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2024\/04\/opennms.jpg?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":49767,"url":"https:\/\/linuxthebest.net\/uk\/yak-vstanoviti-wiki-js-na-almalinux\/","url_meta":{"origin":27863,"position":3},"title":"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 Wiki.js \u043d\u0430 AlmaLinux","author":"walle9054","date":"2024-10-10","format":false,"excerpt":"{:ru}Wiki.js - \u044d\u0442\u043e \u0441\u043e\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u0430\u044f \u0438 \u043c\u043e\u0449\u043d\u0430\u044f \u0432\u0438\u043a\u0438-\u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0430 \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u043c \u043a\u043e\u0434\u043e\u043c, \u043f\u043e\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u0430\u044f \u043d\u0430 Node.js. \u041e\u043d\u0430 \u043f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u0435\u0442 \u0443\u0434\u043e\u0431\u043d\u044b\u0439 \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f, \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0438 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u0438 \u043a\u043e\u043d\u0442\u0435\u043d\u0442\u0430, \u0447\u0442\u043e \u0434\u0435\u043b\u0430\u0435\u0442 \u0435\u0435 \u043e\u0442\u043b\u0438\u0447\u043d\u044b\u043c \u0432\u044b\u0431\u043e\u0440\u043e\u043c \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u0438 \u0438 \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u043d\u043e\u0439 \u0440\u0430\u0431\u043e\u0442\u044b. \u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e \u043f\u043e\u043b\u043d\u043e\u0435 \u043f\u043e\u0448\u0430\u0433\u043e\u0432\u043e\u0435 \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0435 Wiki.js \u043d\u0430 AlmaLinux 9, \u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u0447\u0435\u043c\u0443\u2026","rel":"","context":"\u0423 &quot;\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438&quot;","block_context":{"text":"\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438","link":"https:\/\/linuxthebest.net\/uk\/terminal\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2024\/10\/4342a08df803840d4d20249ba2b68df7.png?fit=780%2C440&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2024\/10\/4342a08df803840d4d20249ba2b68df7.png?fit=780%2C440&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2024\/10\/4342a08df803840d4d20249ba2b68df7.png?fit=780%2C440&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2024\/10\/4342a08df803840d4d20249ba2b68df7.png?fit=780%2C440&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":23703,"url":"https:\/\/linuxthebest.net\/uk\/yak-vstanovyty-netbox-irm-u-debian-11\/","url_meta":{"origin":27863,"position":4},"title":"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 NetBox IRM \u0443 Debian 11","author":"walle9054","date":"2022-08-18","format":false,"excerpt":"{:ru}NetBox \u2014 \u044d\u0442\u043e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u043e\u0435 \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0435\u043d\u0438\u0435 \u0434\u043b\u044f \u043c\u043e\u0434\u0435\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0440\u0435\u0441\u0443\u0440\u0441\u043e\u0432 \u0438\u043d\u0444\u0440\u0430\u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b (IRM), \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u043e\u0435 \u0434\u043b\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0437\u0430\u0446\u0438\u0438 \u0441\u0435\u0442\u0435\u0439 \u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0438\u043d\u0444\u0440\u0430\u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b. \u0418\u0437\u043d\u0430\u0447\u0430\u043b\u044c\u043d\u043e \u043e\u043d \u0431\u044b\u043b \u0441\u043e\u0437\u0434\u0430\u043d \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439 DigitalOcean, \u0430 \u0442\u0435\u043f\u0435\u0440\u044c \u0441\u0442\u0430\u043b \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u043c \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u043c \u043a\u043e\u0434\u043e\u043c, \u0432\u044b\u043f\u0443\u0449\u0435\u043d\u043d\u044b\u043c \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 Apache 2. NetBox \u0431\u044b\u043b \u0441\u043e\u0437\u0434\u0430\u043d \u0432 \u0432\u0435\u0431-\u0438\u043d\u0444\u0440\u0430\u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0435 Python Django \u0441 PostgreSQL \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u043e\u2026","rel":"","context":"\u0423 &quot;\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438&quot;","block_context":{"text":"\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438","link":"https:\/\/linuxthebest.net\/uk\/terminal\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2022\/08\/annotation-2019-05-05-171345.png?fit=848%2C538&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2022\/08\/annotation-2019-05-05-171345.png?fit=848%2C538&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2022\/08\/annotation-2019-05-05-171345.png?fit=848%2C538&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2022\/08\/annotation-2019-05-05-171345.png?fit=848%2C538&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":29975,"url":"https:\/\/linuxthebest.net\/uk\/yak-vstanoviti-fathom-web-analytics-na-debian-12\/","url_meta":{"origin":27863,"position":5},"title":"\u042f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 Fathom Web Analytics \u043d\u0430 Debian 12","author":"walle9054","date":"2023-10-05","format":false,"excerpt":"{:ru}Fathom - \u044d\u0442\u043e \u0432\u0435\u0431-\u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0430, \u043e\u0440\u0438\u0435\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u0430\u044f \u043d\u0430 \u043a\u043e\u043d\u0444\u0438\u0434\u0435\u043d\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0430\u044f \u0447\u0438\u0441\u0442\u044b\u0435 \u0438 \u0447\u0435\u0442\u043a\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043e \u0432\u0430\u0448\u0438\u0445 \u0441\u0430\u0439\u0442\u0430\u0445. Fathom \u0441\u043e\u0437\u0434\u0430\u043d\u0430 \u043a\u0430\u043a \u0430\u043b\u044c\u0442\u0435\u0440\u043d\u0430\u0442\u0438\u0432\u0430 Google Analytics, \u043d\u043e \u043f\u0440\u0438 \u044d\u0442\u043e\u043c \u043d\u0435 \u0432\u0442\u043e\u0440\u0433\u0430\u0435\u0442\u0441\u044f \u0432 \u0447\u0430\u0441\u0442\u043d\u0443\u044e \u0436\u0438\u0437\u043d\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u0438 \u043d\u0435 \u043a\u043e\u043c\u043f\u0440\u043e\u043c\u0435\u0442\u0438\u0440\u0443\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u043e \u043f\u043e\u0441\u0435\u0442\u0438\u0442\u0435\u043b\u044f\u0445. \u041e\u043d \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u0435\u0442 \u0442\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u044f\u043c GDPR \u0438 \u043d\u0435 \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438 \u0431\u0430\u043d\u043d\u0435\u0440\u043e\u0432 cookie. Fathom \u0432\u044b\u043f\u0443\u0441\u043a\u0430\u0435\u0442\u0441\u044f \u0432\u2026","rel":"","context":"\u0423 &quot;\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438&quot;","block_context":{"text":"\u0418\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438","link":"https:\/\/linuxthebest.net\/uk\/terminal\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/10\/fathom-analytics.webp?fit=1200%2C630&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/10\/fathom-analytics.webp?fit=1200%2C630&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/10\/fathom-analytics.webp?fit=1200%2C630&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/10\/fathom-analytics.webp?fit=1200%2C630&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/linuxthebest.net\/wp-content\/uploads\/2023\/10\/fathom-analytics.webp?fit=1200%2C630&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/linuxthebest.net\/uk\/wp-json\/wp\/v2\/posts\/27863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxthebest.net\/uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxthebest.net\/uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxthebest.net\/uk\/wp-json\/wp\/v2\/users\/3227"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxthebest.net\/uk\/wp-json\/wp\/v2\/comments?post=27863"}],"version-history":[{"count":2,"href":"https:\/\/linuxthebest.net\/uk\/wp-json\/wp\/v2\/posts\/27863\/revisions"}],"predecessor-version":[{"id":27871,"href":"https:\/\/linuxthebest.net\/uk\/wp-json\/wp\/v2\/posts\/27863\/revisions\/27871"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxthebest.net\/uk\/wp-json\/wp\/v2\/media\/27864"}],"wp:attachment":[{"href":"https:\/\/linuxthebest.net\/uk\/wp-json\/wp\/v2\/media?parent=27863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxthebest.net\/uk\/wp-json\/wp\/v2\/categories?post=27863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxthebest.net\/uk\/wp-json\/wp\/v2\/tags?post=27863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}