Prompted by Peter Eisentraut’s blog post, I’ve finished adding support for PG 9.1 EXTENSIONs to the Pyrseas dbtoyaml and yamltodb utilities. For now, this is only available on GitHub.
In order to deal with procedural languages, which are now created as extensions, the utilities now fetch the pg_catalog schema (previously deemed uninteresting for the purpose of version control). The output of dbtoyaml from a freshly created 9.1 database (assuming no customizations via template1) is now:
schema pg_catalog: description: system catalog schema extension plpgsql: description: PL/pgSQL procedural language version: '1.0' schema public: description: standard public schema
This could be changed easily to exclude pg_catalog (which will now also appear against 8.4 and 9.0 databases) before the next Pyrseas release. Update: The pg_catalog schema will now only be shown if it has something other than a description.
I’m hoping some brave, adventurous or simply interested souls will help test the additions. Please report any issues on GitHub.
