pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

Published 20 hours ago • verified publisher icon dimitri

Fix reading from read-only databases with recent versions of postmodern

Open p12tic opened this issue 4 years ago • 1 comments

Currently copying from read-only databases breaks with recent-enough version of the postmodern library.

https://github.com/marijnh/Postmodern/pull/163 changes the default transaction syntax from BEGIN to BEGIN TRANSACTION ISOLATION LEVEL READ COMMITTED READ WRITE (which corresponds to read-committed-rw in postmodern). This PR changes the isolation level to read-committed-ro for read operations.

p12tic avatar Nov 30 '20 21:11 p12tic

Running into this issue with a ReadOnly RDS standby instance. Any other workaround for this?

mcg avatar May 12 '23 19:05 mcg