{"id":1219,"date":"2024-08-08T18:17:13","date_gmt":"2024-08-08T17:17:13","guid":{"rendered":"https:\/\/r-raimann.de\/WordPress\/?p=1219"},"modified":"2024-08-08T20:34:36","modified_gmt":"2024-08-08T19:34:36","slug":"install-postgresql","status":"publish","type":"post","link":"https:\/\/r-raimann.de\/WordPress\/install-postgresql\/","title":{"rendered":"Install Postgresql"},"content":{"rendered":"\n<pre id=\"script-box\" class=\"wp-block-preformatted\">sudo apt install -y postgresql<\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo -u postgres psql\nALTER USER postgres PASSWORD &lt;mypassword>;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo nano \/etc\/postgresql\/16\/main\/postgresql.conf\n\nlisten_addresses = '*'  # allow all IP's<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>nano \/etc\/postgresql\/16\/main\/pg_hba.conf\n\n# TYPE  DATABASE        USER            ADDRESS                 METHOD\n# IPv4\nhost    all             all             &lt;xxx.xxx.xxx.0\/24>      scram-sha-256\n# allow all IP's from xxx.xxx.xxx.* <\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl restart postgersql<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>sudo apt install -y postgresql<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[37,265],"tags":[274],"class_list":["post-1219","post","type-post","status-publish","format-standard","hentry","category-latest","category-virtualization","tag-postgres"],"_links":{"self":[{"href":"https:\/\/r-raimann.de\/WordPress\/wp-json\/wp\/v2\/posts\/1219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/r-raimann.de\/WordPress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/r-raimann.de\/WordPress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/r-raimann.de\/WordPress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/r-raimann.de\/WordPress\/wp-json\/wp\/v2\/comments?post=1219"}],"version-history":[{"count":3,"href":"https:\/\/r-raimann.de\/WordPress\/wp-json\/wp\/v2\/posts\/1219\/revisions"}],"predecessor-version":[{"id":1223,"href":"https:\/\/r-raimann.de\/WordPress\/wp-json\/wp\/v2\/posts\/1219\/revisions\/1223"}],"wp:attachment":[{"href":"https:\/\/r-raimann.de\/WordPress\/wp-json\/wp\/v2\/media?parent=1219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/r-raimann.de\/WordPress\/wp-json\/wp\/v2\/categories?post=1219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/r-raimann.de\/WordPress\/wp-json\/wp\/v2\/tags?post=1219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}