The Version Number Is Not the Territory

A PostgreSQL 14 instance on Amazon RDS produced an error message that community PostgreSQL 14 is architecturally incapable of generating — specifically a 'cannot SET ROLE' error from the logical replication apply worker. The root cause: RDS PostgreSQL is a patched fork that backported the apply-time role-switching behavior from PostgreSQL 16 into its v14 build, without any documentation in upstream release notes. The error occurs when replicated tables are owned by the reserved role 'rds_superuser', which nothing can SET ROLE to. The fix is to reassign those tables to an ordinary application role using ALTER TABLE ... OWNER TO. The broader lesson: on managed PostgreSQL platforms, the major version number does not fully describe the engine's behavior — providers carry invisible patches that can produce impossible-looking errors.

Nguồn: https://postgr.es/p/9pe. 8sync News chỉ tóm tắt và dẫn link; bản quyền nội dung thuộc tác giả và nguồn gốc.

Đề xuất cho bạn

Lobsters39 Hot3 phút2 ngày trướcAITop

Postgres Is Enough

Thư mục này lập luận rằng PostgreSQL có thể thay thế hầu hết các cơ sở dữ liệu chuyên dụng …

#postgresql#microservices#redis