In this article, we will install PostgreSQL 12 On Centos 8. We choose the versions we will install by going to the link below. https://www.postgresql.org/download/linux/redhat/ …
Read More »PostgreSQL
REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL
We will perform REPMGR installation and configuration for postgresql in this article. You can see our environments. pg is our primary postgresql cluster and the …
Read More »What is pg_repack in PostgreSQL
Today, I will introduce you a nice extension that we can use instead of VACUUM FULL in PostgreSQL. I recommend using it in your prod …
Read More »Revoke Permission in PostgreSQL
This article contains information about revoke command usage in PostgreSQL. You may want to revoke permissions of users. In this case, you can use the …
Read More »Streaming Backup with PostgreSQL Barman
What is Barman? Barman is an open source backup / restore management tool in PostgreSQL. What can you do with Barman? You can create backups …
Read More »Upgrade PostgreSQL 11 to 12
In this article, we will upgrade PostgreSQL 11 to 12. If you want to upgrade PostgreSQL 10 to 11 you should read the article “Upgrade …
Read More »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 to know What JSON and …
Read More »Table Partitioning in PostgreSQL 11.2
This article contains information about table partitioning in PostgreSQL. We will look at the answers for the questions; What is partition in PostgreSQL What are …
Read More »How To Install Streaming Replication in PostgreSQL 12
I will tell about changes in replication and replication installation in PostgreSQL 12 in this article. This article assumes that you are familiar with PostgreSQL …
Read More »How To Failover and Failback PostgreSQL Replication
You may want to read the following articles about replication before reading this article. “How To Install PostgreSQL Replication By using archive_command On Centos“, “How …
Read More »