PgAdmin is an open-source and widely used frontend management tool for the PostgreSQL database system developed in Python language. It allows one to manage the PostgreSQL database from the web interface by providing…
Install PostgreSQL 14 on Rocky Linux 8|AlmaLinux 8|CentOS 8 The steps below will guide you on how to install PostgreSQL 14 on PostgreSQL 14 on Rocky Linux 8|AlmaLinux 8|CentOS 8.…
1. Giới thiệu Mục đích của bài viết này là cung cấp cho bạn hình dung về công việc quản trị PostgreSQL Database (Database Administrator – DBA) và giúp định hướng việc…
In this blog, we will see How to perform a restore of a backup taken from pgBackRest. We will complete steps for the below two scenarios: 1. Restore in the same directory…
In this blog, we will demonstrate How to Setup Streaming Replication with pgBackRest in PostgreSQL. Below are the high-level steps we will follow to set up our replication.1. Setup a shared…
Network File Sharing (NFS) is a protocol that allows you to share directories and files with other Linux clients over a network. Shared directories are typically created on a file server, running…
We will use the same PostgreSQL cluster to show How we can take a backup from Standby Cluster using pgBackRest. Below are the high-level steps which we will follow to setup…
In this blog, we will use the pgbackrest tool to take different types of database backup. pgBackRest is an open-source backup tool for PostgreSQL which offers easy configuration and reliable backups. pgBackRest is a reliable, easy-to-use backup and restore solution that can seamlessly scale up to the…