Interacting with RDS as a true superuser (rdsadmin) or how to grant user access to modify pg_catalog tables?

0

Hello, I'm currently using RDS Postgres (Postgres v14 if it matters) and I've hit an issue with corrupted content of pg_catalog tables (pg_class in this case) rendering the DB mostly unusable. I'm stuck on error

pg_dump: error: schema with OID xxxxxxx does not exist

when trying to dump a schema.

The master user for the instance however does not have permissions to modify any of the tables' content, nor is it possible to grant him the privileges to do so.

Is there a way around this?

I understand rdsadmin is only used internally by RDS to manage the instance and there is a reason for this limitation, but is there a workaround to handle this scenario without having to replace the whole RDS instance?

Thanks!

1개 답변
0

Hi there.

You should open a support case to review what is causing this corruption. There is no workaround for the permissions issue. Your best option is the support case.

I hope this helps.

profile pictureAWS
전문가
답변함 8달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠