New pg_validate_extupgrade tool available

From: Julien Rouhaud via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: New pg_validate_extupgrade tool available
Date: 2021-07-22 16:12:27
Message-ID: 162697034794.648.2191931009203900896@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Hello,

I'm pleased to announce the release of [pg_validate_extugprade](https://github.com/rjuju/pg_validate_extupgrade), version **1.0.0 beta**.

If you develop PostgreSQL extensions and provide both install and upgrade scripts, [pg_validate_extugprade](https://github.com/rjuju/pg_validate_extupgrade) can help you to validate your scripts. It's a new command line utility tool that will verify that installing an extension in version **X** and upgrading it to version **Y** will create the exact same objects as if you installed the extension in version **Y** directly, and will list all the differences if any problem is found.

This tools is written in Rust and is open source with a GPL3 license. It's compatible with PostgreSQL 9.2 up to 14. You can refer to the [project's README](https://github.com/rjuju/pg_validate_extupgrade/blob/master/README.md) for more details and output sample, or the [bug tracker](https://github.com/rjuju/pg_validate_extupgrade/issues) if you experience any problem.

#### Usage

USAGE:
pg_validate_extupgrade [OPTIONS] --extname <extname> --from <from> --to <to>

FLAGS:
--help Prints help information
-V, --version Prints version information

OPTIONS:
-d, --dbname <dbname> database name
-e, --extname <extname> extension to test
--from <from> initial version of the extension
-h, --host <host> database server host or socket directory
-p, --port <port> database server port
--to <to> upgraded version of the extension
-U, --user <user> database user name

Browse pgsql-announce by date

  From Date Subject
Next Message CYBERTEC PostgreSQL International GmbH via PostgreSQL Announce 2021-07-22 18:52:23 PGDay Austria 2021 - Full schedule out now!
Previous Message Postgres.ai via PostgreSQL Announce 2021-07-22 16:12:15 Database Lab Engine 2.4: realistic DB testing in GitHub Actions; Terraform module