Upgrade from Ubuntu Bionic VPS to Jammy

Upgrade O.S.

• https://ubuntu.com/blog/how-to-upgrade-from-ubuntu-18-04-lts-to-20-04-lts-today

apt-get install libjson-xs-perl libapache2-authcookie-perl cpanminus libdbd-pg-perl \
  libipc-run-safehandles-perl libfile-find-rule-perl libarchive-tar-wrapper-perl \
  default-jre libreoffice-java-common libdata-validate-ip-perl libcaptcha-recaptcha-perl 
cpanm SQL::Dialects::ANSI
cpanm --force SQL::Interpolate
cpanm ODF::lpOD
cpanm DTL::Fast
cpanm HOP::Lexer
cpanm -U JSON::XS
cpanm JSON::XS@3.04
cpanm JSON::Syck
cpanm HTTP::BrowserDetect
cpanm common::sense
cpanm Types::Serialiser
cpanm Excel::Writer::XLSX
cpanm Sys::RunAlone
cpanm HTTP::Request::JSON
cpanm SQL::Interp

# Deprecated Mail::Sender (with errors)
apt-get purge libmail-sender-perl
cpanm -v Mail::Sender

Upgrade PostgreSQL (repository PGDG)

# Repository
F="/etc/apt/sources.list.d/postgresql.list"
[ -f "$F.save" ] && rm $F.save
sudo apt install -y postgresql-common ca-certificates
rm /usr/share/postgresql-common/pgdg/apt.postgresql.org
sudo install -d /usr/share/postgresql-common/pgdg
sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc
. /etc/os-release
sudo sh -c "echo 'deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $VERSION_CODENAME-pgdg main' > /etc/apt/sources.list.d/pgdg.list"
apt-get update

#Check versions:
psql --version
pg_lsclusters
Current version probably 14.XX, please check and setup variables:
OLD="14"
NEW="18"
# Backup
cd /tmp
sudo -u postgres pg_dumpall | gzip >/BACKUPS/pg_dumpall_$OLD.sql.gz

# Install new release
apt-get install -y postgresql-$NEW postgresql-client-$NEW postgresql-plperl-$NEW

# Upgrade DB
systemctrl stop apache2
pg_upgradecluster 14 main
systemctrl start apache2

# Remove old postgresql
apt-get purge postgresql-$OLD postgresql-client-$OLD postgresql-plperl-$OLD

Remove old packages

apt autoremove
rm -r /usr/local/share/perl/5.26.1 /usr/local/lib/x86_64-linux-gnu/perl/5.26.1