How to install PostGIS in RHEL

In this article, we will see How to install PostGIS in RHEL. Continue reading How to install PostGIS in RHEL

How to install or create pg_stat_statements extension in PostgreSQL

In this article, we will see how to install or create pg_stat_statements extension in PostgreSQL.

What is pg_stat_activity?
The pg_stat_statements module provides a means for tracking planning and execution statistics of all SQL statements executed by a server.

Install or create pg_stat_statements extension in PostgreSQL::

Continue reading How to install or create pg_stat_statements extension in PostgreSQL

PostgreSQL ERROR: could not open extension control file

In this article, we will see the cause and solution for “PostgreSQL ERROR: could not open extension control file”.

PostgreSQL ERROR could not open extension control file

Continue reading PostgreSQL ERROR: could not open extension control file

How to install PostGIS in Ubuntu

In this article, we will see How to install PostGIS in Ubuntu.

What is Postgis?

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. postgis is just extension to existing database. That also we have to add as shown below.

Prerequisites to install postgis extension on Linux:
Continue reading How to install PostGIS in Ubuntu