Category: PostgreSQL

How To Create Partition on JSONB column in PostgreSQL

I will share an example that creates partition on JSONB column in PostgreSQL in this article. But first we need

In this article we will look at the answers for the questions; What is partition in PostgreSQL What are the

I will tell about changes in replication and replication installation in PostgreSQL 12 in this article. This article assumes that

You may want to read the following articles about replication before reading this article. “How To Install PostgreSQL Replication By

First of all, we must install PostgreSQL on Primary Server and perform initdb operations. You can find out how to

What is pgBackRest pgBackRest is a backup/restore tool in postgresql. PostgreSQL Backup Types In Postgresql, we create backups in two

Suppose that we created a table in the database by following the normalization rules for our application. However, we realized

You may receive this error when there are multiple IPs on the same server that use the same port. In

You may want to transfer data to MSSQL from PostgreSQL or send query to PostgreSQL from MSSQL. There are different

Check_postgres is a tool you can use to monitor PostgreSQL. You can download from the link below. https://github.com/bucardo/check_postgres If you