In order to find long running queries in PostgreSQL, we can set the log_min_duration_statement parameter in the postgresql.conf file to a certain threshold value and ensure that the queries that …
Read More »
In order to find long running queries in PostgreSQL, we can set the log_min_duration_statement parameter in the postgresql.conf file to a certain threshold value and ensure that the queries that …
Read More »MongoDB is an open source and document-based NoSQL database designed to efficiently process large amounts of data. Stores data as Binary JSON documents (BSON). MongoDB provides ACID support in 4.0 …
Read More »What is Barman? Barman is an open source backup / restore management tool in PostgreSQL. What can you do with Barman? You can create backups on the same server. You …
Read More »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 and linux. If you are …
Read More »What is pgBackRest pgBackRest is a backup/restore tool in postgresql. PostgreSQL Backup Types In Postgresql, we create backups in two ways: logical and physical. Logical Backup (pg_dump, pg_dumpall) Physical Backup …
Read More »Download Postgres Repository Metadata First, Run the below command on a server that can connect to internet. This command download the latest postgres repository metadata information. [crayon-600c0faad80c4024142627/] Then go to …
Read More »