PG Exractor 2.0.0 Stable Released

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