Resolving Remaining connection slots are reserved for non-replication superuser connections in PostgreSQL
Posted in PostgreSQL

Resolving: Remaining connection slots are reserved for non-replication superuser connections in PostgreSQL

The error: remaining connection slots are reserved for non-replication superuser connections, can be resolved in many ways. In this post,…

Continue Reading...
PostgreSQL 12 Streaming replication on Ubuntu easy step-by-step guide
Posted in PostgreSQL

PostgreSQL 12 Streaming replication on Ubuntu easy step-by-step guide

PostgreSQL 12 Streaming Replication In this PostgreSQL tutorial, we will be looking at the step-by-step guide on how to set…

Continue Reading...
install postgresql on ubuntu
Posted in PostgreSQL

Step by step guide on how To Install PostgreSQL 12 on Ubuntu 16.04/18.04/20.04 (2020)

Introduction This tutorial will give you a step by step guide on how to install PostgreSQL 12 on Ubuntu 16.04/18.04/20.04….

Continue Reading...
Understanding the pg_hba conf file in PostgreSQL
Posted in PostgreSQL

Understanding the pg_hba conf file in PostgreSQL

Understanding the pg_hba conf file in PostgreSQL The pg_hba.conf file which stands for PostgreSQL Host-based Authentication configuration file, controls client/ipĀ …

Continue Reading...
PostgreSQL backup tutorial & database backup types explained
Posted in PostgreSQL

PostgreSQL backup tutorial & database backup types explained

PostgreSQL backup tutorial & database backup types explained As in any production environment, backing up said environment is equally an…

Continue Reading...
3 easy ways to create users in Postgresql database
Posted in PostgreSQL

3 easy ways to create users in Postgresql

Like many other databases, create a user in PostgreSQL is pretty easy. In this short tutorial, we will be looking…

Continue Reading...
20 PostgreSQL basic administrative commands you need to know
Posted in PostgreSQL

20 PostgreSQL basic administrative commands you need to know

In this tutorial we will be looking at a list of 20 PostgreSQL basic administrative commands you need to know,…

Continue Reading...