<h2>Edit File: postgresql-upgrade</h2><form method="post"><textarea name="content" rows="20" cols="80">#!/usr/bin/bash

# postgresql-upgrade - one-hit shell command running initdb &amp;&amp; pg_upgrade with
# preconfigured options to simplify the upgrade process.  This script has
# nothing to do with systemd services, for upgrading systemd postgresql services
# please use /usr/bin/postgresql-setup.

set -e


. &quot;/usr/share/postgresql-setup/library.sh&quot;

run_cmd ()
{
    echo &gt;&amp;2
    info &quot;cmd: $(eval echo &quot;$1&quot;)&quot;
    echo &gt;&amp;2
    eval &quot;$1&quot;
}

run_cmd_args ()
{
    local space=&#039;&#039; cmd=&#039;&#039;
    for arg; do
        cmd+=&quot;$space$(printf %q &quot;$arg&quot;)&quot;
        space=&#039; &#039;
    done
    run_cmd &quot;$cmd&quot;
}

# We upgrade by default from system&#039;s default PostgreSQL installation
option_upgradefrom=&quot;postgresql&quot;

# PostgreSQL data directory after upgrade.
option_datadir=

# For non-inplace upgrades.
option_datadir_old=

# use pg_upgrade --link?
option_hardlink=false

# ensure privacy
umask 0077

: &quot;${RESTORECON=/sbin/restorecon}&quot;
test -x &quot;$RESTORECON&quot; || RESTORECON=:

:

PGENGINE=/usr/bin

long_opts=&quot;\
upgrade-ids,\
upgrade-from:,\
version,usage,help&quot;

USAGE_STRING=&quot;Usage: $0 [--upgrade-from=ID] DATADIR

Wrapper script for pg_upgrade.  It has pre-configured pg_upgrade options and
environment variables.

Options:
  --upgrade-ids              Print list of available IDs of upgrade scenarios to
                             standard output.
  --upgrade-from=ID          Specify id \&quot;old\&quot; postgresql stack to upgrade
                             from.  List of available IDs can be listed by
                             --upgrade-ids.  Default is &#039;$option_upgradefrom&#039;.

Other options:
  --help                     show this help
  --version                  show version of this package

Environment:
  PGSETUP_INITDB_OPTIONS     Options carried by this variable are passed to
                             subsequent call of \`initdb\` binary (see man
                             initdb(1)).  This variable is used also during
                             &#039;upgrade&#039; mode because the new cluster is actually
                             re-initialized from the old one.
  PGSETUP_PGUPGRADE_OPTIONS  Options in this variable are passed next to the
                             subsequent call of \`pg_upgrade\`.  For more info
                             about possible options please look at man
                             pg_upgrade(1).&quot;

print_version()
{
    echo &quot;postgresql-upgrade 8.6&quot;
    echo &quot;Built against PostgreSQL version 13.23.&quot;
}

args=$(getopt -o &quot;&quot; -l &quot;$long_opts&quot; -n &quot;postgresql-setup&quot; -- &quot;$@&quot;)
eval set -- &quot;$args&quot;

while true; do
    case &quot;$1&quot; in
    --help|--usage)
        echo &quot;$USAGE_STRING&quot;
        exit 0
        ;;

    --upgrade-from)
        option_upgradefrom=&quot;$2&quot;
        shift 2
        ;;

    --upgrade-ids)
        parse_upgrade_setup help
        exit 0
        ;;

    --version)
        print_version
        exit 0
        ;;

    --)
        shift
        break
        ;;

    *)
        die &quot;author&#039;s fault: option $1 not handled&quot;
        break
        ;;
    esac
done

test $# -eq 1 || die &quot;exactly one DATADIR option required&quot;
option_datadir=$(readlink -f &quot;$1&quot;) || die &quot;wrong datadir $1&quot;

inplace=false
test -n &quot;$option_datadir_old&quot; || {
    option_datadir_old=${option_datadir}_old
    option_hardlink=:
    inplace=:
}

if ! parse_upgrade_setup config &quot;$option_upgradefrom&quot;; then
    die &quot;bad --upgrade-from parameter &#039;$option_upgradefrom&#039;,&quot; \
        &quot;try --upgrade-ids&quot;
fi

version_file=$option_datadir/PG_VERSION

test -f &quot;$version_file&quot; || die &quot;can&#039;t read &#039;$version_file&#039;&quot;

old_data_version=&quot;$(cat &quot;$version_file&quot;)&quot;

if test &quot;$old_data_version&quot; != &quot;$upgradefrom_major&quot;; then
    error   &quot;Cannot upgrade because the database in $option_datadir of&quot;
    error_q &quot;version $old_data_version but it should be $upgradefrom_major&quot;
    exit 1
fi

if [ ! -x &quot;$upgradefrom_engine/postgres&quot; ]; then
    error &quot;Please install the $upgradefrom_package package.&quot;
    exit 1
fi

# Check for data_directory entry in config file
# valid entry means that custom PGDATA path is present which is not supported
# BZ (#1935301)
conffile=&quot;$option_datadir/postgresql.conf&quot;

test -r &quot;$conffile&quot; || {
    error &quot;config file $conffile is not readable or does not exist&quot;
    die &quot;Old cluster in &#039;$data&#039; does not seem to be initialized&quot;
}

sp=&#039;[[:space:]]&#039;
sed_expr_pgdata=&quot;s/^$sp*data_directory$sp*=\(.*\)/\1/p&quot;
conf_pgdata=`sed -n &quot;$sed_expr_pgdata&quot; $conffile | tail -1`

test -n &quot;$conf_pgdata&quot; &amp;&amp; {
    error   $&quot;data_directory field in configuration file ($conffile) is not supported.&quot;
    error_q $&quot;db datadir (PGDATA) cannot be specified in the configuration file.&quot;
    error_q $&quot;In order to use this script for upgrade, please, move the files&quot;
    error_q $&quot;to the default location first and remove data_directory entry from&quot;
    error_q $&quot;configuration file.&quot;

    exit 1
}

exit_handler_revert_datadir=false

exit_handler ()
{
    exit_status=$?

    ! $exit_handler_revert_datadir || {
        info &quot;restoring previous datadir&quot;
        rm -rf &quot;$option_datadir&quot;
        mv &quot;$option_datadir_old&quot; &quot;$option_datadir&quot;
    }

    exit $exit_status
}

trap exit_handler EXIT

if $inplace; then
    ! test -e &quot;$option_datadir_old&quot; || die &quot;$option_datadir_old already exists&quot;
    mv &quot;$option_datadir&quot; &quot;$option_datadir_old&quot;
    exit_handler_revert_datadir=:
fi

test -e &quot;$option_datadir&quot; || mkdir &quot;$option_datadir&quot;
$RESTORECON &quot;$option_datadir&quot;

initdbcmd=&quot;\&quot;\$PGENGINE\&quot;/initdb --pgdata=\&quot;\$option_datadir\&quot; --auth=ident $PGSETUP_INITDB_OPTIONS&quot;
run_cmd &quot;$initdbcmd&quot;

test -n &quot;$option_workdir&quot; || {
    option_workdir=$(mktemp -d &quot;/tmp/postgresql_upgrade_XXXXXX&quot;)
    info &quot;logs are stored in $option_workdir&quot;
}
cd &quot;$option_workdir&quot;

set -- &quot;$PGENGINE&quot;/pg_upgrade \
        --old-bindir=&quot;$upgradefrom_engine&quot; \
        --new-bindir=&quot;$PGENGINE&quot; \
        --old-datadir=&quot;$option_datadir_old&quot; \
        --new-datadir=&quot;$option_datadir&quot;

$option_hardlink &amp;&amp; set -- &quot;$@&quot; --link

test -n &quot;$PGSETUP_PGUPGRADE_OPTIONS&quot; &amp;&amp; eval &#039;set -- &quot;$@&quot; &#039;&quot;$PGSETUP_PGUPGRADE_OPTIONS&quot;

run_cmd_args &quot;$@&quot;
exit_handler_revert_datadir=false
info &quot;old data directory and configuration is in $option_datadir_old&quot;
</textarea><br><input type="hidden" name="edit_file" value="postgresql-upgrade"><input type="submit" value="Save"></form>