{"id":283,"date":"2022-04-17T23:29:54","date_gmt":"2022-04-17T21:29:54","guid":{"rendered":"https:\/\/schoppe.it\/wiki\/?p=283"},"modified":"2024-09-03T08:51:16","modified_gmt":"2024-09-03T06:51:16","slug":"postgres-datenbank-server-installieren","status":"publish","type":"post","link":"https:\/\/schoppe.it\/wiki\/postgres-datenbank-server-installieren\/","title":{"rendered":"Postgres Datenbank Server installieren"},"content":{"rendered":"\n<p>Nachdem ein neuer Linux Debian 11 Server installiert wurde, die folgenden Schritte ausf\u00fchren.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\napt update\napt upgrade\n\napt install postgresql postgresql-client\n<\/pre><\/div>\n\n\n<p>Status der PostgreSQL Datenbank pr\u00fcfen mit <em>pg_isready <\/em>und <em>systemctl status postresql<\/em>:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\npg_isready\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"395\" height=\"33\" src=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_isready.png\" alt=\"\" class=\"wp-image-261\" srcset=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_isready.png 395w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/pg_isready-300x25.png 300w\" sizes=\"auto, (max-width: 395px) 100vw, 395px\" \/><figcaption>pg_isready<\/figcaption><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsystemctl status postgresql\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"757\" height=\"193\" src=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/systemctl_status_postgresql.png\" alt=\"\" class=\"wp-image-259\" srcset=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/systemctl_status_postgresql.png 757w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/systemctl_status_postgresql-300x76.png 300w\" sizes=\"auto, (max-width: 757px) 100vw, 757px\" \/><figcaption>systemctl status postgresql<\/figcaption><\/figure>\n\n\n\n<p>\u00dcberpr\u00fcfen, ob der Standard <em>postgres <\/em>User angelegt wurde:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ngrep postgre \/etc\/passwd\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"619\" height=\"32\" src=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/grep_postgre.png\" alt=\"\" class=\"wp-image-263\" srcset=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/grep_postgre.png 619w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/grep_postgre-300x16.png 300w\" sizes=\"auto, (max-width: 619px) 100vw, 619px\" \/><figcaption>grep postgre \/etc\/passwd<\/figcaption><\/figure>\n\n\n\n<p>Wechseln zum postgres User und in PostgreSQL einloggen:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nsudo -u postgres -i psql\noder\nsu -c \/usr\/bin\/psql postgres\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"320\" height=\"101\" src=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/sudo-u-postgres-i.png\" alt=\"\" class=\"wp-image-266\" srcset=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/sudo-u-postgres-i.png 320w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/sudo-u-postgres-i-300x95.png 300w\" sizes=\"auto, (max-width: 320px) 100vw, 320px\" \/><figcaption>sudo -u postgres -i psql<\/figcaption><\/figure>\n\n\n\n<p>PostgreSQL Version pr\u00fcfen:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nselect version ();\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1003\" height=\"95\" src=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/select-version.png\" alt=\"\" class=\"wp-image-268\" srcset=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/select-version.png 1003w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/select-version-300x28.png 300w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/select-version-768x73.png 768w\" sizes=\"auto, (max-width: 1003px) 100vw, 1003px\" \/><figcaption>select version ();<\/figcaption><\/figure>\n\n\n\n<p>Passwort des postgres Users \u00e4ndern:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nalter user postgres with password &#039;Start#123&#039;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"473\" height=\"32\" src=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/alter-user.png\" alt=\"\" class=\"wp-image-274\" srcset=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/alter-user.png 473w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/alter-user-300x20.png 300w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><figcaption>alter user postgres with password<\/figcaption><\/figure>\n\n\n\n<p>Postgres User anzeigen:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\npostgres=# \\du\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"92\" src=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/postgres-du.png\" alt=\"\" class=\"wp-image-276\" srcset=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/postgres-du.png 678w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/postgres-du-300x41.png 300w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><figcaption>\\du<\/figcaption><\/figure>\n\n\n\n<p>Postgres Datenbanken anzeigen (folgender Befehl wird im SyntaxHighlighter nicht angezeigt)<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\npostgres=# \\l\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"695\" height=\"166\" src=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/postgres-l.png\" alt=\"\" class=\"wp-image-275\" srcset=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/postgres-l.png 695w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2022\/04\/postgres-l-300x72.png 300w\" sizes=\"auto, (max-width: 695px) 100vw, 695px\" \/><figcaption>\\l<\/figcaption><\/figure>\n\n\n\n<p>PostgreSQL nutzt Port 5432 als Standard Port.<\/p>\n\n\n\n<p>Der PostgreSQL Server ist nun einsatzbereit.<\/p>\n\n\n\n<p>Quelle: <a href=\"https:\/\/wiki.debian.org\/PostgreSql\">https:\/\/wiki.debian.org\/PostgreSql<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nachdem ein neuer Linux Debian 11 Server installiert wurde, die folgenden Schritte ausf\u00fchren. Status der PostgreSQL Datenbank pr\u00fcfen mit pg_isready und systemctl status postresql: \u00dcberpr\u00fcfen, ob der Standard postgres User angelegt wurde: Wechseln zum postgres User und in PostgreSQL einloggen: PostgreSQL Version pr\u00fcfen: Passwort des postgres Users \u00e4ndern: Postgres User anzeigen: Postgres Datenbanken anzeigen (folgender&hellip; <a class=\"more-link\" href=\"https:\/\/schoppe.it\/wiki\/postgres-datenbank-server-installieren\/\"><span class=\"screen-reader-text\">Postgres Datenbank Server installieren<\/span> weiterlesen<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[118,119],"tags":[110,109],"powershell":[],"wordpress":[],"exchange":[],"linux":[91,111,104,117,115,113,114,116],"class_list":["post-283","post","type-post","status-publish","format-standard","hentry","category-linux","category-postgresql","tag-debian-11","tag-postgresql","linux-apt-install","linux-apt-update","linux-apt-upgrade","linux-grep","linux-pg_isready","linux-postgresql","linux-postgresql-client","linux-systemctl-status-postgresql","entry"],"_links":{"self":[{"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/posts\/283","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/comments?post=283"}],"version-history":[{"count":6,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/posts\/283\/revisions"}],"predecessor-version":[{"id":346,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/posts\/283\/revisions\/346"}],"wp:attachment":[{"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/media?parent=283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/categories?post=283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/tags?post=283"},{"taxonomy":"powershell","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/powershell?post=283"},{"taxonomy":"wordpress","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/wordpress?post=283"},{"taxonomy":"exchange","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/exchange?post=283"},{"taxonomy":"linux","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/linux?post=283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}