SUSE-SU-2018:1695-1

https://www.postgresql.org/about/news/1851/
https://www.postgresql.org/docs/current/static/release-9-6-9.html

A dump/restore is not required for those running 9.6.X. However, if you use the adminpack extension, you should update it as per the first changelog entry below. Also, if the function marking mistakes mentioned in the second and third changelog entries below affect you, you will want to take steps to correct your database catalogs.

Security issue fixed:

CVE-2018-1115: Remove public execute privilege from contrib/adminpack's pg_logfile_rotate() function pg_logfile_rotate() is a deprecated wrapper for the core function pg_rotate_logfile(). When that function was changed to rely on SQL privileges for access control rather than a hard-coded superuser check, pg_logfile_rotate() should have been updated as well, but the need for this was missed. Hence, if adminpack is installed, any user could request a logfile rotation, creating a minor security issue. After installing this update, administrators should update adminpack by performing ALTER EXTENSION adminpack UPDATE in each database in which adminpack is installed. (bsc#1091610)

References

Affected packages

SUSE:Linux Enterprise Desktop 12 SP3

postgresql96

Package

Name: postgresql96
Purl: pkg:rpm/suse/postgresql96&distro=SUSE%20Linux%20Enterprise%20Desktop%2012%20SP3

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0 Unknown introduced version / All previous versions are affected

Fixed

9.6.9-3.19.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "9.6.9-3.19.1",
            "libpq5":  "9.6.9-3.19.1",
            "libpq5-32bit":  "9.6.9-3.19.1",
            "postgresql96":  "9.6.9-3.19.1"
        }
    ]
}

Database specific

source

"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2018:1695-1.json"

postgresql96-libs

Package

Name: postgresql96-libs
Purl: pkg:rpm/suse/postgresql96-libs&distro=SUSE%20Linux%20Enterprise%20Desktop%2012%20SP3

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0 Unknown introduced version / All previous versions are affected

Fixed

9.6.9-3.19.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "9.6.9-3.19.1",
            "libpq5":  "9.6.9-3.19.1",
            "libpq5-32bit":  "9.6.9-3.19.1",
            "postgresql96":  "9.6.9-3.19.1"
        }
    ]
}

Database specific

source

"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2018:1695-1.json"

SUSE:Linux Enterprise Server 12 SP3

postgresql96

Package

Name: postgresql96
Purl: pkg:rpm/suse/postgresql96&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP3

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0 Unknown introduced version / All previous versions are affected

Fixed

9.6.9-3.19.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "9.6.9-3.19.1",
            "libpq5":  "9.6.9-3.19.1",
            "libpq5-32bit":  "9.6.9-3.19.1",
            "postgresql96":  "9.6.9-3.19.1",
            "postgresql96-contrib":  "9.6.9-3.19.1",
            "postgresql96-docs":  "9.6.9-3.19.1",
            "postgresql96-server":  "9.6.9-3.19.1"
        }
    ]
}

Database specific

source

"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2018:1695-1.json"

postgresql96-libs

Package

Name: postgresql96-libs
Purl: pkg:rpm/suse/postgresql96-libs&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP3

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0 Unknown introduced version / All previous versions are affected

Fixed

9.6.9-3.19.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "9.6.9-3.19.1",
            "libpq5":  "9.6.9-3.19.1",
            "libpq5-32bit":  "9.6.9-3.19.1",
            "postgresql96":  "9.6.9-3.19.1",
            "postgresql96-contrib":  "9.6.9-3.19.1",
            "postgresql96-docs":  "9.6.9-3.19.1",
            "postgresql96-server":  "9.6.9-3.19.1"
        }
    ]
}

Database specific

source

"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2018:1695-1.json"

SUSE:Linux Enterprise Server for SAP Applications 12 SP3

postgresql96

Package

Name: postgresql96
Purl: pkg:rpm/suse/postgresql96&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP3

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0 Unknown introduced version / All previous versions are affected

Fixed

9.6.9-3.19.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "9.6.9-3.19.1",
            "libpq5":  "9.6.9-3.19.1",
            "libpq5-32bit":  "9.6.9-3.19.1",
            "postgresql96":  "9.6.9-3.19.1",
            "postgresql96-contrib":  "9.6.9-3.19.1",
            "postgresql96-docs":  "9.6.9-3.19.1",
            "postgresql96-server":  "9.6.9-3.19.1"
        }
    ]
}

Database specific

source

"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2018:1695-1.json"

postgresql96-libs

Package

Name: postgresql96-libs
Purl: pkg:rpm/suse/postgresql96-libs&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP3

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0 Unknown introduced version / All previous versions are affected

Fixed

9.6.9-3.19.1

Ecosystem specific

{
    "binaries":  [
        {
            "libecpg6":  "9.6.9-3.19.1",
            "libpq5":  "9.6.9-3.19.1",
            "libpq5-32bit":  "9.6.9-3.19.1",
            "postgresql96":  "9.6.9-3.19.1",
            "postgresql96-contrib":  "9.6.9-3.19.1",
            "postgresql96-docs":  "9.6.9-3.19.1",
            "postgresql96-server":  "9.6.9-3.19.1"
        }
    ]
}

Database specific

source

"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2018:1695-1.json"

SUSE:Linux Enterprise Software Development Kit 12 SP3

postgresql96-libs

Package

Name: postgresql96-libs
Purl: pkg:rpm/suse/postgresql96-libs&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP3

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0 Unknown introduced version / All previous versions are affected

Fixed

9.6.9-3.19.1

Ecosystem specific

{
    "binaries":  [
        {
            "postgresql96-devel":  "9.6.9-3.19.1"
        }
    ]
}

Database specific

source

"https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2018:1695-1.json"