Keith Fiske: PG Extractor - A smarter pg dump
Pg_dump is a great tool for getting your data out of the database for backups or many other uses. It is, however, lacking in fine grained filtering to get exactly the schema and/or data you want. PG Extractor (pg_extractor) was born out of this frustration to show what pg_dump could hopefully be some day.
A lack of ACLs and Comments in pg_dump output for anything but tables; an extremely long and tedious command to type out to filter out possibly hundreds of table and views; no filtering on any object types/names except for schemas and tables; these are all issues I've run into with trying to use pg_dump as a schema backup tool. What started out as a tool that contained complex internal queries to try and get the internal structure of a database out in finer detail was rewritten to use pg_dump/all & pg_restore to their fullest potential.
Want to dump out a list of tables to a file using psql and feed that back in as an include/exclude filter? Want to dump objects based on owner? Want to use regex pattern matching to rule out partitions in your schema dump? Want to use Git or SVN to automatically keep track of schema changes to your database? pg_extractor allows these things and more.
This talk will discuss some of the development process of the tool and issues (with some solutions!) that were encountered along the way. Will also give examples and how we currently use this tool in production.
Видео Keith Fiske: PG Extractor - A smarter pg dump канала Postgres Open
A lack of ACLs and Comments in pg_dump output for anything but tables; an extremely long and tedious command to type out to filter out possibly hundreds of table and views; no filtering on any object types/names except for schemas and tables; these are all issues I've run into with trying to use pg_dump as a schema backup tool. What started out as a tool that contained complex internal queries to try and get the internal structure of a database out in finer detail was rewritten to use pg_dump/all & pg_restore to their fullest potential.
Want to dump out a list of tables to a file using psql and feed that back in as an include/exclude filter? Want to dump objects based on owner? Want to use regex pattern matching to rule out partitions in your schema dump? Want to use Git or SVN to automatically keep track of schema changes to your database? pg_extractor allows these things and more.
This talk will discuss some of the development process of the tool and issues (with some solutions!) that were encountered along the way. Will also give examples and how we currently use this tool in production.
Видео Keith Fiske: PG Extractor - A smarter pg dump канала Postgres Open
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![PostgreSQL In Critical Messaging - John Mason Scott](https://i.ytimg.com/vi/tNl9pY4PSyg/default.jpg)
![Amazon RDS for PostgreSQL - Grant McAlister](https://i.ytimg.com/vi/bZ0YBcfE-I8/default.jpg)
![A TARDIS for your ORM - Magnus Hagander](https://i.ytimg.com/vi/JsO551E7ySY/default.jpg)
![Postgres Open 2016 - Reviewing PostgreSQL Patches for Fun and Profit](https://i.ytimg.com/vi/FzNXFJ2-r0s/default.jpg)
![Mike Bayer: Introduction to SQLAlchemy, Part 1](https://i.ytimg.com/vi/KufdF1kyI-g/default.jpg)
![PostgresOpen 2019 A Look At The Elephants Trunk](https://i.ytimg.com/vi/iUm1OPBa0Wk/default.jpg)
![Welcome to Postgres! - Michael Alan Brewer](https://i.ytimg.com/vi/Vx0_zBfVBQA/default.jpg)
![Jonathan S. Katz: Postgres SQL Data Type Safari, Part 2](https://i.ytimg.com/vi/WaDmOgoUJU0/default.jpg)
![How Databases Work - For Developers, Accidental DBA's and Managers - Gurjeet Singh](https://i.ytimg.com/vi/OUM_Mww8gkw/default.jpg)
![PostgreSQL In PaxosLand - Srivathsava Rangarajan](https://i.ytimg.com/vi/iZxi2vycNQ8/default.jpg)
![Survival Analysis of Customer Retention using Postgres, SQL and R - Gleb Arshinov](https://i.ytimg.com/vi/dLPzx6qEIJM/default.jpg)
![Postgres Open 2016 - The Elephant Meets the Whale](https://i.ytimg.com/vi/t9Y5ba7AWNc/default.jpg)
![Mike Bayer: Introduction to SQLAlchemy, Part 2](https://i.ytimg.com/vi/cNmJM7Or4YU/default.jpg)
![David Keeney: SQl Database Server Request from the Browser](https://i.ytimg.com/vi/fFWqZYOJ-xU/default.jpg)
![Shaun M. Thomas: High Availability with PostgreSQL and Pacemaker](https://i.ytimg.com/vi/xxKcEUclhZw/default.jpg)
![Josh Berkus: Super Jumbo Delux](https://i.ytimg.com/vi/eH37pcvrmgs/default.jpg)
![John S Jones: NewSQL Leveraging PostgreSQL](https://i.ytimg.com/vi/AmZr5zZpmbE/default.jpg)
![Magnus Hagander: Secure Your Web Webapp passwords in PostgreSQL](https://i.ytimg.com/vi/MuLMIQBB4Ew/default.jpg)
![PostgreSQL for Developers - Dimitri Fontaine](https://i.ytimg.com/vi/Mq5tMcT31bY/default.jpg)
![ANSI, Schmansi!](https://i.ytimg.com/vi/VyQTVLJgJ60/default.jpg)
![Database Hardware Selection Guidelines - Bruce Momjian](https://i.ytimg.com/vi/qIlYZeSuv8w/default.jpg)