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 …

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 …

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 …

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 …

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 …

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-5f990e2a7252d955071093/] Then go to …