Essentially the most “blessed” possibility, the one linked to in PostgreSQL’s personal documentation, is the EnterpriseDB installer. It consists of PostgreSQL’s graphical set up wizard, a simple step-by-step instrument for organising the database and its supporting instruments. It additionally consists of “Stack Builder,” a instrument for downloading and putting in a plethora of extra instruments. These embody database drivers, different editions of PostgreSQL (within the occasion that you must run them facet by facet), EnterpriseDB’s personal PostgreSQL add-ons, and the Slony-I replication system for PostgreSQL. For specialists, EnterpriseDB additionally provides 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 advanced one, for working 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 need to confine your PostgreSQL work to a non-system or detachable drive. A 3rd-party venture, 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.
Putting in PostgreSQL on Linux
Linux distributions fluctuate vastly when it comes to how software program is put in and maintained, with completely different package deal managers, package deal codecs, and software-repository philosophies. PostgreSQL isn’t exempt from these variations, which generally is a barrier to acquiring the newest model of the software program in your platform.
