PostgreSQL TutorialLesson 3Free preview

PostgreSQL Install

This lesson is part of PostgreSQL · All levels

Summary

PostgreSQL can be installed via official installers on Windows, system packages on Linux, or brew on macOS. During the installation process you will be asked to specify the port, the data directory, and the superuser password. Once you're done, make sure the PostgreSQL service runs before you try the first connection.

Key points

Download the official installer from postgresql.org for Windows or use the system package on Linux.
The default port of the PostgreSQL server is 5432 and the built-in superuser is called postgres.
Keep superuser passwords well because they're needed for administrative connections.
Make sure the service is running, for example through systemctl or Services on Windows.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.