{"id":509,"date":"2017-05-19T12:24:08","date_gmt":"2017-05-19T10:24:08","guid":{"rendered":"http:\/\/blog.via-internet.de\/?p=509"},"modified":"2022-01-13T17:02:09","modified_gmt":"2022-01-13T16:02:09","slug":"postgres-getting-started","status":"publish","type":"post","link":"https:\/\/via-internet.de\/blog\/2017\/05\/19\/postgres-getting-started\/","title":{"rendered":"PostgreSQL | Getting started"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"install\">Install<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"postgresql-server\">PostgreSQL Server<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"mac-os\">Mac OS<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">brew install postgres<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"windows-installer\">Windows (Installer)<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"windows-zip-archiv\">Windows (Zip-ARchiv)<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Download postgresql from&nbsp;https:\/\/www.enterprisedb.com\/download-postgresql-binaries<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"configure\">Configure<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Initialize database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>initdb.exe -D ..\/data \u2013-username=postgres \u2013-auth=trust<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Start the database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>pg_ctl.exe start -D ..\/data<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Log into the database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>psql \u2013-username=postgres<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Create a password for your user:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER postgres WITH PASSWORD \u2018VeryVerySecret\u2019;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Install adminpack extension:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE EXTENSION adminpack;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"manage-users\">Manage Users<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"preparation\">Preparation<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">psql postgres<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"list-all-users\">List all Users<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">postgres=# \\du+<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"create-superuser\">Create Superuser<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"> create role superuser superuser login password 'pAssw8rd';<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"change-password\">Change Password<\/h3>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"postgres-utilities\">Postgres Utilities<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.pgadmin.org\/download\/\">pgAdmin<\/a><\/li><li><a href=\"http:\/\/www.psequel.com\/\">PSequel, a PostgreSQL GUI Tool for macOS<\/a><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"documentation\">Documentation<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.postgresql.org\/docs\/9.6\/static\/upgrading.html\">Upgrade<\/a><\/li><li><a href=\"https:\/\/www.postgresql.org\/docs\/9.6\/static\/pgupgrade.html\">Migrate existing data from a previous minor version (9.0-9.5) of PostgreSQL<\/a><\/li><li><a href=\"https:\/\/gist.github.com\/Kartones\/dd3ff5ec5ea238d4c546#file-postgres-cheatsheet-md\">PostgreSQL command line cheatsheet (github.com)<\/a><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"working-with\">Working with<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Install PostgreSQL Server Mac OS Windows (Installer) Windows (Zip-ARchiv) Download postgresql from&nbsp;https:\/\/www.enterprisedb.com\/download-postgresql-binaries Configure Initialize database: Start the database: Log into the database: Create a password for your user: Install adminpack extension: Manage Users Preparation List all Users Create Superuser Change Password Postgres Utilities pgAdmin PSequel, a PostgreSQL GUI Tool for macOS Documentation Upgrade Migrate existing data from a previous minor version (9.0-9.5) of PostgreSQL PostgreSQL command line cheatsheet (github.com) Working with<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[58],"tags":[],"class_list":["post-509","post","type-post","status-publish","format-standard","hentry","category-postgresql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/509","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/comments?post=509"}],"version-history":[{"count":2,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/509\/revisions"}],"predecessor-version":[{"id":8645,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/509\/revisions\/8645"}],"wp:attachment":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/media?parent=509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/categories?post=509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/tags?post=509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}