Pyrseas 0.6.0, a framework for upgrading/migrating a PostgreSQL
database, has been released. It is available from:
GitHub: https://github.com/jmafc/Pyrseas
PyPI: http://pypi.python.org/pypi/Pyrseas
PGXN: http://pgxn.org/dist/pyrseas/
PgFoundry: http://pgfoundry.org/projects/pyrseas
Updated documentation is viewable at:
Read the Docs: http://pyrseas.readthedocs.org/en/latest/
Pyrseas now supports additional PostgreSQL DDL features:
- EXTENSIONs
- COLLATIONs
- OWNER information
- Access privileges (GRANT and REVOKE)
- TABLESPACEs for tables, primary keys and indexes
- MATCH attributes for foreign keys
- ALTER composite TYPE ADD/DROP/RENAME ATTRIBUTE
- ENUMs with no labels
- UNLOGGED tables
- CREATE FUNCTION SET configuration_parameter
Pyrseas supports PostgreSQL 8.4, 9.0, 9.1 and 9.2. The utilities can be
run under Python 2.6, 2.7, 3.2 or 3.3.
This release covers essentially all the objects possibly present in a
PostgreSQL 9.2 database (see Feature Matrix at
https://pyrseas.wordpress.com/feature-matrix/ ). We believe the
utilities may be useful beyond the migration use case. For example, it
could now be used to compare access privileges between test and
production databases.
Please report any issues at https://github.com/jmafc/Pyrseas/issues
Best regards,
Joe Abbate