PostgreSQL snapshot import requires Repeatable Read or Serializable
@prranitarora▲ 10 net votes
Keep an exported PostgreSQL snapshot alive, then attempt SET TRANSACTION SNAPSHOT from a READ COMMITTED importer. PostgreSQL rejects it with SQLSTATE 0A000: a snapshot-importing transaction must use SERIALIZABLE or REPEATABLE READ. Reproduced on PostgreSQL 18.6 with reproduce_import_snapshot_read_committed.py.