{"id":112213,"date":"2026-07-31T11:48:05","date_gmt":"2026-07-31T11:48:05","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?post_type=collection&#038;p=112213"},"modified":"2026-09-15T15:00:17","modified_gmt":"2026-09-15T15:00:17","slug":"how-to-get-started-with-postgresql-a-complete-set-of-hands-on-classes","status":"publish","type":"collection","link":"https:\/\/www.red-gate.com\/simple-talk\/collections\/how-to-get-started-with-postgresql-a-complete-set-of-hands-on-classes\/","title":{"rendered":"How to get started with PostgreSQL (complete step-by-step guide)"},"content":{"rendered":"\n<p><strong>This is Grant Fritchey&#8217;s complete set of step-by-step walkthrough guides for getting started with PostgreSQL, designed for any IT professional or newcomer who wants to add PostgreSQL to their existing skillset.<\/strong><\/p>\n\n\n\n<p>Originally intended to be proctored classes given in a live, in-person environment, Grant has aimed to make the documentation and scripts clear enough to walk through them independently from home. Scroll down to see the full series, and make sure to check the prerequisites listed at the bottom of the page before getting started.<\/p>\n\n\n\n<p><em>Want more PostgreSQL learning? Check out Grant&#8217;s other series, Learning PostgreSQL with Grant, <a href=\"https:\/\/www.red-gate.com\/simple-talk\/collections\/series-learning-postgresql-with-grant\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/em><\/p>\n\n\n\n<section id=\"articles-list-block_ed1a90c71c761e51f75a9375bd174470\" class=\"articles-list my-5xl\">\n    <div class=\"grid gap-3xl\">\n        <div class=\"@container\">\n    <article class=\"flex gap-2xl items-center flex-col @md:flex-row-reverse\">\n        <div class=\"w-full @md:w-1\/3 flex items-center justify-center peer\">\n            <a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/postgresql\/how-to-run-postgresql-in-docker-getting-started-with-postgresql-part-one\/\" aria-label=\"How to run PostgreSQL in Docker (getting started with PostgreSQL, part one)\" class=\"no-underline relative aspect-3\/2 bg-gray-100 border border-gray-100 dark:border-gray-800 flex items-center justify-center flex-col gap-md w-full p-md\">\n\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2025\/02\/shutterstock_2183736201-1024x683.jpg\" class=\"object-cover absolute inset-0 w-full h-full wp-post-image\" alt=\"\" srcset=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2025\/02\/shutterstock_2183736201-1024x683.jpg 1024w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2025\/02\/shutterstock_2183736201-300x200.jpg 300w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2025\/02\/shutterstock_2183736201-768x512.jpg 768w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2025\/02\/shutterstock_2183736201-1536x1024.jpg 1536w, https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2025\/02\/shutterstock_2183736201-2048x1365.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>\t<\/a>        <\/div>\n        <div class=\"w-full @md:w-2\/3 overflow-auto group\/content-text\">\n            \n<div class=\"block mb-md align-middle\">\n            \n        <a\n        href=\"https:\/\/www.red-gate.com\/simple-talk\/author\/grant-fritchey\/\"\n        class=\"group\/author inline align-middle no-style min-w-fit\"\n        rel=\"author\"\n    >\n        <img decoding=\"async\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2019\/12\/grant-fritchey-2020.jpg\"\n            alt=\"Image of author: Grant Fritchey\" \n            class=\"rounded-full align-middle w-6 h-6 duration-200 inline-block object-cover\"\/>\n        <span class=\"group-hover\/author:text-brand-600 peer\/ftr-image:text-brand-600 group-hover\/author:dark:text-brand-400 peer\/ftr-image:dark:text-brand-400 group-hover\/author:underline min-w-fit align-middle duration-200\">Grant Fritchey<\/span>\n    <\/a>\n\n        <span class=\"card__categories align-middle\">\n                                                        <span class=\"text-gray-600 align-middle dark:text-gray-400\">in<\/span>\n                    <a\n                    class=\"inline align-middle no-underline hover:text-brand-600 hover:dark:text-brand-400 hover:underline\"\n                    href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/postgresql\/\">\n                            PostgreSQL                    <\/a>\n                                        <\/span>\n<\/div>\n<a class=\"no-underline group\/content-text-lower\" href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/postgresql\/how-to-run-postgresql-in-docker-getting-started-with-postgresql-part-one\/ \">\n    <div>\n        <h1 class=\"\n            duration-200 mt-0 mb-1 text-xl\n            \n            peer-hover:group-[]\/content-text:text-brand-600\n            group-hover\/content-text-lower:text-brand-600\n\n            peer-hover:group-[]\/content-text:dark:text-brand-400\n            group-hover\/content-text-lower:dark:text-brand-400\n            \n            peer-hover:group-[]\/content-text:underline\n            group-hover\/content-text-lower:underline\n            \n        \">\n            How to run PostgreSQL in Docker (getting started with PostgreSQL, part one)        <\/h1>\n                    <p class=\"mb-0\">\n                Get PostgreSQL running in Docker in minutes with this step-by-step setup guide. Learn to pull the image, run a container,&#8230;            <\/p>\n            <\/div>\n            <div class=\"flex items-center gap-1 mt-md\">\n            <time>23 September 2026<\/time>\n            <span class=\"w-1 h-1 bg-current\tinline-block my-auto rounded-full\"><\/span>\n            <span>13 min read<\/span>\n                            <span class=\"hidden @lg:inline-block w-1 h-1 bg-current rounded-full\"><\/span>\n                <span class=\"hidden @lg:inline-flex\"><span class=\"inline-flex items-center gap-2\"><span class=\"inline-flex items-center gap-1\"><img decoding=\"async\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAYYAAAGGCAMAAABIXtbXAAADAFBMVEVHcEz\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AQH\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AAD\/AADxAADaAADBAAC4AAChAACbAACYAACvAADRAADsAAD8AADvAADHAACnAACEAAB7AAB6AAB4AADmAAD9AADdAADfAAD1AACRAAC7AADjAADzAADUAACHAAC+AADXAAD4AADoAACkAAB5AACeAACUAADEAAD+AAB2AABzAAB+AACsAACBAACLAAB3AADOAABxAADJAACOAADhAADGAAC0AABvAADLAABrAABkAAD\/JCT\/amr\/g4P\/gID\/CAj\/ZGT\/dnb\/SUn\/Q0P\/k5P\/5+f\/\/\/\/\/9vb\/uLj\/pKT\/8PD\/x8f\/cnL\/2tr\/\/f3\/2Nj\/FBT\/xcX\/\/v7\/qKj\/hYX\/+Pj\/+\/v\/zMz\/Pz\/\/iYn\/8\/P\/vr7\/U1P\/4OD\/0ND\/Rkb\/3t7\/1tb\/Ojr\/6en\/7e3\/jo7\/3Nz\/Njb\/Tk7\/Vlb\/5OT\/n5\/\/MjL\/wcH\/HBz\/W1v\/q6v\/Dg7\/m5v\/rq7\/sbH\/w8P\/YGD\/zs7\/4uL\/tLT\/Kir\/enr\/1NT\/0tL\/u7v\/oaH\/bGz\/l5f\/6+v\/fX3\/AAD\/AACzs7O0tLS1tbW2tra3t7e4uLi5ubm6urq7u7u8vLy9vb2+vr6\/v7\/AwMDBwcHCwsLDw8PExMTFxcXGxsbHx8fIyMjJycnKysrLy8vMzMzNzc3Ozs7Pz8\/Q0NDR0dHS0tLT09PU1NTV1dXW1tbX19fY2NjZ2dna2trb29vc3Nzd3d3e3t7f39\/g4ODh4eHi4uLj4+Pk5OTl5eXm5ubn5+fo6Ojp6enq6urr6+vs7Ozt7e3u7u7v7+\/w8PDx8fHy8vLz8\/P09PT19fX29vb39\/f4+Pj5+fn6+vr7+\/v8\/Pz9\/f3+\/v7\/\/\/+gwrn8AAAAs3RSTlMABypEQCECO3eBfaS9wNHz\/+zFt5V\/Zw0ahv\/wsi\/L94xaS3Cs42A2E5r83ddS\/f\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/nurEVaX8AABsWSURBVHic7Z33XxRHH4AFEUFEV0QUVBBQsEZ68zgOkA4nSznujiKIyYs16qmIJWgQxG5Efe0NJW9iYjR\/4bt3tCvbZnZ25rvHPr\/lE7nZnWenf2dm2TIjEhG5PEqc5SuiWT9ceBIZFbUyJjZ2Vdzq+PjVa9Zy6liXEB8fvz5xVeyGpJVRKzeyfglDEr1p+fKY2GQhI1NU5roym+PjtyTHJi1fbipRYOPW5UmxiQmpacTyXpx1qeu3xaZHrWD9vtCIzMhM3q66viHHjvi4mKzsnaxfnzmbsjN3rd+xm3r+B7I2dUtMUvaSrKxWRK3anso6\/wNIWbd6W2bUkikaERlJiQms81yaHQnJ6ZERrDNJVzYu37B9D+t8VkNaamLW1nB0sTE7KW4v69xFY3dqYvom1vlGkJ37kuPpd4PIsG5LZjgUi037EveCaokxWLc6NtvAKnZmJO4xuoJ51q5etZJ1fuIQFbsmXBTMk7YlK5J1tqKwKT1O7wkJRuzem5zBOnfVsSIz9QfWuaUnKevisoAP8qIjYwzWK8VkfRLYrmzE1lhDjM0IEZ8EcBYqekXMGtYZQ5u09emwTOzMimedJ2xYm7gSyogieusuo46RSbA3BkIzsTNryVVGwaTFZTOOQ9iauIN1JkBg95oshnXT1u1hOkrDYE8Mm7Xt6H2p5OImwoF1ifRFRKevMSUEs3kXZRFR8eE2b0eGzdsojiQiTQmSbI6l1GvaGa7Tp2RI2ZNOQUJE5mbWLwqd3fHZelvI3hvWs9iESEvWtYnYuM1sFFSRsidKRw0bTAuqMTWAwNQAAlMDCEwNIDA1gMDUAAJTAwhMDSAwNYDA1AACUwMITA0gMDWAwNQAAlMDCEwNIDA1gMDUAAJTAwhMDSAwNYDA1AAC42jYn5Obl1\/go7Aot7iklOivM8YYGsoOWMqtFQHYyvNzK4kloIaqkmofB0vI\/7YBNNTk1laIY62tqyeThgINjXn5TbbFdMvzm1vsJBOArqHqUKtNQoIX3tqWo3ftVFlXaxVJ2treUdJJKg3YGqoq8x0yEmapbSSQD1LUHJAqit6PoPAAoW8AsobOktauwPd2+j5LpzPw67QW6tVIlNU1yZVFQUR5B5HKCbAGe66Dl8sCPxdOF9Gaeo6GunLZB5gV4W4mkDZYDZ2V+V2KebCopPaQ9rwI4kC3urR7uqs1V01QNZS2uOWrg2CcvVqzIpD9bWLtsjh9Rfs1pgZUg\/1wn3J9EIjVRazfIlDchJK2o39AW3IwNdiPIFsQsFRpyws\/Bp1oSdvcvZpaCJAa7B04Fip4C6HuY6dLfYU0n3bfES0eIGqw52JZEL7JViIdpioLRtp8n5auK0ANpXhlwYuDROex1IKVPN+Xi584QA29VrQ+kj99jZrrJbvs7ImsB\/yPAJ6GnH7l+QtpHFqnP+112MnbrNidZnAaSix9GixU9LQ34GaFj9JGDck7mlowkwWnAbd5nufoAS3NQ2eJU0vyXW2Ys1vQNLR0a6mSKrw1tJZ5vob2Hk2Jd9XhtU3ANNQUHdVmQfgiXfjVkr1YY\/LCMA4rYWAafkScSRKBP4pfHMps2mpE7GoJloYybe3zXE5YcCfa7HWayyLv6MBJGZaGH8s1FwZvccCdZyvp0VoYcIsDKA32IgKFQegs5eG1DjXaC4PwEfQ0YyQNSkNLrcZu0iw2J94aUIn8ap9KugowokVAaaiTaSH5pra84pxD3v5g6aGDvYP5MqvEP7XgdBvth3+STNza7+poHCjzJZ5TnNfWJP2gNjdG6wBJQ4NFatnT7TrcELyoU1XSUWAVzw281bCyQvGy2NM92FIT9G87Sw7nuyUetg9jYRyShhbx2SRrq+QUQcOBAjFzPeU4tVLlTyJSeefggFSu9raKLks42quR04akIVds0OAclP2ySwdaRYrEfzCq55rm0Aa6p78juBwEsF9slY63ojfSkDSE9pN4t3Knp7OkLaQQ\/YSxBFPSFlyweKfyymZDnjvkK+hzIScOSENIdvJOV5maPyytDm6u+9T9YQCVzqAfsRapcllTFDwb6ChAHjoA0pAT1F219aueNrYPBv5pVwH6skP9fwK\/ge5KtREGLe2BGnr6kcM5AWlo7Pef3RSKAkJ3p2qgPCAjypG\/R3tHQHfVhtLdsQcWCN6J3DgA0tDs\/y628ly0sKMG\/5BfmxO5jS5z+bdM7sNowTaH\/atFnh9ETR2ohp4m5AnjgKiW\/xxE\/fOSVj8N7nrU0LN6\/0FHF3IbDUjDIM8vWihGfRGBIqsGDZV+603oVZrgwW8E42hDHT4C0uBaeI+ebhwLggenBg3lCy1TE9aUVOVih9eB3EOAqMHRjbtxZD7819GN\/D0vtg3lmPPkiyHohq6U8uaGw7gLiQKlhbMejsoPvUX\/tHGup1SOvXnoYOGsB1s58uQeIA1zvQ3ecQT1JRYp8fWXHP0Ykxkl7b5MdOMsF8zR0tQzWycZf\/jGd9VpiXApHXTzfXiroA3eyZRa9Gk5P3wBhw6MmARAGriBNr6Ct2mIBGVPr9PhHMRY+4Okgauprx6QndGEj70eq5sFSsPSxdQAAlMDCEwNIDA1gMDUAAJTAwhMDSAwNYDA1AACUwMITA0gMDWAwNQAAlMDCEwNIDA1gMDUAAJTAwhMDSAwNYDA1AACUwMITA3kqKrPq\/XG4VqbLMWIIWNgNJTm1LV6Dy7hrbWDdG8pIUWJZfGwB97tQnoJIBoq8\/wOh7dZsQ7DYUxl4IZe3j2IcGIECA2ldYGbi3G3mbAk9Cgoa756DxA0lOYHH3rQp25LMiSOhB5x4M5T\/dcQNHSEbLTH2\/vGkrLgi1e81Kr+cwgaLKEHT\/RZtB2nSp0OkfM++G7Vfw5BQ2hpwDuUiCElYlevOC2q\/x6ChnqRQ6K68nW45E4\/ckO\/JKGvpP5TgqChtF\/sHXLxMoQJB9tFToLim9Rv4IKggRM7HsrRjry1mR1+O+v9NPQbq8MqXqQrirByhAUt\/WJHSltb1f8CCA3VYicI2owzhmsVs4BUrYLQUFUrdoqko80gY7jDoodg8t0Ie3tBaOBCDujyvYcT+TwcJpSJn3Jva0f4DRgaikXPNbXVarxNjQ6Dolc+8G6UjwiGhpp20bNtra0kb9TTiWLxc3n5bpSbTWBo4FrF3sR7\/yxyrtCmqkD8SF5bO8pGeyAaOsTvorX1g18BEq+SvJf2ovwKEA0SzVyFtU3vu9E1ItrX9n5AaGdCAdHAFYkft81rOVeHAqVSd6v3FCL1tqFoaOwWP4Ceb8I4GokeLokrXHl3HdLvQNFgL5C4usHaDngQlyN1vbqtH+1cJigauGaReSUfaG0dVcok71fvUb\/U4AOMhupaqRvX3GDnlkLW0BcKA2pPG4wGziV58V0T0F5rs+St0o4CxGPm4Ggo7pbyYEUaCdGis1rSAu9Ea6AhabCLLefO4SJ3PT0xGqQulcFZsoKjQWK+ePbzQjy5nAKl\/ZIWjH1UusitJIvf1wCwSb7SIumLtox9f4P43T7z4F4wqQ+lR2RuqHOgL99C0lAm0zrwTZBGcVXVMtc1OtTfwrIAJA2ioW8LJT0fjoeqerlbpR0Yi4agNIgGgi4WdSgeOktkbmCscNRi3GQPSgN3QK516INybPR+yRGOly71cdyLwNIgf1803lWfxNkvNQs5WxjaczB+E5YG+dvT+a5GAB7KZC1UdKEOoH0A01A6KHdlMwQPNXmyl0qHxSX2HNfSLfet2dysF4Ea5C3g3gECTQOX2yd3d7bNyTZ0qUG2tFZUHEW5M9APcBoqQ25IDSoPLNvp\/QoWepowLwYCp4Ertsq00kKx7zvMrN9aViRvge9rxvxG4Gmw50neJT\/7rl3NjJYfDuXLdacF+vJxF6jgaQi4T1CUoxjXEBNgoFa2p+rdVo99VxlADVyvQ66VrvBOnjHYCdRYLjd29vIT\/h1dEDU0KFRL3g7TAcoNdU1u8K3eIXShX\/e2AEQNSr2lCm\/\/3EV1p+ghS49CCa3ocWu4Mg6kBq5avrfkxVHbSG9BLvhid7EP4+hhDQUUpgb7EdlBnA+bM4\/SSQINeYoVktBvKNLSb4CpQbGHPlcgMGb20amW2MEQQFe7pmAqoBq4Q+1KzUOFNx5I\/xbCnic36TuPzanpLlGwGrhqFRWB8PpNHfq2EMVSkfOB30Pfj9qG9mA1lDYeVVEXCNRij5mUOWSR2MsTxFGtA3uwGjj7AaXRwxzWQp0Gcw2DUlHmQfRZtA7r4WpQWmDxw9mqwzKEXTLUPxhHoebJFcAauP0ycUvBIvIJr0PYc5vUpm1za+8nQNagsPgeiLW9l1xjXdZcrjphWznWDdGBgNbA7S9X012ap4nMeK6z3oWQKN91kECYM2wN8oFZofRYejWuCXU2HChU2STM4sghMckIWwPXWSax71jy4yx3VePni72xVWJrpxQ2Dan5AVyD4KEbzYPXhCUHp0zYcyxSGzulqSaz8QK6Bq5zP7IH70HfbbkDKCo6D+W2iW+Ql8VKol3wAl6DMIqS3lcjq8Jd0Jyjps22H8y1oDVB8ziJbX4xgAauRtW8jii2Jktdb72kjJLGDlc3RimYxV1PrItsBA1cTbvkpkt1OPvbLM11zQerZzlY3FyXl9+G3hIEUF5JbqBiCA3eU+C0eSCPVfsMhh8G0cANAvNgLSAatGYUDVyjxiqELKRPYzSMBq4Sv6EmDV\/eS\/TVjKSBa0Ad4eqGtnVnMQykgStthlAx8U4L+RhaI2nguOp21hKEkchh4q9lNA3cfpe6xWHd4At02W9kMA1y5\/3QkODO02dzheE0cGUu7NkHzRYKtEUjSWM8DVxno3JEqR7Y3PrtjzegBqFAqIqkIwvf06rjWXOG1MBxAwVi17joiAP9jCQUDKqBsxfTrJl6mnL1Pc\/JqBqEQXVHE6U+E28t0jti2bgaOK6mo4JCzcT3UNhYZGQNwmguT+\/RHM9bCK7uSGJsDULV1Cx5mjEJCe7BEipbu4yuwddY6ySCdzfTOpDA+Bo4rqpSjynwngKKpwaFgwZfyCPhRaGmvEM0T34NDw2cN9x1sFtj\/MYC5a5qyqfvho0GL4fy+jWbsDYVUdlfGkhYaRAoaS7U0E5Yawf1mkOVJ9w0CDS0DLZjDCes3a5eZleFh6EGLzU5zQhxqbbytsFiJocDzROmGnw05HS4auX3EfLOfksdWwM+wlnDLPaBlty6osIC\/zajR\/hPS15eYzWlUzcUCX8NhsDUAAJTAwhMDSAwNYDA1AACUwMITA0gMDWAwNQAAlMDCAypYejY8RPHjw3p9fOhnDwlJHj65xTdEjCehjNnz3l8nL+gy++LcHF4LsVLIzqZMJqGkctXPAtcvaZDCqH8MrqY5PD1M3okYSwNN4Y9AVwmnoIIF34NSHPs5jj5NIykYeKWJ4hfJwknIcLtO8Gpjt29RzoR42g4cT44OwTuE01ClJujocmOPXhINhGjaDj9SCQ3PJ7fHhNMQ5wpsXQ9YxeekEzEEBpSnk6JSvB4Ru+SSkOKZ\/8VT9lz5fkQuW6TATSkvHgpkRM0aqVj5yTTHr7xilQq4DVce31BWoLHc4dEGnI8H5ZJ\/dabp2+JpAJbQ8qTs9IfIwANAo8mXhComyBrUCgIPlhWSvNcOqW5SMDVMDQR0mFnoUGyifbnt3ca+01QNdx7P6bi9T3nP2h7fRXcV\/McnrGP01oSgalh+pOqd\/d4zh3T8vKquKzyUTx3buAnAlHDxGe1b05jFP0+ZApFklvvcSffwWl4pdQ38mf0JuZrI\/BQXa00y\/mZ37ESAabh9wtiM0eSnPsf1kujcRXliTxXPt3GSAOUht8nkSR4PFcx3hiZ02r6Sv4i\/niNnAYgDS8+\/qr8jgH89zTy++LwJ+Jjea5cRe02gdHw8BKqBI\/nT8SXxWREfZdhQcTUU6QkgGhI+YJYHXm5jPaq+LyUmN+VY+zuGYQUQGgY+oAhwTP8F3qG4vHiD4zHE0Z06ruvEDRcRK+OvFDorM5zAr1a8olQHTvCXEPKxBjWK3o+ncTPVmSu4xRXr4jH6mb9GGt4e+I3vPfzTP2tMWfRmMFoHnwMn1YjgqmGt6\/xCrvAfRoDN39kVgAV+OO2crllqeHMJexX++0smcxVz0l8D573itPg7DT8\/hX\/vf7RPyAjhJNf8J\/3\/GOFThMrDddOP8J\/q6sjRDNYJW+V1wKluSs\/wcFIw88aPi3PJ\/Q5GzK8u6L8cFKMPZYL42Cj4W\/splkAcy6ZBN8QJuFDeCkz6GeiAXeo4GVMqXEeejYy81LgwtdplWFED0\/MzGbvrZmvp+Qr8We\/aPBwVXqpkIWGsxosyLyKN0OPXTznV3HcuqBi1unJZEBVM\/rPm2\/j0l39V181PLz08gh9Ddfe4L+HMF74cnb6XkitlDJ0ZvrEh\/uhQ6zh50oWHot2FYY\/nj3+7MwLfx2\/jz87fXYGa3ZpgXMnwGi4qOlF5vn85eU8kzdl\/t3oS3kLStFghHl0HIiG5xp6GzgMX5SzMD1F92k8jyZAaPgLd24GG9kFmLu0n8bzp+jCHGUNE\/9Qf+\/RS9IWUJeZSXDpDHMNp7S1cHjIxA38Qr1sCohtFKOrYZLBW3vuSEesPGDxPKMiAZ9UNXxg8fF5ht\/B0uC5Ezp8oKnhf2pCtMkDToMntLWiqUHLRIAG4Gk4\/4ahhjeY67lakeiqM9TgefAzMw0n1QbLk0amiWbRcfMyGtxboqfhPaPCINdhva4+aJ4swZFu1DScRI4EJcUf0hqeTjF6ptGPjDTMsCoMsvHG9Ccz5giaYqGmgVlhkI03xogSJsOvgQF9tDSwmL3x8Vk+fGCSyYjSE9xi0dLAqk+iuFVUbrFCTwK70ZQ0XFO9n5Iso18ULHAnWXkIKA6UNExoiErSQOhwVQTs8FRt3PcPWKCkAW0bHyHGLqkLaBqZYvF0j\/wn+ChpYFMn3X2mxsIzNr3WgAPq6Gi4zahfqKZS+oob2q8V\/631dDRQjn9YRLmJfsfq0Tyf\/RoHOho+seqdKwbITDPqwgmc89soQ0fDFLN3VQiQ4VhN+3oCt1DS0YBy7ARpHshtejpLP1JkgV\/9CiodDWxWP+feVm47JrOZLi9+B9RR0fBMSzy6Zh5IWzjF8vvwfF5SGmRW35gt+\/hYWhpkQgJYTTjOQlvDX8z65l7gRWbMYWowNVDH1ABdw9JqG9g20Z9PSWpgEtG9+GBLSsNl6RuAmM2u+lhaGmSGb0\/YTex56I+imU5m\/PZVWgO7OCUv1DWwnNqDGafkCQwaoaNhit3L\/iN\/qgCruAwPi4nuSbzT9EjwSdYC9zO7ocM5v5VyOhqYLYJ67iqd7CV+SgAN6C+CsgoJ8Hx6oWBhSYUEsGocLqk5nfI0ow7EFH0NTPrnt+SXoRd4cWGMwdMFnKpCScMXFm206hP5rrOY0\/jsvxpFScMpJo3Dn6qi9rjHTOICAm73paSBTRCr6LkIIZz8yOLRAi9ioaWBzVzmZTU3MP3FZDtY4EljtDQw2u2jELPng8lBHox2+zCKCPpF2cI9JoF7jPa+MdoJ+mfwdvxQ2JzkwWonKJt90So0TLBYDGG2L5rNKQFQNQTvT6WngcmZGVA1BN\/EQk8DkxNkgGpgeIIMx+Ff14ANzJ5S6B4kmhrof3ejM8oaNNxTgsvNkIlfmhron7UHcxR9LvScLaoaaM\/eiJ3xGMoLypUl85MnaW8E\/6juTjLKp8OKTbDQ1UB3TnlS3Z1rHDdNc2j5SWz2nbIG7iK1k9KvqDkvg\/5jXRY9WIi2Blon1g+\/uYdggeOeUAoeAXJiPff2g\/7v+sfzaenwYSne3js+qXuwDJj7GzTeZqLMfdQrs\/14NaHvswG6zYR79XxM13e9I72fQYlvuj4YqLt9OG03XangunKMmDh\/6xs5JnMGJhMN3Ii+Sy038Cy80nA9pgrA3fvGcbd1HblexLug75iuUTzP5R6KkQZu6KyOb3wT77bKGzo+0j\/y11uz0sBxr\/ULqHyA10g\/1u2BPDPj8kmz06BjgYCm4dwppckthhq4lHs6XayBqUGvQYPSZdGMNXDcyWd39FiCANU2zLxIUU6arQaB11PkJ5neoU9leHlGvvt2ZXJchQQAGoTO64Mxsu8+9g3LAvlxw9gFtQNJABo47ukHouuQsj10OV4TXXc4r3Z7BQdEg9BaT3wmVjd9QZvi9mdkjNRDjImu7kgCRIPAPUJ7Ad88REo2EDI35o7dR51OgaNB4MxjzSE0N6fVrT9LMTShtX48f\/MG+tQiKA0CL0YmNRxD+Oap2uVnaa79rSFC4NzFaawngKZBIGX82wx6qRgd\/nAKr58a+gBDI5MYLdX9d9PK4zQJAGrw8er2ifeq9yuPXb5+DLd3JMHbh6cvPFLr4vzd5yNnNH0DUDX4ODn09PiNl3IxZsNfZk4fe6I1HSlevTg9MXNJppL8\/HFm4tTPr1SN0GQBrWGBV+PjD7+d8Of432fGnxCqhBQZejj+dOS4f\/LfXo+Pqxsfq8MYGsIeUwMITA0gMDWAwNQAAlMDCEwNIDA1gMDUAAJTAwhMDSAwNYBARw1bU39g\/XYGYXemjhqWLUv6TnASMmzZnRCpq4Vly3ZuT2P9ktBJ+a5vUZhlZarZQsiRtn0nBQsCWXvMmkkK\/eujRaKzdrB+XZik7N1HTYKXjTHfWb8yPFLWpEdTteAVkWmWiABSUvdRl+AjI8FsI+ZJSaBbHfkTvdLsvvpI2xLFpiTMsyLZrJt2bKPXO5IkIuPfpTzFsTshayNrBXNsit3LOjcY8T05km1tFEhE9q51rLOEOru3Z0ApCItERMUtqfY6IQmeg1ki0uPWss4dOvybuQlSZRRC9L64sJ9x2pJEafJOG5HJYTsJm7JuV4YhHMyyKSsMq6e0hORs1hmLTmTM6vBR8cOOXfsMVAwCiciOiQ+D7tP3xPQVrLNSKxuzM7cYd0yxe82uJMMrmCc6MmnXHtY5iszm1clGao9VsjEqc4tRXKStScxaAXpkoI2IjJg42BNQa1O3pUdGsM4nGkRvzdqweg+4edmUNXGxy8OvFlJg48qkmC17QXSk0tbvisnYyjpDmLJieWbilj2Mht3fV2+PSdq6JKogdWzKTo9JXL+GUuHYGx+XnJSxNJoALCIil6fHJq+PT9Ah878nJGyLTcpYevW\/JnZGRWWsil21fXX8v5sxMz4tNT7+31WxG7KiosK5\/0mTndlRUVErs5JjZ9mVEB9IwrYNs\/8nOWul918aaPD7f9YL1o5Jq6sYAAAAAElFTkSuQmCC\" alt=\"Like\" loading=\"lazy\" class=\"w-auto max-w-6 h-5\"><span>2<\/span><\/span><\/span><\/span>\n                    <\/div>\n    <\/a>        <\/div>\n    <\/article>\n<\/div>\n\n\n            <\/div>\n<\/section>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-do-i-need-to-follow-this-walkthrough\">What do I need to follow this walkthrough?<\/h2>\n\n\n\n<p>You must have:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>git<br><br><\/li>\n\n\n\n<li>a local copy of this repository<br><br><\/li>\n\n\n\n<li>an app that runs Docker containers<br><br><\/li>\n\n\n\n<li>a general understanding of data and data platforms<\/li>\n<\/ul>\n<\/div>\n\n\n<p>Let&#8217;s talk about these requirements in a little more detail. First, download a copy of this repository to your machine (or in git terms, clone the repository). These walkthroughs assume you have the code locally. The command is:<br><code>git clone https:\/\/github.com\/ScaryDBA\/GettingStartedWithPostgreSQL.git<\/code><\/p>\n\n\n\n<p>Second: you must be running an operating system capable of running <a href=\"https:\/\/www.red-gate.com\/simple-talk\/devops\/containers-and-virtualization\/a-quick-guide-on-how-to-containerize-your-application-using-docker\/\" target=\"_blank\" rel=\"noreferrer noopener\">Docker containers<\/a>. <a href=\"https:\/\/www.redhat.com\/en\" target=\"_blank\" rel=\"noreferrer noopener\">Red Hat<\/a> and <a href=\"https:\/\/fedoraproject.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">Fedora<\/a> have <a href=\"https:\/\/podman.io\/\" target=\"_blank\" rel=\"noreferrer noopener\">Podman<\/a> built in, so there&#8217;s nothing you need to do there. <a href=\"https:\/\/www.debian.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">Debian<\/a>, <a href=\"https:\/\/ubuntu.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Ubuntu<\/a> or <a href=\"https:\/\/www.raspberrypi.com\/software\/operating-systems\/\" target=\"_blank\" rel=\"noreferrer noopener\">Raspberry Pi OS<\/a>, however, <em>will<\/em> require installation of an engine such as the aforementioned Podman or <a href=\"https:\/\/docs.docker.com\/engine\/\" target=\"_blank\" rel=\"noreferrer noopener\">Docker Engine<\/a>. <\/p>\n\n\n\n<p>For Windows, you&#8217;ll need to make <a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/virtualization\/\" target=\"_blank\" rel=\"noreferrer noopener\">virtualization<\/a> possible on your system by first <a href=\"https:\/\/learn.microsoft.com\/en-us\/windows\/wsl\/install\" target=\"_blank\" rel=\"noreferrer noopener\">installing Windows Subsystem for Linux (WSL)<\/a>. Your Windows machine may also require a <a href=\"https:\/\/support.hp.com\/us-en\/document\/ish_3894564-1633733-16\" target=\"_blank\" rel=\"noreferrer noopener\">BIOS<\/a> update to run virtualization.<\/p>\n\n\n\n<p>After that, you can install <a href=\"https:\/\/podman-desktop.io\/\" target=\"_blank\" rel=\"noreferrer noopener\">Podman Desktop<\/a>, <a href=\"https:\/\/rancherdesktop.io\/\" target=\"_blank\" rel=\"noreferrer noopener\">Rancher Desktop<\/a> or <a href=\"https:\/\/www.docker.com\/products\/docker-desktop\/\" target=\"_blank\" rel=\"noreferrer noopener\">Docker Desktop<\/a>. For Mac, you can choose between Podman or Podman Desktop, <a href=\"https:\/\/colima.run\/\" target=\"_blank\" rel=\"noreferrer noopener\">Colima<\/a>, Docker Desktop for Mac, or Rancher Desktop.<\/p>\n\n\n\n<p>You&#8217;ll need to know how (and be able to) run a Docker container to follow these walkthroughs. Additionally, during the initial &#8220;pull&#8221; stage of the walkthrough, you&#8217;ll need internet connectivity to retrieve the PostgreSQL images from the Docker Hub.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-docker-commands-how-to-check-that-you-can-run-them\">Docker commands: how to check that you can run them<\/h3>\n\n\n\n<p>You can validate that you can run Docker commands by running the following:&nbsp;<code>docker info<\/code><\/p>\n\n\n\n<p>If you&#8217;re running Podman, just substitute&nbsp;<code>podman<\/code>&nbsp;for&nbsp;<code>docker<\/code> and run all the other commands the same way. For Rancher Desktop or Colima, you can either run&nbsp;<code>docker<\/code>&nbsp;<em>or<\/em> &nbsp;<code>nerdctl<\/code>&nbsp;commands. I&#8217;ll only be providing&nbsp;<code>docker<\/code>&nbsp;commands throughout this walkthrough, however, so you&#8217;d have to change them for your own syntax.<\/p>\n\n\n\n<p>Once that&#8217;s running successfully, you can validate internet connectivity by running the following:&nbsp;<code>docker run hello-world<\/code><\/p>\n\n\n\n<p>That should pull an image and then create a container that shows &#8220;Hello from Docker!&#8221; along with some other text, suggestions and alternate commands.<\/p>\n\n\n\n<p>One other requirement worth mentioning is a general, functional knowledge of the operating system you&#8217;re using. It&#8217;s also going to be assumed that you have some knowledge of what a data platform is, databases, and general data management. The purpose of these walkthroughs is to introduce you to a new data platform (PostgreSQL), not teach the fundamentals of databases and data management.<\/p>\n\n\n\n<p><strong>You&#8217;re still (nearly) in the right place, however, as <a href=\"https:\/\/www.red-gate.com\/simple-talk\/articles\/\" target=\"_blank\" rel=\"noreferrer noopener\">Simple Talk has an extensive series of guides and tutorials<\/a> for databases, data management, and much more. You can learn everything you need to know on this site.<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-one-final-point-on-commands\">One final point on commands<\/h3>\n\n\n\n<p>The majority of commands will be run from the command line on whatever operating system and hardware you choose to use. I recommend using <a href=\"https:\/\/code.visualstudio.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Visual Studio Code (VSCode)<\/a> as it has a <a href=\"https:\/\/code.visualstudio.com\/docs\/sourcecontrol\/overview\" target=\"_blank\" rel=\"noreferrer noopener\">very tight integration with source control<\/a>, making it easier to get the project locally. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is Grant Fritchey&#8217;s complete set of hands-on labs for getting started with PostgreSQL &#8211; designed for any IT professional or hobbyist who wants to add PostgreSQL to their existing skillset. &hellip;<\/p>\n","protected":false},"author":221792,"featured_media":113061,"template":"","tags":[4168,4170,159410,158978],"coauthors":[6785],"class_list":["post-112213","collection","type-collection","status-publish","has-post-thumbnail","hentry","tag-database","tag-database-administration","tag-gettingstartedpostgresgrant","tag-postgresql"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/collection\/112213","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/collection"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/collection"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/221792"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/113061"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=112213"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=112213"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=112213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}