Skip to content

Releases

0.2.0

Choose a tag to compare

@brunoportess brunoportess released this 16 Nov 13:58
0188847

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_govlite installs the multi layout across multiple schemas.
  • pg_govlite_single installs the single layout in an existing schema chosen by the DBA. Upgrades reuse the schema selected at installation.
  • make install deploys the extension files for both layouts. make core creates the extension in the target database, and make upgrade applies 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_dump omits the contents of tables owned by the extension. Use a PostgreSQL cluster backup to preserve governance state.

first draft for use

first draft for use Pre-release
Pre-release

Choose a tag to compare

@ppKrauss ppKrauss released this 13 May 05:43

Passed the asserts, and all seems to be working.