pg_dump fails when a table is in ACCESS SHARE MODE

Hello All,

I am facing some problems while taking logical backup of my database using
pg_dump. We have set up our infrastructure such that the logical backups
are taken on our DR. Our intention here is to avoid substantial load on our
primary server. We also pause and play wal files using pg_wal_replay_pause
and pg_wal_replay_resume before and after pg_dump. However, at the time of
pausing the wal replay, if there is a table under ACCESS SHARE MODE, the
pg_dump cannot complete the backup.

Can anyone suggest any better solution to take a logical backup using
pg_dump where the table lock doesn't result in failure of the logical
backup?

PS: we are using PostgreSQL 10.12

Thanks,
Viral Shah
Data Analyst, Nodal Exchange LLC
viralshah009(at)gmail(dot)com | (240) 645 7548