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_extractor Non-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.* -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com
