New upstream microreleases 9.5.23 10.14 and 12.4

Xenial
PPA: https://launchpad.net/~ci-train-ppa-service/+archive/ubuntu/4218/+packages
MP: https://code.launchpad.net/~paelzer/ubuntu/+source/postgresql-9.5/+git/postgresql-9.5/+merge/389591

Bionic
PPA: https://launchpad.net/~ci-train-ppa-service/+archive/ubuntu/4219/+packages
MP: https://code.launchpad.net/~paelzer/ubuntu/+source/postgresql-10/+git/postgresql-10/+merge/389589

Focal
PPA: https://launchpad.net/~ci-train-ppa-service/+archive/ubuntu/4220/+packages
MP: https://code.launchpad.net/~paelzer/ubuntu/+source/postgresql-12/+git/postgresql-12/+merge/389590

Bionic tests are all good
https://bileto.ubuntu.com/excuses/4219/bionic.html

Xenial tests are all good as well, just three fails
- https://bileto.ubuntu.com/excuses/4218/xenial.html

Those three are covered by overrides:
- pitti:60:force-badtest bareos/14.2.6-3
- ubuntu-sru:71:force-badtest libreoffice/1:5.1.6~rc2-0ubuntu1~xenial10/i386
- pitti:16:force-badtest pgpool2/3.4.3-1

Focal is only mostly good.
The majority of tests is fine at
https://bileto.ubuntu.com/excuses/4220/focal.html

Of the remaining ones two are known overrides/resets:
- ubuntu-release:7143:force-badtest oca-core/all/i386
- ubuntu-release:54:force-reset-test diaspora-installer/0.7.6.1+debian1

But the postgresql-12 tests themselves failed
=> https://objectstorage.prodstack4-5.canonical.com/v1/AUTH_77e2ada1e7a84929a74ba3b87153c0ac/autopkgtest-focal-ci-train-ppa-service-4220/focal/amd64/p/postgresql-12/20200820_194445_7401b@/log.gz

The issue seems locally reproducible and needs a further look.

Thanks to myon I found this which will need to go along Focal.
https://salsa.debian.org/postgresql/postgresql-common/-/commit/301ab209d65e8c5873bf4fadd70810dee9994543
Because of
https://www.postgresql.org/message-id/20200811111544.GB4154579%40msg.df7cb.de

So an postgresql-common upload along will be needed for Focal.

Additional MP
https://code.launchpad.net/~paelzer/ubuntu/+source/postgresql-12/+git/postgresql-12/+merge/389590

Part of the Focal PPA now, tests will be restarted once the build is complete.

Ok,
the postgresql-common fixes fix the tests as expected.

Focal is now ready as well
Remaining issues in diaspora-installer, mediawiki, oca-core, postgresql-12@i386, resource-agents@i386 are all known force-badtest/reset entries.

ubuntu-release:10422:force-badtest resource-agents/all/i386 multipath-tools/all/i386
ubuntu-release:10292:force-badtest postgresql-12/all/i386
ubuntu-release:5798:force-badtest mediawiki/all/i386
ubuntu-release:7143:force-badtest oca-core/all/i386
ubuntu-release:54:force-reset-test diaspora-installer/0.7.6.1+debian1
ubuntu-release:1503:force-badtest diaspora-installer/all/i386

This bug was fixed in the package postgresql-9.5 - 9.5.23-0ubuntu0.16.04.1

---------------
postgresql-9.5 (9.5.23-0ubuntu0.16.04.1) xenial-security; urgency=medium

  * New upstream release (LP: #1892335).
    - Make contrib modules' installation scripts more secure (Tom Lane)

      Attacks similar to those described in CVE-2018-1058 could be carried out
      against an extension installation script, if the attacker can create
      objects in either the extension's target schema or the schema of some
      prerequisite extension. Since extensions often require superuser
      privilege to install, this can open a path to obtaining superuser
      privilege. To mitigate this risk, be more careful about the search_path
      used to run an installation script; disable check_function_bodies within
      the script; and fix catalog-adjustment queries used in some contrib
      modules to ensure they are secure. Also provide documentation to help
      third-party extension authors make their installation scripts secure.
      This is not a complete solution; extensions that depend on other
      extensions can still be at risk if installed carelessly.
      CVE-2020-14350

    - Details about these and many further changes can be found at:
      https://www.postgresql.org/docs/9.5/static/release-9-5-22.html
      https://www.postgresql.org/docs/9.5/static/release-9-5-23.html

 -- Christian Ehrhardt <email address hidden> Thu, 20 Aug 2020 11:29:10 +0200

This bug was fixed in the package postgresql-10 - 10.14-0ubuntu0.18.04.1

---------------
postgresql-10 (10.14-0ubuntu0.18.04.1) bionic-security; urgency=medium

  * New upstream release (LP: #1892335).
    - Set a secure search_path in logical replication walsenders and apply
      workers (Noah Misch)

      A malicious user of either the publisher or subscriber database could
      potentially cause execution of arbitrary SQL code by the role running
      replication, which is often a superuser. Some of the risks here are
      equivalent to those described in CVE-2018-1058, and are mitigated in
      this patch by ensuring that the replication sender and receiver execute
      with empty search_path settings. (As with CVE-2018-1058, that change
      might cause problems for under-qualified names used in replicated
      tables' DDL.) Other risks are inherent in replicating objects that
      belong to untrusted roles; the most we can do is document that there is
      a hazard to consider.
      CVE-2020-14349

    - Make contrib modules' installation scripts more secure (Tom Lane)

      Attacks similar to those described in CVE-2018-1058 could be carried out
      against an extension installation script, if the attacker can create
      objects in either the extension's target schema or the schema of some
      prerequisite extension. Since extensions often require superuser
      privilege to install, this can open a path to obtaining superuser
      privilege. To mitigate this risk, be more careful about the search_path
      used to run an installation script; disable check_function_bodies within
      the script; and fix catalog-adjustment queries used in some contrib
      modules to ensure they are secure. Also provide documentation to help
      third-party extension authors make their installation scripts secure.
      This is not a complete solution; extensions that depend on other
      extensions can still be at risk if installed carelessly.
      CVE-2020-14350

    - Details about these and many further changes can be found at:
      https://www.postgresql.org/docs/10/static/release-10-13.html
      https://www.postgresql.org/docs/10/static/release-10-14.html

 -- Christian Ehrhardt <email address hidden> Thu, 20 Aug 2020 11:29:28 +0200

This bug was fixed in the package postgresql-12 - 12.4-0ubuntu0.20.04.1

---------------
postgresql-12 (12.4-0ubuntu0.20.04.1) focal-security; urgency=medium

  * New upstream release (LP: #1892335).
    - Set a secure search_path in logical replication walsenders and apply
      workers (Noah Misch)

      A malicious user of either the publisher or subscriber database could
      potentially cause execution of arbitrary SQL code by the role running
      replication, which is often a superuser. Some of the risks here are
      equivalent to those described in CVE-2018-1058, and are mitigated in
      this patch by ensuring that the replication sender and receiver execute
      with empty search_path settings. (As with CVE-2018-1058, that change
      might cause problems for under-qualified names used in replicated
      tables' DDL.) Other risks are inherent in replicating objects that
      belong to untrusted roles; the most we can do is document that there is
      a hazard to consider.
      CVE-2020-14349

    - Make contrib modules' installation scripts more secure (Tom Lane)

      Attacks similar to those described in CVE-2018-1058 could be carried out
      against an extension installation script, if the attacker can create
      objects in either the extension's target schema or the schema of some
      prerequisite extension. Since extensions often require superuser
      privilege to install, this can open a path to obtaining superuser
      privilege. To mitigate this risk, be more careful about the search_path
      used to run an installation script; disable check_function_bodies within
      the script; and fix catalog-adjustment queries used in some contrib
      modules to ensure they are secure. Also provide documentation to help
      third-party extension authors make their installation scripts secure.
      This is not a complete solution; extensions that depend on other
      extensions can still be at risk if installed carelessly.
      CVE-2020-14350

    - Details about these and many further changes can be found at:
      https://www.postgresql.org/docs/10/static/release-12-3.html
      https://www.postgresql.org/docs/10/static/release-12-4.htm

 -- Christian Ehrhardt <email address hidden> Thu, 20 Aug 2020 11:29:14 +0200