Stream Commit (logical replication)

Logical replication Stream Commit format. Identifies the message as a stream commit message.

Reading PG 18·Select a recorded version

Layer: Logical replication payload; distinct from the frontend/backend message envelope
First field: Byte1('c')
manual path: /docs/18/protocol-logicalrep-message-formats.html
signature: Stream Commit

Definition PG 18

Byte1('c'): Identifies the message as a stream commit message.
Int32 (TransactionId): Xid of the transaction.
Int8(0): Flags; currently unused.
Int64 (XLogRecPtr): The LSN of the commit.
Int64 (XLogRecPtr): The end LSN of the transaction.
Int64 (TimestampTz): Commit timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01).

Fields in documented order

Position	Format	Meaning
1	Byte1('c')	Identifies the message as a stream commit message.
2	Int32 (TransactionId)	Xid of the transaction.
3	Int8(0)	Flags; currently unused.
4	Int64 (XLogRecPtr)	The LSN of the commit.
5	Int64 (XLogRecPtr)	The end LSN of the transaction.
6	Int64 (TimestampTz)	Commit timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01).

Compare versions

Complete source facts

fields

map[description:Identifies the message as a stream commit message. format:Byte1('c')], map[description:Xid of the transaction. format:Int32 (TransactionId)], map[description:Flags; currently unused. format:Int8(0)], map[description:The LSN of the commit. format:Int64 (XLogRecPtr)], map[description:The end LSN of the transaction. format:Int64 (XLogRecPtr)], map[description:Commit timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01). format:Int64 (TimestampTz)]

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f