This section helps you get started with PostgreSQL by showing you how to install PostgreSQL on Windows, Linux, and macOS. You also learn how to connect to PostgreSQL using the psql tool as well as how to load a sample database into the PostgreSQL for practicing.
Getting Started
- What is PostgreSQL – introduce you to PostgreSQL and its applications in today’s software stack.
- Introduction to PostgreSQL sample database – to learn the PostgreSQL fast, you need to have a good sample database to practice with. This tutorial introduces you to a PostgreSQL sample database called
dvdrental.
PostgreSQL on Windows
If you’re using windows, you can follow these tutorials to install PostgreSQL, connect to it, and load the sample database into the PostgreSQL database server:
- Install PostgreSQL on Windows – walk you through the steps of how to install PostgreSQL on Windows.
- Connect to PostgreSQL database server – show you how to connect to the PostgreSQL using psql tool and pgAdmin 4 GUI tool.
- Load the sample database into the PostgreSQL database server – guide you on how to load the sample database into the PostgreSQL database server for practicing.
PostgreSQL on Linux
- Install PostgreSQL on Ubuntu – you will learn how to install PostgreSQL on Ubuntu, connect to the PostgreSQL database server using the
psqltool, and load the sample database into the PostgreSQL.
PostgreSQL on macOS
- Install PostgreSQL on macOS – learn how to download PostgreSQL installer for macOS, how to install PostgreSQL on macOS, and how to restore the sample database into the PostgreSQL database server.
