PGExtractor is a script that can be used to provide more finely detailed filtering options for PostgreSQL's pg_dump program. Version 2.x is a complete rewrite in python.
https://github.com/omniti-labs/pg_extractorNon-compatibilities with 1.x to be aware of when dropping in 2.x to replace it
- Requires Python 3
- Many command line options have been changed for clarity.
- The "hostname" is no longer a default part of the directory structure created. If this is still desired, set the --hostnamedir option with whatever the existing directory is.
- Built in version control options are gone. They were rather fragile options and could easily lead to a whole lot of things getting checked into version control that should not have been. I've found it's easier (and safer) to manage version control check-ins separately. If these are really wanted please create an Issue on Github and I'll consider it if there's enough interest.
- Removed --rolesdir option
New features:
- Full python Class object with public methods that may possibly be useful on existing dump files
- --jobs option to allow parallel object extraction
- --remove_passwords option can remove the password hashes from an extracted roles file
- --getdefaultprivs extracts the default privileges set for any roles that used ALTER DEFAULT PRIVILEGES
- --delete cleans up empty folders properly
- --wait option to allow a pause in object extraction. Helps reduce load when data is included in extraction.
- --temp option to allow setting custom temporary working space
- Sequences files can now include the statement to set the current value if data is output
- Better support for when objects have mixed case names or special characters. Special characters in an object name turn into ,hexcode, to allow a valid system filename.
- Rules & Triggers on views are now always included in the view file itself properly.
The version 1.x series written in perl will no longer be developed. Only bug fixes to the existing code will be accepted.