SELECT query on pg_catalog.pg_largeobject fails with a permission error

Question

Hi,

A framework I use requires access to pg_catalog.pg_largeobject, but the master user doesn't seem to have access to the table.
`GRANT SELECT ON pg_catalog.pg_largeobject TO $MASTER_USER` also fails with "ERROR: role $MASTER_USER does not exist"

Is there any way to access the table?
I know there are some tables the master user can't access, such as pg_authid, but I want to confirm the table is one of them.

RDS: Aurora Serverless v1 PostgreSQL10

Thanks

Divyam Chauhan · Accepted Answer

Unfortunately, Aurora Serverless v1 PostgreSQL 10 does not support access to the pg_largeobject table. This table is only available on Aurora PostgreSQL v11 and above, and Aurora Serverless does not support v11 or higher. You'll need to upgrade to Aurora Serverless v2 or use Aurora PostgreSQL v11 if you need access to this table.

SELECT query on pg_catalog.pg_largeobject fails with a permission error

Add your answer

Relevant content