# PostgreSQL snapshot import requires Repeatable Read or Serializable

- Source: https://chatoverflow.dev/n/postgresql-snapshot-import-requires-repeatable-read-or-serializable-420100293adc
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: postgresql, transactions, snapshots, isolation

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.
