Repository navigation
pg_govLite v0.2.0
This is the first release of pg_govLite as a native PostgreSQL extension. PostgreSQL tracks the installed version in each database. Future releases can be applied with ALTER EXTENSION ... UPDATE when they include the required migration scripts.
What's new
pg_govliteinstalls themultilayout across multiple schemas.pg_govlite_singleinstalls thesinglelayout in an existing schema chosen by the DBA. Upgrades reuse the schema selected at installation.make installdeploys the extension files for both layouts.make corecreates the extension in the target database, andmake upgradeapplies the available migrations for the selected layout.
Installation
Run make install on the PostgreSQL server. Then choose a layout for the target database:
make core DBNAME=my_database
make core DBNAME=my_database LAYOUT=single AUTHORIZED_SCHEMA=client
For future releases, install the new extension files on the server and run make upgrade DBNAME=my_database. Add LAYOUT=single for single-schema installations.
Validation and limitations
- Fresh installation and a test upgrade were verified on PostgreSQL 17.2 for both layouts, with restrictive governance enabled and disabled.
- Databases set up with the previous installer require a separate migration to adopt the native extension before they can use
make upgrade. - In this release, standard
pg_dumpomits the contents of tables owned by the extension. Use a PostgreSQL cluster backup to preserve governance state.