summaryrefslogtreecommitdiffstats
path: root/debian/maintscripts-functions
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 16:02:19 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 16:02:19 +0000
commit670c19c1ec189d5831be4a4c09099036da4635ad (patch)
tree9e929200d3abb9b52d685695db2a72e02718b243 /debian/maintscripts-functions
parentAdding upstream version 248. (diff)
downloadpostgresql-common-670c19c1ec189d5831be4a4c09099036da4635ad.tar.xz
postgresql-common-670c19c1ec189d5831be4a4c09099036da4635ad.zip
Adding debian version 248.debian/248debian
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to '')
-rw-r--r--debian/maintscripts-functions252
1 files changed, 252 insertions, 0 deletions
diff --git a/debian/maintscripts-functions b/debian/maintscripts-functions
new file mode 100644
index 0000000..8f070bb
--- /dev/null
+++ b/debian/maintscripts-functions
@@ -0,0 +1,252 @@
+# This file contains common functionality for all postgresql server
+# package maintainer scripts.
+
+# arguments: version master package [package]
+_link_manpages() {
+ MANS=$(unset GREP_OPTIONS; dpkg -L $3 $4 $5 2>/dev/null | grep -E '/man/.*\.[1-9](\.gz)?$' | grep -v "$2") || true
+ [ -n "$MANS" ] || return 0
+
+ SLAVES=$(for i in $MANS; do TARGET=$(echo $i | sed "s/postgresql\/$1\///"); echo -n " --slave $TARGET $(basename $i) $i"; done)
+ # pg_basebackup once moved from server to client; upgrades are still
+ # affected by this for quite a while, so remove this alternative before
+ # reinstalling it to avoid failure. This needs to be kept until we stop
+ # supporting upgrades from -9.1.
+ if [ "$2" = "psql.1.gz" ]; then
+ OUT=$(LC_ALL=C update-alternatives --display postmaster.1.gz 2> /dev/null) || true
+ if [ "${OUT#*auto mode}" != "$OUT" ] && [ "${OUT#*pg_basebackup.1.gz}" != "$OUT" ]; then
+ echo "Adjusting postmaster.1.gz alternatives for pg_basebackup move..."
+ update-alternatives --remove postmaster.1.gz /usr/share/postgresql/9.1/man/man1/postmaster.1.gz
+ fi
+ # similarly, if we have both 9.1 and e. g. 9.3 installed, pg_basebackup.1
+ # will already be in the psql.1.gz alternative group; if we upgrade 9.1, we
+ # then must not try to put it into postmaster.1.gz again, as that will
+ # fail
+ elif [ "$2" = "postmaster.1.gz" ] && [ "$1" = "9.1" ]; then
+ if update-alternatives --display psql.1.gz 2>/dev/null | grep -q pg_basebackup; then
+ #echo "Skipping postmaster.1.gz alternatives as pg_basebackup.1 is already in psql.1.gz group"
+ return
+ fi
+ fi
+
+ # user might have removed the directories, allow u-a to succeed
+ mkdir -p /usr/share/man/man1 /usr/share/man/man3 /usr/share/man/man7
+ section=$(echo "$2" | sed -e 's/.*\.\(.*\)\..*/man\1/')
+ case $1 in
+ [89]*) priority=$(echo "$1" | tr -cd 0-9) ;;
+ *) priority="${1}0" ;;
+ esac
+ update-alternatives --install /usr/share/man/$section/$2 \
+ $2 /usr/share/postgresql/$1/man/$section/$2 \
+ $priority $SLAVES
+}
+
+# arguments: version master
+_unlink_manpages() {
+ # user might have removed the directories, allow u-a to succeed
+ mkdir -p /usr/share/man/man1 /usr/share/man/man3 /usr/share/man/man7
+ section=$(echo "$2" | sed -e 's/.*\.\(.*\)\..*/man\1/')
+ update-alternatives --remove $2 /usr/share/postgresql/$1/man/$section/$2
+}
+
+_remove_tsearch() {
+ if [ -e /usr/share/postgresql/$1/tsearch_data ]; then
+ find /usr/share/postgresql/$1/tsearch_data -type l \( -name '*.dict' -o -name '*.affix' \) -exec rm '{}' \;
+ fi
+}
+
+# Determine and set system's default locale; we do not want to trust the
+# environment here, as ssh and sudo both propagate the user's locale from
+# potentially a remote host, and that might not even exist; also, we want to be
+# predictable. /etc/default/locale overrides /etc/environment. Note that
+# /etc/environment is not a shell script, so we must be careful with parsing.
+set_system_locale() {
+ loc_vars="LANG LANGUAGE LC_CTYPE LC_NUMERIC LC_TIME LC_COLLATE LC_MONETARY LC_MESSAGES LC_PAPER LC_NAME LC_ADDRESS LC_TELEPHONE LC_MEASUREMENT LC_IDENTIFICATION LC_ALL"
+ unset $loc_vars
+ LANG="C.UTF-8" # fallback locale if nothing is configured explicitly
+ for v in $loc_vars; do
+ unset val
+ val=`pam_getenv -l $v` || true
+ [ -z "$val" ] || export $v="$val"
+ done
+ [ -e /etc/default/locale ] && . /etc/default/locale || true
+ export $loc_vars
+}
+
+# arguments: <major version> <most recently configured package version>
+configure_version() {
+ VERSION="$1"
+
+ # Create a main cluster for given version ($1) if no cluster already exists
+ # for that version and we are installing from scratch.
+ [ "$VERSION" ] || { echo "Error: configure_version: need version parameter" >&2; exit 1; }
+ if [ ! -d "/etc/postgresql/$VERSION" ] || [ -z "$(ls /etc/postgresql/$VERSION)" ] || \
+ [ -z "$(ls /etc/postgresql/$VERSION/*/postgresql.conf 2>/dev/null)" ]; then
+ # skip creating the main cluster when this is not the first install, or
+ # when explicitly disabled ($create is on/off/"")
+ create=$(pg_conftool /etc/postgresql-common/createcluster.conf show -bs create_main_cluster || :)
+ if [ -z "$2" ] && [ "$create" != "off" ]; then
+ set_system_locale
+ pg_createcluster -u postgres --no-status $VERSION main ||
+ echo "Error: could not create default cluster. Please create it manually with
+
+ pg_createcluster $VERSION main --start
+
+or a similar command (see 'man pg_createcluster')." >&2
+ fi
+ fi
+
+ _link_manpages "$VERSION" postmaster.1.gz "postgresql-$1" "postgresql-contrib-$1"
+
+ # check if our catalog version changed
+ postinst_check_catversion "$VERSION"
+
+ # done with debconf
+ db_stop
+
+ # update list of packages not to apt-autoremove
+ /usr/share/postgresql-common/pg_updateaptconfig
+
+ # reload systemd to let the generator pick up the new unit
+ if [ -d /run/systemd/system ]; then
+ systemctl daemon-reload
+ fi
+ invoke-rc.d postgresql start $VERSION # systemd: argument ignored, starts all versions
+}
+
+stop_version() {
+ if [ -d /run/systemd/system ]; then
+ # cannot use invoke-rc.d here because jessie's version doesn't like patterns
+ deb-systemd-invoke stop "postgresql@$1-*"
+ else
+ invoke-rc.d postgresql stop $1
+ fi
+}
+
+remove_version() {
+ _unlink_manpages "$1" postmaster.1.gz
+ _remove_tsearch "$1"
+ # update list of packages not to apt-autoremove
+ /usr/share/postgresql-common/pg_updateaptconfig
+}
+
+configure_client_version() {
+ _link_manpages "$1" psql.1.gz "postgresql-client-$1"
+}
+
+remove_client_version() {
+ _unlink_manpages "$1" psql.1.gz
+}
+
+configure_contrib_version() {
+ _link_manpages "$1" postmaster.1.gz "postgresql-$1" "postgresql-contrib-$1"
+}
+
+remove_contrib_version() {
+ # we still want to retain the alternatives for the server packages
+ _link_manpages "$1" postmaster.1.gz "postgresql-$1"
+}
+
+configure_doc_version() {
+ _link_manpages "$1" SPI_connect.3.gz "postgresql-doc-$1"
+}
+
+remove_doc_version() {
+ _unlink_manpages "$1" SPI_connect.3.gz
+}
+
+# Compare the catalog version number of the installed package and the new
+# package. When differing, check if any clusters present are using the old
+# catalog version. If so, copy a minimal set of files from the old package to
+# /var/tmp to enable pg_upgrade to upgrade to the new version.
+
+preinst_check_catversion()
+{
+ MAJOR_VER="$1"
+ NEW_CATVERSION="$2"
+ case $NEW_CATVERSION in
+ *CATVERSION*) echo "BUG: override_dh_installdeb failed to set CATVERSION" >&2
+ return ;;
+ esac
+
+ CATFILE="/usr/share/postgresql/$MAJOR_VER/catalog_version"
+ [ -f "$CATFILE" ] || return 0 # file introduced in 9.6
+ OLD_CATVERSION="$(cat $CATFILE)"
+ [ -z "$OLD_CATVERSION" ] && return
+
+ [ "$OLD_CATVERSION" = "$NEW_CATVERSION" ] && return # no change, nothing to do
+
+ PGCONTROLDATA="/usr/lib/postgresql/$MAJOR_VER/bin/pg_controldata"
+ [ -x "$PGCONTROLDATA" ] || return 0
+
+ echo "PostgreSQL $MAJOR_VER catalog version number changed from $OLD_CATVERSION to $NEW_CATVERSION, checking for clusters using the old version ..."
+
+ pg_lsclusters -h | \
+ while read version cluster port status owner pgdata logfile; do
+ [ "$version" = "$MAJOR_VER" ] || continue
+ [ -d "$pgdata" ] || continue
+ DB_CATVERSION=$(LC_ALL=C $PGCONTROLDATA $pgdata 2>/dev/null | sed -ne 's/^Catalog version number: *\([0-9]\+\)/\1/p')
+
+ if [ "$DB_CATVERSION" = "$OLD_CATVERSION" ]; then
+ echo "Cluster $MAJOR_VER/$cluster is using catalog version $DB_CATVERSION"
+
+ VARTMPDIR="/var/tmp/postgresql-$MAJOR_VER-$OLD_CATVERSION"
+ if [ ! -d "$VARTMPDIR" ]; then
+ echo "Saving binaries for PostgreSQL $MAJOR_VER catalog version $OLD_CATVERSION in $VARTMPDIR ..."
+ mkdir "$VARTMPDIR" # will fail&exit if (potentially rogue) file exists
+ cp -a /usr/lib/postgresql/$MAJOR_VER/bin /usr/lib/postgresql/$MAJOR_VER/lib "$VARTMPDIR"
+ fi
+ fi
+ done
+}
+
+postinst_check_catversion()
+{
+ MAJOR_VER="$1"
+
+ CATFILE="/usr/share/postgresql/$MAJOR_VER/catalog_version"
+ [ -f "$CATFILE" ] || return 0 # file introduced in 9.6
+ NEW_CATVERSION="$(cat $CATFILE)"
+ [ -z "$NEW_CATVERSION" ] && return
+
+ PGCONTROLDATA="/usr/lib/postgresql/$MAJOR_VER/bin/pg_controldata"
+ [ -x "$PGCONTROLDATA" ] || return 0
+
+ for cluster in $(pg_lsclusters -h | awk "/^$MAJOR_VER / { print \$2 }"); do
+ pgdata=$(pg_conftool -s $MAJOR_VER $cluster show data_directory) || continue
+ [ -d "$pgdata" ] || continue
+
+ DB_CATVERSION=$(LC_ALL=C $PGCONTROLDATA $pgdata | sed -ne 's/^Catalog version number: *\([0-9]\+\)/\1/p')
+ [ -z "$DB_CATVERSION" ] && continue
+ [ "$DB_CATVERSION" = "$NEW_CATVERSION" ] && continue
+
+ VARTMPDIR="/var/tmp/postgresql-$MAJOR_VER-$DB_CATVERSION"
+ [ -d "$VARTMPDIR" ] || continue
+ [ -O "$VARTMPDIR" ] || continue # test if owned by root
+
+ # tell the user about it
+ cat <<-EOF
+ Cluster $MAJOR_VER $cluster needs upgrading due to catalog version change:
+ pg_renamecluster ${MAJOR_VER} ${cluster} ${cluster}.old
+ pg_upgradecluster ${MAJOR_VER} ${cluster}.old --rename ${cluster} -m upgrade -v ${MAJOR_VER} --old-bindir=${VARTMPDIR}/bin
+ pg_dropcluster ${MAJOR_VER} ${cluster}.old
+ rm -rf ${VARTMPDIR}
+ EOF
+ db_fset postgresql-common/catversion-bump seen false
+ db_subst postgresql-common/catversion-bump version $MAJOR_VER
+ db_subst postgresql-common/catversion-bump cluster $cluster
+ db_subst postgresql-common/catversion-bump db_catversion $DB_CATVERSION
+ db_subst postgresql-common/catversion-bump new_catversion $NEW_CATVERSION
+ db_subst postgresql-common/catversion-bump vartmpdir $VARTMPDIR
+ db_input high postgresql-common/catversion-bump || true
+ db_go || true
+ done
+}
+
+# start debconf if we are in the server's postinst (can't run from a function)
+if [ "${DPKG_MAINTSCRIPT_NAME:-}" = "postinst" ] && [ "$1" = "configure" ]; then
+ case $DPKG_MAINTSCRIPT_PACKAGE in
+ postgresql-[89].?|postgresql-[1-9]?)
+ . /usr/share/debconf/confmodule
+ ;;
+ esac
+fi