Three Ways to Install Postgres

There are three ways to install Postgres, and they are all listed on the Download menu on the
Postgres website. While the web authors did their best to explain the differences between the various installation methods, I thought it
would be helpful to more fully explain their advantaged and disadvantages. The three methods are:

  • Graphical Installers (also called "one-click" or "click-through" installers)
    • Advantages: Provide an easy-to-install Postgres environment with access to many add-on modules via
      Stack Builder. This is ideal for first-time Postgres users. It is also possible
      to use the installer in non-interactive mode.
    • Disadvantages: As mentioned on the Postgres web site, the one click installers do not integrate with platform-specific
      packaging systems.
  • Platform-Specific Packages
    • Advantages: These are better integrated with other software installed on your operating system. This is ideal for
      production servers that rely on operating-system-supplied tools.
    • Disadvantages: Requires work to identify which other packages are needed for a complete solution. Obtaining newer major versions
      of Postgres on older operating systems might also require work.
  • Source Code:
    • Advantages: Allows selection of specific configure and compile options for Postgres binaries, and allows the addition of patches
      to enhance or fix Postgres. This is ideal for experienced users who can benefit from additional control of Postgres.
    • Disadvantages: Requires compilation experience and managing Postgres tool integration, and requires user and server start/stop