Before you install Homebrew on Mac, you’ll need to make sure you have the following: A 64-bit Intel CPU or an Apple Silicon CPU (i.e., an M1 Mac) You can check if you have a compatible Mac by pressing cmd + spacebar, typing “About This Mac”, pressing return, and then checking the Processor. Install from Microsoft Store; Chocolatey (choco install dbeaver) Mac OS X. Mac OS X x86 (dmg) Brew Cask (brew install -cask dbeaver-community) MacPorts (sudo port install dbeaver-community) Linux. Linux Debian package 64 bit (installer) Linux RPM package 64 bit (installer) Linux 64 bit (zip) Linux x86 64 bit (zip without Java included).
These instructions are for PostgreSQL 9.1 and higher, PostGIS 2.2 and higher that is compiled with raster support.Note: if you have postgis, without raster support, you can not use CREATE EXTENSION. Refer to PostGIS install.
PostGIS is an optional extension that must be enabled in each database you want to use it in before you can use it. Installing the software is just the first step.DO NOT INSTALL it in the database called
Connect to your database with
psql or PgAdmin. Run the following SQL.You need only install the features you want:
To upgrade PostGIS, you first have to install the latest binaries and then upgrade each database you have PostGIS installed in
For example connect to database you want to upgrade and if you just installed binaries for 2.1.3You can upgrade from 2.0 to 2.1, 2.2 et.c using this approach. To go from 1.* to 2.* you need to do a hard upgrade.Refer to PostGIS install for more extensive instructions.Note: that as of PostGIS 2.1.3 and PostGIS 2.0.6, you need to set environment variables to get full features.
or to a specific version
See the documentation for more guidance.