Upgrade and Operate

Use this page for production-facing extension lifecycle tasks.

Install or Upgrade

create extension pg_liquid;

or:

alter extension pg_liquid update to '0.1.1';

Supported Upgrade Path

The extension ships upgrade scripts from legacy internal 1.x versions to the public 0.1.x line.

Recommended Rollout Sequence

  1. Build and install extension binaries on the PostgreSQL host.
  2. Rehearse create extension or alter extension ... update in staging.
  3. Run smoke queries through liquid.query(...) or liquid.read_as(...).
  4. Validate principal-scoped access if you use CLS.
  5. If using row normalizers, rebuild or backfill them deliberately.

Useful Validation Commands

make package-check
make installcheck
make bench-check
make pgxn-package

GitHub and PGXN

The repository now supports:

  • GitHub Actions CI
  • benchmark validation
  • automatic version bumping on release
  • GitHub release publishing
  • PGXN package publishing

PostgreSQL Version Matrix

Current validated range:

  • PostgreSQL 14
  • PostgreSQL 15
  • PostgreSQL 16
  • PostgreSQL 17
  • PostgreSQL 18