skills.rest
Percona-Lab
Percona-LabOFFICIAL
Explore all skills by this author →
GitHub

postgres-to-percona-pg

Migrate PostgreSQL installations to Percona Distribution via package swap.

1|1|Updated May 29, 2026
Search Tags:#postgresql#migration#ha#percona-distribution#pg_tde#pg_stat_monitor
One-click install
npx skills add https://github.com/Percona-Lab/skills --skill postgres-to-percona-pg
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-to-percona-pg
Source: https://github.com/Percona-Lab/skills/tree/main/postgres-to-percona-pg
Command: npx skills add https://github.com/Percona-Lab/skills --skill postgres-to-percona-pg

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Migrate PostgreSQL installations to Percona Distribution for PostgreSQL.

Core Features & Use Cases

  • Same-server migration via package swap on the existing data directory to minimize downtime and preserve data.
  • Bundled features like pg_tde, pg_stat_monitor, and Patroni/etcd/HAProxy for high availability and enhanced observability.
  • Clear guidance for choosing between same-server vs different-server migrations, validating compatibility, and adopting Percona extension stack.

Quick Start

Migrate by planning a swap of Percona Distribution packages on the target server while reusing the existing data directory.

Frequently Asked Questions about postgres-to-percona-pg

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I migrate PostgreSQL to Percona Distribution on the same server?▼

Migrate PostgreSQL to Percona Distribution by swapping packages on the target server while reusing the existing data directory. This minimizes downtime and preserves data during the migration process.

What is the best way to add high availability to PostgreSQL using Percona?▼

Add high availability to PostgreSQL by integrating the Percona Distribution HA stack. This involves configuring Patroni, etcd, and HAProxy to ensure robust cluster management and failover.

Does Percona Distribution for PostgreSQL support transparent data encryption?▼

Yes, Percona Distribution supports transparent data encryption. You can adopt the bundled pg_tde extension during or after migration to encrypt data at rest within your PostgreSQL database.

Can I use pg_stat_monitor for PostgreSQL query observability after migrating?▼

Yes, pg_stat_monitor is a bundled feature of Percona Distribution. After migrating PostgreSQL, you can use this extension to gain enhanced query observability and performance monitoring.

What are the limitations of a same-server PostgreSQL migration via package swap?▼

Same-server PostgreSQL migration via package swap requires validating compatibility beforehand. You must verify your current PostgreSQL version and extensions align with the Percona Distribution to prevent data corruption.

When should I choose a different-server PostgreSQL migration over a package swap?▼

Choose different-server PostgreSQL migration over a package swap when you need to validate compatibility on separate hardware or want to avoid downtime risks associated with replacing packages on your existing data directory.

Related Skills

Explore More Software Engineering Skills→
OpenAEC-FoundationOpenAEC-Foundation
7

crosstech-impl-freecad-ifc-bridge

Open IFC files as active documents in FreeCAD using NativeIFC.

Official
Advanced
sigridjinethsigridjineth
6

kubespray-ha-configuration

Configure and verify Kubernetes HA with Kubespray etcd and load balancers.

Community
Advanced
IldarMinaevIldarMinaev
1

postgresql-performance-check

Analyze PostgreSQL cluster load, queries, and vacuum health for bottlenecks.

Community
Advanced
unju-aiunju-ai

database-migrations

Guide database schema changes and data migrations across PostgreSQL, MySQL, and ORMs.

Official
Advanced