Installing PostgreSQL

PostgreSQL can be installed on almost all modern operating systems. It can be installed on all recent Linux distributions, Windows 2000 SP4 and later, FreeBSD, OpenBSD, macOS, AIX, and Solaris. Also, PostgreSQL can work on various CPU architectures, including x86, x86_64, and IA64. You can check whether a platform (operating system and CPU architecture combination) is supported by exploring the PostgreSQL build farm at http://buildfarm.postgresql.org/. You can compile and install

In order to automate PostgreSQL installation and to reduce server administrative tasks, it's recommended you use PostgreSQL binaries, which come with the operating system packaging system. This approach normally has one drawback: binaries that aren't up to date. However, PostgreSQL's official website maintains the binaries for the most common platforms, including BSD, Linux, macOS, Solaris, and Windows.

The instructions, as well as the binaries, to install PostgreSQL can be found on the official web page (https://www.postgresql.org/download/). The following screenshot shows the instruction to add the apt repository to the Ubuntu Bionic release.

Note that the installation instructions are generated based on the release name. The installation page URL for Ubuntu is https://www.postgresql.org/download/linux/ubuntu/: