/usr/share/postgresql-common/supported-versions is in postgresql-client-common 154.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 | #!/bin/sh
# print a list of PostgreSQL versions that are supported for the platform this
# script runs on.
# Note: Newer installed versions than the highest one listed here are always
# considered supported, so that backports will not cause an "obsolete" warning.
#
# /usr/share/postgresql-common/supported-versions decides which PostgreSQL
# server versions are supported. This information is used
# 1) for notifying users of obsolete versions, suggesting to upgrade
# 2) by postgresql-common itself (in debian/rules) to determine the
# dependencies of the postgresql meta packages (default version), and to
# generate the list of postgresql-server-dev-* packages
# postgresql-server-dev-all depends on
# 3) by the pg_buildext tool to decide which server versions to build extension
# modules for
#
# The *last* version returned here will be considered the default version, the
# remaining lines list other supported versions in an undefined order.
#
# The environment variable PG_SUPPORTED_VERSIONS, and the files
# ~/.pg_supported_versions and /etc/postgresql-common/supported_versions (in
# that order) can be used to override the defaults. (Tokens separated by
# newlines.)
#
# Recognized tokens:
# default: use the appropiate defaults for the current distribution and release
# (as determined by os-release or lsb_release)
# debian [release]: use Debian defaults
# debian-backports [release]: use Debian Backports defaults
# ubuntu [release]: use Ubuntu defaults
# pgdg [release]: use defaults for apt.postgresql.org
# installed: consider all installed versions supported (determined by
# postgresql-server-dev-X.Y packages)
# X.Y: consider this version supported
#
# (C) 2005-2013 Martin Pitt <mpitt@debian.org>
# (C) 2012-2013 Christoph Berg <myon@debian.org>
set -eu
DEFAULT="9.3"
# functions
get_release() {
# If we have /etc/os-release, use it
if [ -r /etc/os-release ]; then
. /etc/os-release
DISTRO="${ID:-unknown}" # "unknown" will throw an error in default()
RELEASE="${VERSION_ID:-unstable}" # this field is not necessarily always there, assume testing/unstable
# fall back to lsb_release
elif type lsb_release >/dev/null 2>/dev/null; then
DISTRO="`lsb_release -is`"
RELEASE="`lsb_release -rs`"
else
echo "supported_versions: WARNING: /etc/os-release and lsb_release not present, unknown distribution" >&2
/bin/echo -e "$DEFAULT"
fi
}
default() {
case "$DISTRO" in
[uU]buntu)
ubuntu "$RELEASE"
;;
[dD]ebian)
debian "$RELEASE"
;;
*)
echo "supported_versions: WARNING! Unknown distribution: $DISTRO" >&2
echo "Please submit this as a bug report to your distribution." >&2
/bin/echo -e "$DEFAULT"
;;
esac
}
ubuntu() {
case "$1" in
8.04 | 8.10 | 9.04)
/bin/echo -e "8.3\n8.4"
;;
9.10|10.04|10.10|11.04)
/bin/echo -e "8.4"
;;
11.10|12.04|12.10|13.04|13.10)
/bin/echo -e "9.1"
;;
14.04)
/bin/echo -e "9.3"
;;
*)
echo "supported_versions: WARNING: Unknown Ubuntu release: $1" >&2
/bin/echo -e "$DEFAULT"
;;
esac
}
debian() {
case "$1" in
5.0*) # Lenny
/bin/echo -e "8.3"
;;
6.0*) # Squeeze
/bin/echo -e "8.4"
;;
7|7.*) # Wheezy
/bin/echo -e "9.1"
;;
8|8.*) # Jessie
/bin/echo -e "9.3"
;;
testing | unstable)
/bin/echo -e "9.3"
;;
*)
echo "supported_versions: WARNING: Unknown Debian release: $1" >&2
/bin/echo -e "$DEFAULT"
;;
esac
}
debian_backports() {
case "$1" in
5.0*) # Lenny
/bin/echo -e "8.3"
;;
6.0*) # Squeeze
/bin/echo -e "8.4\n9.1"
;;
7|7.*) # Wheezy
/bin/echo -e "9.1"
;;
testing | unstable)
/bin/echo -e "9.3"
;;
*)
echo "supported_versions: WARNING: Unknown Debian release: $1" >&2
/bin/echo -e "$DEFAULT"
;;
esac
}
pgdg() {
case "$1" in
testing | unstable)
# including beta versions
/bin/echo -e "8.4\n9.0\n9.1\n9.2\n9.3"
;;
*)
# usually no beta versions here
/bin/echo -e "8.4\n9.0\n9.1\n9.2\n9.3"
;;
esac
}
installed() {
dpkg -l 'postgresql-server-dev-[1-9].*' | \
sed -ne 's/^ii *postgresql-server-dev-\([^ ]*\).*/\1/p'
}
# main
if [ "${PG_SUPPORTED_VERSIONS:-}" ] ; then
SUPPORTED_VERSIONS="$PG_SUPPORTED_VERSIONS"
elif [ -f ${HOME:-}/.pg_supported_versions ] ; then
SUPPORTED_VERSIONS="$(cat ${HOME:-}/.pg_supported_versions)"
elif [ -f ${PGSYSCONFDIR:-/etc/postgresql-common}/supported_versions ] ; then
SUPPORTED_VERSIONS="$(cat ${PGSYSCONFDIR:-/etc/postgresql-common}/supported_versions)"
else
SUPPORTED_VERSIONS="default"
fi
echo "$SUPPORTED_VERSIONS" | while read version release; do
COMMENT="#"
case $version in
"") ;;
$COMMENT*) ;;
default)
get_release
default
;;
debian)
get_release
debian "${release:-$RELEASE}"
;;
debian-backports)
get_release
debian_backports "${release:-$RELEASE}"
;;
ubuntu)
get_release
ubuntu "${release:-$RELEASE}"
;;
pgdg) # apt.postgresql.org
get_release
pgdg "${release:-$RELEASE}"
;;
installed)
installed
;;
*)
/bin/echo -e "$version"
;;
esac
done
exit 0
|