From: | Keith Fiske <keith(at)omniti(dot)com> |
---|---|
To: | pgsql-announce(at)postgresql(dot)org |
Subject: | PG Extractor 2.0.0RC1 Released |
Date: | 2014-03-07 17:03:52 |
Message-ID: | CAG1_KcBjaOhBzOokwmh55BXaC4uo+DP+Q_FZa-x9MrQrgwrr6w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Keith Fiske | 2014-03-07 18:07:34 | Re: PG Extractor 2.0.0RC1 Available |
Previous Message | Christoph Berg | 2014-03-03 16:46:14 | New Ubuntu releases on apt.postgresql.org |