
#Aws postgresql extensions code
| id | code | article | name | department | | oid | table_schema | table_name | row_estimate | total_bytes | index_bytes | toast_bytes | table_bytes | total | index | toast | table | "article_id_key" UNIQUE CONSTRAINT, btree # \i table_size.sql | department | character varying(4) | | | | | code | character varying(10) | | not null | | | id | integer | | not null | nextval('article_id_seq'::regclass) | | Column | Type | Collation | Nullable | Default | The table is 100Gb in size and is non-partitioned.įrom generate_series(1, 1000000) # \d article

#Aws postgresql extensions series
The company updated both Aurora PostgreSQL and RDS for PostgreSQL to resolve the issue and also deprecated a series of minor versions, preventing users from creating new instances with those versions.+-+-+
#Aws postgresql extensions Patch
An initial patch was released on December 14, but roughly three months were needed to deploy the fix to all customers. The researcher reported the vulnerability to Amazon on December 9, 2021. The credentials could only be used to access resources associated with the Aurora database cluster from which the credentials were retrieved,” AWS notes. “They would not be able to use the credentials to access internal RDS services or move between databases or AWS accounts. A privileged, authenticated user able to trigger the bug could use the leaked credentials to gain elevated access to database resources. The log_fdw extension, AWS also notes, is pre-installed in both Aurora PostgreSQL and Amazon RDS for PostgreSQL. “No cross-customer or cross-cluster access was possible however, highly privileged local database users who could exercise this issue could potentially have gained additional access to data hosted in their cluster or read files within the operating system of the underlying host running their database,” AWS explains. While searching for potential vulnerabilities in the Amazon Aurora engine, Lightspin researcher Gafnit Amiga discovered that it was possible to bypass the log_fdw extension validation and gain access to some system files, including files that contained internal credentials.Īccording to AWS, the leaked credentials were “specific to their Aurora cluster,” meaning that they could not be used to compromise other clusters or customers.


The addressed security issue was identified in the Aurora PostgreSQL engine, more specifically in the third-party open-source PostgreSQL extension “log_fdw,” which allows a user to leverage the SQL interface to access the database engine log, as well as to build foreign tables. Amazon Web Services (AWS) on Monday announced that it recently addressed a vulnerability in Amazon Relational Database Service (RDS) that could lead to the exposure of internal credentials.Īmazon RDS is a managed database service that offers support for several database engines, including Amazon Aurora, AWS’s own database engine, which offers support for MySQL and PostgreSQL.
