view NewTests/PostgresUpgrades/downgrade.sh @ 864:6380edfc4345

pg upgrade tests
author Alain Mazy <am@orthanc.team>
date Fri, 28 Nov 2025 15:49:08 +0100
parents 6403b6da775e
children
line wrap: on
line source

#!/bin/bash

pushd /scripts

apt-get update && apt-get install -y wget mercurial
hg clone https://orthanc.uclouvain.be/hg/orthanc-databases
pushd /scripts/orthanc-databases/
# hg update -r default

psql -U postgres -f /scripts/orthanc-databases/PostgreSQL/Plugins/SQL/Downgrades/Rev10ToRev5.sql

# if you want to test a downgrade procedure, you may use this code ...
# psql -U postgres -f downgrade.sql
popd
popd