PostgreSQL

  As you know, at the end of September 2016, PostgreSQL version 9.6 was released. In this article you will find the installation steps of …

Create Extension First, if the extension is not present, it is created with the following command. [crayon-67d38d40b7297869141587/] The functions we will use; [crayon-67d38d40b729e144986818/] Example: We …

  In this article I will share some monitoring scripts about postgresql.   To Check if the Postgresql service is running via OS(linux): [crayon-67d38d40b7bce729027863/]   …

  We may need to keep passwords in databases for some reason, and we don’t want anyone to see them, including dba. In postgresql there …

  This article is the second article of the performance series. You can find the first articles link “POSTGRESQL DATABASE PERFORMANCE – 1” In the …

  If we examine some performance parameters in postgresql, I will mention a few parameters that will be quite useful for performance. You can configure …

  Logical replication was introduced in PostgreSQL 10 and it is different from streaming replication in many ways as described below:  Logical replication works at …

  Replication: Replication is a way of copying and distributing data and database objects from master to slave servers. These databases are synchronized to maintain …

  Introduction : –  pg_rewind is a tool for synchronizing a PostgreSQL cluster with another copy of the same cluster, after the clusters’ timelines have diverged. …

  It is a good idea to save the database server’s log output somewhere, rather than just routing it to /dev/null. The log output is invaluable when …