↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Protocol Messages

Origin (logical replication)

Logical replication Origin format. Identifies the message as an origin message.

Reading PG 18·Select a recorded version

Layer
Logical replication payload; distinct from the frontend/backend message envelope
First field
Byte1('O')
fields
map[description:Identifies the message as an origin message. format:Byte1('O')], map[description:The LSN of the commit on the origin server. format:Int64 (XLogRecPtr)], map[description:Name of the origin. format:String]
manual path
/docs/18/protocol-logicalrep-message-formats.html
signature
Origin

Definition PG 18

Byte1('O')

Identifies the message as an origin message.

Int64 (XLogRecPtr)

The LSN of the commit on the origin server.

String

Name of the origin.

Note that there can be multiple Origin messages inside a single transaction.

Fields in documented order

PositionFormatMeaning
1Byte1('O')Identifies the message as an origin message.
2Int64 (XLogRecPtr)The LSN of the commit on the origin server.
3StringName of the origin.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f