PG Extractor - A smarter pg dump
summary
A Perl tool called pg_extractor uses pg_dump and pg_restore to emit database schema as per-object files (tables views functions types roles) and to capture ACLs and comments that pg_dump omits for non-table objects. It supports owner-based filtering, include/exclude lists fed from psql, and regex partition exclude to skip tens of thousands of child tables. It integrates with Git/SVN, offers a delete-cleanup mode, and relies on an initial full dump so large catalogs can make runs take hours and overloaded functions and odd character names require special handling.
AI-written summary · about
chapters (6)
- 0:00Start
- 0:20What Is Pg Extractor
- 3:46Basic Usage and Examples
- 11:58Regex Matching
- 14:27Gate and Svn
- 18:04Current Issues
related talks
51mWhen Postgres Can't, You Can!
28mHow to copy a Postgres database?
50mPostgreSQL Backup and Recovery Methods
49mTools for Creating PostgreSQL Backups
34mPglog: a flexible log analyser
45mGraph databases, PostgreSQL and SQL/PGQ
32mAnonymizing Data in Postgres Without Losing Your Mind (or Your
46mAn ultimate guide to upgrading your PostgreSQL installation