# Syn Postgres Backup

> PostgreSQL: logical backup and point-in-time restore

- Skill: `legendtkl/syn-postgres-backup` (Agent Skill)
- Install (CLI): `npx skillmds@latest add legendtkl/syn-postgres-backup`
- Raw SKILL.md: https://api.skillmd.com/api/skills/legendtkl/syn-postgres-backup/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: legendtkl (https://skillmd.com/u/legendtkl)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/legendtkl/syn-postgres-backup

---


# PostgreSQL: logical backup and point-in-time restore

## When to use

Use this skill for logical backup and point-in-time restore in PostgreSQL. This skill
specifically handles logical backup and point-in-time restore and nothing else in the
PostgreSQL family.

## Procedure

Take consistent logical dumps with `pg_dump`/`pg_dumpall`, schedule base backups, archive WAL segments, and perform point-in-time recovery by setting `recovery_target_time`.

## Notes

This is the PostgreSQL skill dedicated to logical backup and point-in-time restore.
Sibling skills cover other PostgreSQL capabilities; this one
is the right choice only when the task is about logical backup and point-in-time restore.