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 and release candidate 1 is available for evaluation before 2.0.0 stable is published. Non-compatibilities with 1.x to be aware of when dropping in 2.x to replace it - 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
