Row-level security on subscriber tables causes replication conflicts

Enabled row-level security (RLS) on subscriber tables causes logical replication conflicts when the subscription owner is subject to RLS policies, regardless of whether the policy would normally reject the operation. This affects INSERT, UPDATE, DELETE, and TRUNCATE operations.

Review row-level security policies on subscriber tables. Either disable RLS on tables receiving logical replication, exclude the subscription owner from RLS policies, or grant the subscription owner privileges that bypass RLS. Check subscriber server logs for permission-related replication conflicts.