Tutorials

Step-by-step guides for common PostgreSQL tasks and scenarios.

This section provides step-by-step tutorials for common PostgreSQL tasks and scenarios.


Instance Recovery

Clone instances and perform point-in-time recovery on the same machine

Troubleshooting

Common failures and analysis troubleshooting approaches

Manual Recovery

Manually perform PITR following prompt scripts in sandbox environment

Enabling HugePage for PostgreSQL

Enabling HugePage for PostgreSQL to reduce memory fragmentation and improve performance.

Accidental Deletion

Handling accidental data deletion, table deletion, and database deletion

HA Drill: Handling 2-of-3 Node Failure

HA scenario response plan: When two of three nodes fail and auto-failover doesn’t work, how to recover from the emergency state?

Bind a L2 VIP to PostgreSQL Primary with VIP-Manager

Deploy HA Citus Cluster

How to deploy a Citus high-availability distributed cluster?


Last Modified 2026-01-17: update pgsql extensions (cf92325)