postgresql-16-150400.4.9.2

- Interlock version and release of all noarch packages except for
  the postgresql-docs.

- Bump default to 16 on Factory.

- Bump major version to prepare for PostgreSQL 16, but keep
  default at 15 for now on Factory.

- boo#1122892: Add a sysconfig variable for initdb.

- Overhaul postgresql-README.SUSE and move it from the binary
  package to the noarch wrapper package.
- bsc#1179231: Add an explanation for the /tmp -> /run/postgresql
  move and permission change.
- Add postgresql-README as a separate source file.

- bsc#1209208: Drop hard dependency on systemd

- bsc#1206796: Refine the distinction of where to use sysusers and
  use bcond to have the expression only in one place.

- riscv64 does not have llvm support yet,
  adapt the %postgresql_has_llvm macro accordingly.

- avoid bashisms in /bin/sh based startup script

- Bump to postgresql 15

- Change to systemd-sysusers

- Bump version to 14, leave default at 13.

- Fix the pg_server_requires macro on older rpm versions (SLE-12).

- Avoid a dependency on awk in postgresql-script.

- Move the dependency of llvmjit-devel on clang and llvm to the
  implementation packages where we can depend on the correct
  versions.

- fix postgresql_has_llvm usage

- First round of changes to make it easier to build extensions for
  - add postgresql-llvmjit-devel subpackage:
    This package will pull in clang and llvm if the distro has a
    recent enough version, otherwise it will just pull
    postgresql-server-devel.
  - add postgresql macros to the postgresql-server-devel package
    those cover all the variables from pg_config and some macros
    to remove repitition from the spec files

- Bump version to 14.
- Bump default to 14 on Factory and future SPs.

- Re-enable build of the llvmjit subpackage on SLE, but it will
  only be delivered on PackageHub for now (boo#1183118).

- Bump default version to 13 for SLE-15-SP3.

- Bump major version to 13.
- Bump default version to 13 in OBS.

- We also transfer PostgreSQL 9.4.26 to the new package layout in
  SLE12-SP2 and newer. Reflect this in the conflict with
  postgresql94.

- Also conflict with PostgreSQL versions before 9.
- Conflicting with older versions is not limited to SLE.

- Bump version to 12.0.1, so that the binary packages also have
  a cut-point to conflict with.

- Disable LLVM on SLE (bsc#1172274).
- Conflict with versions of the binary packages prior to the
  May 2020 update, because we changed the package layout at that
  point and need a clean cutover.

- Bump package version to 12, but leave default at 10 for
  SLE-15 and SLE-15-SP1.

- Fix a mistake in the creation of /var/lib/pgsql/.bash_profile
  with the tmpfiles mechanism (bsc#1159335).

- Sync ownership of /run/postgresql in the file list with tmpfiles.

- bump to 12

- Use the correct content for .bash_profile (boo#1153168).

- Stop shipping SUSEfirewall2 config files (bsc#1151591).
- Fix installation of bash_profile for SLE11 (pre systemd).

- Drop use of $FIRST_ARG in .spec
  The use of $FIRST_ARG was probably required because of the
  %service_* rpm macros were playing tricks with the shell positional
  parameters. This is bad practice and error prones so let's assume
  that no macros should do that anymore and hence it's safe to assume
  that positional parameters remains unchanged after any rpm macro
  call.

- Change the persmissions for /var/run/postgresql to 1775, so that
  the directory can only be used by users in the postgres group
  (bsc#1123886).

- Move bash profile out of /var/lib to allow transactional updates
  (bsc#1100397).
- Use /run/postgresql instead of /var/run/postgresql in %ghost and
  postgresql-tmpfiles.conf to avoid rpmlint warnings and errors.

- add /var/run/postgresql to the filelist. as %ghost for systemd
  systems and directly for non systemd systems

- fix the unexpanded macro in the description of server-devel

- Also bump the default package to 11.

- add server-devel and llvmjit package file sections

- Add the new subpackages server-devel and llvmjit that were
  introduced with postgresql11.

- bump to 11

- Change the persmissions for /var/run/postgresql to 1775, so that
  the directory can only be used by users in the postgres group
  (bsc#1123886).
- Move bash profile out of /var/lib to allow transactional updates
  (bsc#1100397).
- Sync spec file with Factory as far as applicable.

- Require update-alternatives by postgresql: one of the main
  scripts in use is install-alternatives, which calls u-a.

- Put POSTGRES_LANG into LC_ALL instead of LANG to retain the
  previous behaviour of that variable (boo#1077027).

- postgresql-script: /etc/sysconfig/language is deprecated, use the
  locale that was inherited from systemd instead for initializing
  a new database instance (boo#1074988).

- add provides for all the pkgconfig() provides you also find in
  the postgresqlXY-devel packages. then we automatically will pull
  postgresql-devel which in turn will pull our default
  postgresqlXY-devel package. (boo#1071971)

- Replace references to /var/adm/fillup-templates with new
  %_fillupdir macro (boo#1069468)

- instead of hardcoding version 10, just check if the prio is
  smaller than 80.

- simplify the postgresql-install-alternatives to only require the
  pg version and go from there.
  supported calls of the script are:
  /usr/share/postgresql/install-alternatives postgresqlXY
  /usr/share/postgresql/install-alternatives XY
  where XY can currently be: 92 93 94 95 96 10

- CVE-2017-14798, bsc#1062722: Fix LPE via postgres init script.
  This only affected SysV-init based systems (i.e. SLE11).

- postgresql-test was missing a %files section.

- Move the start/stop script to /usr/share/postgresql
- Add a script for handling update-alternatives as subpackages
  get installed/uninstalled, so that the implementation packages
  don't have to repeat the logic (postgresql-install-alternatives).
- Add the postgresql-test subpackage.
- Fix some dependencies.
- Save the enabled and running state when upgrading from the
  obsolete postgresql-init package.

- properly guard the systemd macro in %pre server so it wont be
  used on sle11
- add Requires(pre) so we have groupadd/useradd available

- Refine the dependencies between the "dummy" packages and the
  actual implementation of PostgreSQL. The dummy packages now
  require an arbitrary implementation and recommend the default
  version.
- Move the contents of postgresql-init to the server package.

- bump to 10

- Bump version and defaultpackage to 9.6 in SLE12 (bsc#1046324).

- Bump version and defaultpackage to 9.6 in Factory.

- Move ~postgres/.bash_profile to postgresql-server to avoid a
  file conflict between the versioned server packages.

- Bump version and defaultpackage to 9.4. in SLE (bnc#941886)

- Bump version and defaultpackage to 9.4 in Factory.

- Bump version and defaultpackage to 9.3.