CVE-2017-12172 Amazon Linux Security Advisory for postgresql95,postgresql96: ALAS-2017-930

Privilege escalation flaws were found in the initialization scripts of PostgreSQL. A remote attacker with access to the postgres user account could use these flaws to obtain root access on the server machine.(CVE-2017-12172 )

INSERT CONFLICT DO UPDATE commands in PostgreSQL disclose table contents that the invoker lacks privilege to read. These exploits affect only tables where the attacker lacks full read access but has both INSERT and UPDATE privileges. Exploits bypass row level security policies and lack of SELECT privilege.(CVE-2017-15099 )

Invalid json_populate_recordset or jsonb_populate_recordset function calls in PostgreSQL can crash the server or disclose a few bytes of server memory.(CVE-2017-15098 )

QID Detection Logic:
This authenticated QID verifies if the version of the following files is lesser than:
9.5.10-1.77.amzn1: postgresql95-plperl,postgresql95-libs,postgresql95-debuginfo,postgresql95-devel,postgresql95-test,postgresql95-contrib,postgresql95-docs,postgresql95,postgresql95-plpython26,postgresql95-static,postgresql95-server,postgresql95-plpython27
9.6.6-1.79.amzn1: postgresql96-plperl,postgresql96-plpython26,postgresql96-plpython27,postgresql96-devel,postgresql96-contrib,postgresql96-static,postgresql96-docs,postgresql96-libs,postgresql96-debuginfo,postgresql96-test,postgresql96,postgresql96-server

Allows unauthorized disclosure of information; allows unauthorized modification; allows disruption of service.

Please refer to Amazon advisory ALAS-2017-930 for affected packages and patching details, or update with your package manager.

Patch:
Following are links for downloading patches to fix the vulnerabilities:

ALAS-2017-930