Install PostgreSQL 14 on Rocky Linux 8|AlmaLinux 8|CentOS 8
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.…
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…
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…
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…
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 largest databases and workloads by utilizing algorithms optimized for database-specific requirements. Some…
By default, the page size on Linux is 4kb. A typical PostgreSQL instance may allocate many GBs of memory, which will end up with potential performance problems with such a small…
[root@server1 ~]# su postgres [postgres@server1 root]$ psql -f all.sql bash: psql: command not found Chạy câu lệnh sau export PATH=/opt/PostgreSQL/9.5/bin:$PATH
Below are the steps for enabling archive mode or wal archiving in postgres. STEPS TO ENABLE ARCHIVE MODE IN POSTGRES: 1. Check archive setting in the postgres config file: postgres=#select…