Search PostgreSQL documentation

Message (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Message format. Identifies the message as a logical decoding message. Logical replication formats Message Layer Logical replication payload; distinct from the frontend/b… NegotiateProtocolVersionProtocol MessagesWikiProtocol Messages · Backend messagesis a backend protocol message. Identifies the message as a protocol version negotiation message. Backend messages NegotiateProtocolVersion (B) Direction Backend → frontend First wire field … NoDataProtocol MessagesWikiProtocol Messages · Backend messagesis a backend protocol message. Identifies the message as a no-data indicator. Backend messages NoData (B) Direction Backend → frontend First wire field Byte1('n') Field entries 2 Documented… NoticeResponseProtocol MessagesWikiProtocol Messages · Backend messagesis a backend protocol message. Identifies the message as a notice. Backend messages NoticeResponse (B) Direction Backend → frontend First wire field Byte1('N') Field entries 4 Documented fl… NotificationResponseProtocol MessagesWikiProtocol Messages · Backend messagesis a backend protocol message. Identifies the message as a notification response. Backend messages NotificationResponse (B) Direction Backend → frontend First wire field Byte1('A') Field en… Origin (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Origin format. Identifies the message as an origin message. Logical replication formats Origin Layer Logical replication payload; distinct from the frontend/backend mess… ParameterDescriptionProtocol MessagesWikiProtocol Messages · Backend messagesis a backend protocol message. Identifies the message as a parameter description. Backend messages ParameterDescription (B) Direction Backend → frontend First wire field Byte1('t') Field en… ParameterStatusProtocol MessagesWikiProtocol Messages · Backend messagesis a backend protocol message. Identifies the message as a run-time parameter status report. Backend messages ParameterStatus (B) Direction Backend → frontend First wire field Byte1('S') Fi… ParseProtocol MessagesWikiProtocol Messages · Frontend messagesis a frontend protocol message. Identifies the message as a Parse command. Frontend messages Parse (F) Direction Frontend → backend First wire field Byte1('P') Field entries 6 Documented fl… ParseCompleteProtocol MessagesWikiProtocol Messages · Backend messagesis a backend protocol message. Identifies the message as a Parse-complete indicator. Backend messages ParseComplete (B) Direction Backend → frontend First wire field Byte1('1') Field entrie… PasswordMessageProtocol MessagesWikiProtocol Messages · Frontend messagesis a frontend protocol message. Identifies the message as a password response. Note that this is also used for GSSAPI, SSPI and SASL response messages. The exact message type can be deduced … PortalSuspendedProtocol MessagesWikiProtocol Messages · Backend messagesis a backend protocol message. Identifies the message as a portal-suspended indicator. Note this only appears if an Execute message's row-count limit was reached. Backend messages PortalSus… Prepare (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Prepare format. Identifies the message as a prepared transaction message. Logical replication formats Prepare Layer Logical replication payload; distinct from the fronte… QueryProtocol MessagesWikiProtocol Messages · Frontend messagesis a frontend protocol message. Identifies the message as a simple query. Frontend messages Query (F) Direction Frontend → backend First wire field Byte1('Q') Field entries 3 Documented flo… ReadyForQueryProtocol MessagesWikiProtocol Messages · Backend messagesis a backend protocol message. Identifies the message type. ReadyForQuery is sent whenever the backend is ready for a new query cycle. Backend messages ReadyForQuery (B) Direction Backend →… Relation (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Relation format. Identifies the message as a relation message. Logical replication formats Relation Layer Logical replication payload; distinct from the frontend/backend… Rollback Prepared (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Rollback Prepared format. Identifies the message as the rollback of a prepared transaction message. Logical replication formats Rollback Prepared Layer Logical replicati… RowDescriptionProtocol MessagesWikiProtocol Messages · Backend messagesis a backend protocol message. Identifies the message as a row description. Backend messages RowDescription (B) Direction Backend → frontend First wire field Byte1('T') Field entries 10 Doc… SASLInitialResponseProtocol MessagesWikiProtocol Messages · Frontend messagesis a frontend protocol message. Identifies the message as an initial SASL response. Note that this is also used for GSSAPI, SSPI and password response messages. The exact message type is ded… SASLResponseProtocol MessagesWikiProtocol Messages · Frontend messagesis a frontend protocol message. Identifies the message as a SASL response. Note that this is also used for GSSAPI, SSPI and password response messages. The exact message type can be deduced … SSLRequestProtocol MessagesWikiProtocol Messages · Frontend messagesis a frontend protocol message. Length of message contents in bytes, including self. Frontend messages SSLRequest (F) Direction Frontend → backend First wire field Int32(8) Field entries 2 … StartupMessageProtocol MessagesWikiProtocol Messages · Frontend messagesis a frontend protocol message. Length of message contents in bytes, including self. Frontend messages StartupMessage (F) Direction Frontend → backend First wire field Int32 Field entries 8… Stream Abort (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Stream Abort format. Identifies the message as a stream abort message. Logical replication formats Stream Abort Layer Logical replication payload; distinct from the fron… Stream Commit (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Stream Commit format. Identifies the message as a stream commit message. Logical replication formats Stream Commit Layer Logical replication payload; distinct from the f… Stream Prepare (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Stream Prepare format. Identifies the message as a stream prepared transaction message. Logical replication formats Stream Prepare Layer Logical replication payload; dis… Stream Start (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Stream Start format. Identifies the message as a stream start message. Logical replication formats Stream Start Layer Logical replication payload; distinct from the fron… Stream Stop (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Stream Stop format. Identifies the message as a stream stop message. Logical replication formats Stream Stop Layer Logical replication payload; distinct from the fronten… SyncProtocol MessagesWikiProtocol Messages · Frontend messagesis a frontend protocol message. Identifies the message as a Sync command. Frontend messages Sync (F) Direction Frontend → backend First wire field Byte1('S') Field entries 2 Documented flow… TerminateProtocol MessagesWikiProtocol Messages · Frontend messagesis a frontend protocol message. Identifies the message as a termination. Frontend messages Terminate (F) Direction Frontend → backend First wire field Byte1('X') Field entries 2 Documented … Truncate (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Truncate format. Identifies the message as a truncate message. Logical replication formats Truncate Layer Logical replication payload; distinct from the frontend/backend… TupleData (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication TupleData format. Number of columns. Logical replication formats TupleData Layer Logical replication payload; distinct from the frontend/backend message envelope First f… Type (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Type format. Identifies the message as a type message. Logical replication formats Type Layer Logical replication payload; distinct from the frontend/backend message env… Update (logical replication)Protocol MessagesWikiProtocol Messages · Logical replication formatsLogical replication Update format. Identifies the message as an update message. Logical replication formats Update Layer Logical replication payload; distinct from the frontend/backend mess…