Pyrseas 0.7.0, a framework for upgrading/migrating a Postgres
database, has been released. It is available from:
GitHub: https://github.com/pyrseas/Pyrseas (CHANGED)
PyPI: https://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/
Python Hosted: http://pythonhosted.org/Pyrseas/
Pyrseas now supports the following additional Postgres features:
- Postgres 9.3, specifically
- EVENT TRIGGERs
- MATERIALIZED VIEWs
- CLUSTER
- Partial indexes
- Storage parameters in CREATE and ALTER TABLE
- ALTER COLUMN SET STATISTICS
- LEAKPROOF qualifier for FUNCTIONs
- YAML multi-line string formatting for view definitions,
function source text and object comments
In addition, this release includes:
* Configuration files
All Pyrseas utilities can now use YAML-formatted configuration
files, in addition to command line options
* Multiple-file input or output
Spread database object information across a version control
repository
* Data export/import
Load a database with static data in production or data subsets
for testing
* dbtoyaml/yamltodb
- Added --quote-reserved option to yamltodb
- Exclude arguments from sfunc and finalfunc attributes of
aggregate functions (#54)
- Correct generation of SQL for functions with DEFAULT
arguments (#52)
* Augmenter
New utility (dbaugment) to consistently add objects to an
existent database. This is currently an experimental
feature and covers adding audit columns to tables.
* TTM-inspired relational interface
A new interface to Postgres, inspired by *The Third Manifesto*
I'd like to thank Adam Cornett, Andrey Popp, Antti Jokipii,
barkingfoodog@GH, Jesse Denardo, Josep Martinez, Mephysto666@GH, Roger
Hunwicks and anyone else who contributed time to test, open issues,
submit pull requests or otherwise helped make this release possible.
Best regards,
Joe Abbate