PG Administration

PGDG cuts off FTP rsync sync channels, global mirror sites universally disconnected - this time they really strangled global users’ supply chain.

Backups are a DBA’s lifeline — but what if your PostgreSQL database has already exploded and you have no backups? Maybe pg_filedump can help you!

What? Don’t know what COLLATION is? Remember one thing: using C COLLATE is always the right choice!

This article introduces the principles and best practices of logical replication in PostgreSQL 13.

How to change column types online, such as upgrading from INT to BIGINT?

Understanding the golden monitoring metrics in PostgreSQL

Concepts and their naming are very important. Naming style reflects an engineer’s understanding of system architecture. Poorly defined concepts lead to communication confusion, while carelessly set names create unexpected additional burden. Therefore, they need careful design.

Today encountered an interesting case where a customer reported database connection issues caused by extensions.

There are various backup strategies. Physical backups can usually be divided into four types.

PostgreSQL uses MVCC as its primary concurrency control technology. While it has many benefits, it also brings other effects, such as relation bloat.

PgAdmin is a GUI program for managing PostgreSQL, written in Python, but it’s quite dated and requires some additional configuration.

Recently there was a perplexing incident where a database had half its data volume and load migrated away, but ended up being overwhelmed due to increased load.

Some tips for interacting between PostgreSQL and Bash.

Backup is the foundation of a DBA’s livelihood. With backups, there’s no need to panic.

Pgbouncer is a lightweight database connection pool. This guide covers basic Pgbouncer configuration, management, and usage.

PgBackRest is a set of PostgreSQL backup tools written in Perl

It’s recommended to configure PostgreSQL’s log format as CSV for easy analysis, and it can be directly imported into PostgreSQL data tables.

PostGIS is PostgreSQL’s killer extension, but compiling and installing it isn’t easy.