I have a logical replication where I want to replicate only one schema. This schema has auditing of every customer, so a thousand of tables, one for each customer CREATE PUBLICATION pub_a FOR TABLES IN SCHEMA audit; All worked fine, it copied all tables to subscriber, except one. That table has 8GB and it copied 5GB. That copy has been frozen since yesterday, as you can see.
What can I do to solve this ? This select returns two records, first for processing WAL being generated and the second problematic record. # select usename, application_name, state_change, wait_event_type, wait_event, state, query, backend_type from pg_stat_activity where usename = 'replication_user'; -[ RECORD 1 ]----+---------------------------------------------------------------------------------------------------------------------------------------------------------------- usename | replication_user application_name | sub_a state_change | 2025-12-05 08:37:28.05245-03 wait_event_type | [null] wait_event | [null] state | active query | START_REPLICATION SLOT "sub_a" LOGICAL 3C14/6C6EA898 (proto_version '4', streaming 'parallel', origin 'any', publication_names '"pub_a"') backend_type | walsender -[ RECORD 2 ]----+---------------------------------------------------------------------------------------------------------------------------------------------------------------- usename | replication_user application_name | pg_14944054_sync_29806_7565484157933843059 state_change | 2025-12-04 08:17:14.73826-03 wait_event_type | Client wait_event | ClientWrite state | active query | COPY audit.audit_0749 (audit_id, table_schema, table_name, primary_key, user_id, audit_action, audit_date_time, transaction_number, old, new) TO STDOUT backend_type | walsender regards Marcos
