↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Protocol Messages

Stream Abort (logical replication)

Logical replication Stream Abort format. Identifies the message as a stream abort message.

Reading PG 18·Select a recorded version

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

Definition PG 18

Byte1('A')

Identifies the message as a stream abort message.

Int32 (TransactionId)

Xid of the transaction.

Int32 (TransactionId)

Xid of the subtransaction (will be same as xid of the transaction for top-level transactions).

Int64 (XLogRecPtr)

The LSN of the abort operation, present only when streaming is set to parallel. This field is available since protocol version 4.

Int64 (TimestampTz)

Abort timestamp of the transaction, present only when streaming is set to parallel. The value is in number of microseconds since PostgreSQL epoch (2000-01-01). This field is available since protocol version 4.

Fields in documented order

PositionFormatMeaning
1Byte1('A')Identifies the message as a stream abort message.
2Int32 (TransactionId)Xid of the transaction.
3Int32 (TransactionId)Xid of the subtransaction (will be same as xid of the transaction for top-level transactions).
4Int64 (XLogRecPtr)The LSN of the abort operation, present only when streaming is set to parallel. This field is available since protocol version 4.
5Int64 (TimestampTz)Abort timestamp of the transaction, present only when streaming is set to parallel. The value is in number of microseconds since PostgreSQL epoch (2000-01-01). This field is available since protocol version 4.

Compare versions

Complete source facts

fields

map[description:Identifies the message as a stream abort message. format:Byte1('A')], map[description:Xid of the transaction. format:Int32 (TransactionId)], map[description:Xid of the subtransaction (will be same as xid of the transaction for top-level transactions). format:Int32 (TransactionId)], map[description:The LSN of the abort operation, present only when streaming is set to parallel. This field is available since protocol version 4. format:Int64 (XLogRecPtr)], map[description:Abort timestamp of the transaction, present only when streaming is set to parallel. The value is in number of microseconds since PostgreSQL epoch (2000-01-01). This field is available since protocol version 4. format:Int64 (TimestampTz)]

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f