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 »Engin Yilmaz
UPGRADE POSTGRESQL 10 To 11
We will upgrade POSTGRESQL 10 To 11 on CENTOS in this article. Before I start the upgrade process, I want to make the following critical …
Read More »COLUMN ENCRYPTION WITH POSTGRESQL TRIGGER
In Postgresql, we can capture the record with the trigger, encrypt and write to the table. Let’s create the table, [crayon-673f9dd045c02709540445/] Then we …
Read More »Column Level Encryption With pgcrypto On PostgreSQL
Create Extension First, if the extension is not present, it is created with the following command. [crayon-673f9dd045de3822904098/] The functions we will use; [crayon-673f9dd045de7961294370/] Example: We …
Read More »POSTGRESQL DATABASE MONITORING
In this article I will share some monitoring scripts about postgresql. To Check if the Postgresql service is running via OS(linux): [crayon-673f9dd045fef931045776/] …
Read More »POSTGRESQL DATABASE PERFORMANCE – 2
This article is the second article of the performance series. You can find the first articles link “POSTGRESQL DATABASE PERFORMANCE – 1” In the …
Read More »POSTGRESQL DATABASE PERFORMANCE – 1
If we examine some performance parameters in postgresql, I will mention a few parameters that will be quite useful for performance. You can configure …
Read More »