Personally, I believe installing the Postgres database using the command-line package manager Homebrew is much easier and clean as it automatically manages the external dependencies that we need to have in order to install Postgres on our machine. You can either install it using the command line package manager Homebrew or you can also visit the official website and get the latest downloaded-able file and start your installation. There are various ways in which you can install Postgres on your machine. Now that we have some idea about what a Postgres Database is all about, let us now go ahead and try to install it on our local machine. PostGIS is a community-driven plugin developed especially for the Postgres Database to work with location analytics Geospatial Analyses – Postgres is also largely used in the analysis of Geospatial data due to its support for the PostGIS plugin.Analytical Databases / OLAP – Postgres is also widely used to support analytical workloads in enterprises.Transactional Database systems / OLTP databases – It is also used as a general-purpose database system that supports real-time high throughput transactional workloads.LAPP stack – This is one of the most common web development technologies with a combination of Linux, Apache, Postgres, PHP/ Perl.A few of the most common tech stacks where Postgres is mostly used are as follows. A lot of enterprise-scale applications, whether web or mobile, use Postgres Database as a backend relational database management system. Postgres has been a stable and reliable database product and has been continuously under development for the past two decades. In order to use those services, it is recommended that you should also have them installed on your local machine before deploying your databases to the cloud directly.Īs per the definition from the official website – “ PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads“. Postgres is also available on all the major public cloud services like AWS, Azure, and GCP. Postgres has been popular for analytical workloads as well since it has support for column-store index and in-memory storage as well. Postgres is an open-source relational database system that can be used to develop a wide variety of data-based applications. In this article, I am going to discuss different ways in which you can install and setup Postgres Database on a Mac.

Pgadmin for mac