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, IA64, and others. One can check whether a platform (operating system and CPU architecture combination) is supported by exploring the PostgreSQL Build farm (http://buildfarm.PostgreSQL.org/). One can compile and install PostgreSQL from the source code or download its binary and install it.

In order to automate PostgreSQL installation and to reduce server administrative tasks, it is recommended to use PostgreSQL binaries, which come with the operating system packaging system. This approach normally has one drawback: not up-to-date binaries. However, the PostgreSQL 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 image shows the instruction to add APT repository to Ubuntu Zesty release. Note that, the installation instructions are generated based on the release name.