Updating PGMQ

Notes

  • Updates from versions before 0.14.3 are not supported, and a full re-install is required.
  • When updating from pre-1.0.0 versions to post-1.0.0 versions, a stop at 1.0.0 is required. For example, if you were to update from 0.33.1 to 1.1.0, you first need to update from 0.33.1 to 1.0.0, and only after 1.0.0 is installed you can perform the update to 1.1.0.

When building from source

If pgrx wasn't initialized yet: ```

Remember to use the flag for your postgres major version

cargo pgrx init --pg15=which pg_config ```

Clone the pgmq repo and checkout the desired version. For example, for 1.0.0: git clone git@github.com/tembo-io:pgmq cd pgmq git checkout v1.0.0

Then, compile and install the extension: cargo pgrx install --release

Now, connect to postgres and run: ALTER EXTENSION pgmq UPDATE

If successfull, pgmq is updated!