Essentially the most “blessed” choice, the one linked to in PostgreSQL’s personal documentation, is the EnterpriseDB installer. It contains PostgreSQL’s graphical set up wizard, a simple step-by-step instrument for organising the database and its supporting instruments. It additionally contains “Stack Builder,” a instrument for downloading and putting in a plethora of extra instruments. These embrace database drivers, different editions of PostgreSQL (within the occasion it’s essential run them aspect by aspect), EnterpriseDB’s personal PostgreSQL add-ons, and the Slony-I replication system for PostgreSQL. For specialists, EnterpriseDB additionally affords a easy .zip archive of nothing greater than PostgreSQL’s binaries for Home windows.

If you wish to run PostgreSQL on Home windows with out putting in it or leaving any information behind, there’s a recipe, albeit a barely complicated one, for operating PostgreSQL from its .zipped archive distribution. That is extremely helpful for testing on a desktop the place software program installations are restricted, or the place you wish to confine your PostgreSQL work to a non-system or detachable drive. A 3rd-party challenge, PostgreSQL Moveable, packages a standalone model of PostgreSQL for for the PortableApps software launcher. Sadly, it has not been up to date for any newer model of PostgreSQL since model 10.

Linux distributions differ significantly when it comes to how software program is put in and maintained, with completely different bundle managers, bundle codecs, and software-repository philosophies. PostgreSQL isn’t exempt from these variations, which could be a barrier to acquiring the newest model of the software program in your platform.