↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Protocol Messages

Begin (logical replication)

Logical replication Begin format. Identifies the message as a begin message.

Reading PG 18·Select a recorded version

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

Definition PG 18

Byte1('B')

Identifies the message as a begin message.

Int64 (XLogRecPtr)

The final LSN of the transaction.

Int64 (TimestampTz)

Commit timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01).

Int32 (TransactionId)

Xid of the transaction.

Fields in documented order

PositionFormatMeaning
1Byte1('B')Identifies the message as a begin message.
2Int64 (XLogRecPtr)The final LSN of the transaction.
3Int64 (TimestampTz)Commit timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01).
4Int32 (TransactionId)Xid of the transaction.

Compare versions

Complete source facts

fields

map[description:Identifies the message as a begin message. format:Byte1('B')], map[description:The final 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)], map[description:Xid of the transaction. format:Int32 (TransactionId)]

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f