Cherry's blog

PostgreSQL records all activity and errors of cluster database into logs . From these logs, we can get useful information for troubleshootin...

There are several key parameters that should be adjusted for optimal performance, security, and stability. The default settings are usually ...

1. General information Master Node IP: 192.168.56.111 Hostname: postgres-master Version: postgres (PostgreSQL) 16.4 $PGDATA=/var/lib/pgsql/1...

1. pg_dump pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurr...

1. Overview  The pglogical 2 extension provides logical streaming replication for PostgreSQL, using a publish/subscribe model. Using pglogic...