Search PostgreSQL documentation

loggingExtensionsExtensionsAdministrative C function to enable or disable logging mode on relations. admin unlogged wal logging AdministrationAdministration · Extensions logging_collectorConfigurationReferencelogging_collector Reporting and Logging 10 This parameter enables the logging collector, which is a background process that captures log messages sent to stderr and redirects them into log f…Configuration · Reporting and Logging Logical DecodingManual ChaptersPG1847.2.1. Logical Decoding Logical decoding is the process of extracting all persistent changes to a database's tables into a coherent, easy to understand format which can be interpreted witho…Logical Decoding Logical DecodingManual ChaptersPG18Chapter 47. Logical Decoding PostgreSQL provides infrastructure to stream the modifications performed via SQL to external consumers. This functionality can be used for a variety of purposes,…Logical Decoding Logical Decoding ConceptsManual ChaptersPG1847.2. Logical Decoding ConceptsLogical Decoding Concepts Logical Decoding ExamplesManual ChaptersPG1847.1. Logical Decoding Examples The following example demonstrates controlling logical decoding using the SQL interface. Before you can use logical decoding, you must set wal_level to logica…Logical Decoding Examples Logical Decoding Output PluginsManual ChaptersPG1847.6. Logical Decoding Output Plugins An example output plugin can be found in the contrib/test_decoding subdirectory of the PostgreSQL source tree.Logical Decoding Output Plugins Logical Decoding Output WritersManual ChaptersPG1847.7. Logical Decoding Output Writers It is possible to add more output methods for logical decoding. For details, see src/backend/replication/logical/logicalfuncs.c. Essentially, three func…Logical Decoding Output Writers Logical Decoding SQL InterfaceManual ChaptersPG1847.4. Logical Decoding SQL Interface See Section 9.28.6 for detailed documentation on the SQL-level API for interacting with logical decoding. Synchronous replication (see Section 26.2.8) is…Logical Decoding SQL Interface Logical OperatorsManual ChaptersPG189.1. Logical Operators The usual logical operators are available: boolean AND boolean → boolean boolean OR boolean → boolean NOT boolean → boolean SQL uses a three-valued logic system with t…Logical Operators Logical ReplicationManual ChaptersPG18Chapter 29. Logical Replication Logical replication is a method of replicating data objects and their changes, based upon their replication identity (usually a primary key). We use the term …Logical Replication Logical ReplicationManual ChaptersPG18E.6.3.1.8. Logical Replication Allow the values of generated columns to be logically replicated (Shubham Khanna, Vignesh C, Zhijie Hou, Shlok Kyal, Peter Smith) § § § § If the publication sp…Logical Replication Logical Replication ApplicationsManual ChaptersPG18E.6.3.7.3. Logical Replication Applications Add pg_createsubscriber option --all to create logical replicas for all databases (Shubham Khanna) § Add pg_createsubscriber option --clean to rem…Logical Replication Applications Logical Replication FailoverManual ChaptersPG1829.3. Logical Replication Failover To allow subscriber nodes to continue replicating data from the publisher node even when the publisher node goes down, there must be a physical standby cor…Logical Replication Failover Logical Replication Message FormatsManual ChaptersPG1854.9. Logical Replication Message Formats This section describes the detailed format of each logical replication message. These messages are either returned by the replication slot SQL inter…Logical Replication Message Formats Logical Replication Protocol Message FlowManual ChaptersPG1854.5.3. Logical Replication Protocol Message Flow With the exception of the START_REPLICATION command and the replay progress messages, all information flows only from the backend to the fro…Logical Replication Protocol Message Flow Logical Replication Protocol MessagesManual ChaptersPG1854.5.2. Logical Replication Protocol Messages The individual protocol messages are discussed in the following subsections. Individual messages are described in Section 54.9. All top-level pr…Logical Replication Protocol Messages Logical Streaming Replication ParametersManual ChaptersPG1854.5.1. Logical Streaming Replication Parameters Using the START_REPLICATION command, pgoutput accepts the following options: proto_version Protocol version. Currently versions 1, 2, 3, and …Logical Streaming Replication Parameters Logical Streaming Replication ProtocolManual ChaptersPG1854.5. Logical Streaming Replication Protocol This section describes the logical replication protocol, which is the message flow started by the START_REPLICATION SLOT slot_name LOGICAL replic…Logical Streaming Replication Protocol logical_ddlExtensionsExtensionsReplicate supported DDL changes over PostgreSQL logical replication logical_ddl Replication and streamsReplication and streams · Extensions logical_decoding_work_memConfigurationReferencelogical_decoding_work_mem Resource Usage 13 Specifies the maximum amount of memory to be used by logical decoding, before some of the decoded changes are written to local disk. This limits t…Configuration · Resource Usage LogicalApplyMainWait EventsReferenceLogicalApplyMain Activity 10 Waiting in main loop of logical apply process. 11 12 13 Waiting in main loop of logical replication apply process. 14 15 16 17 18 19 20 This is normally expected…Wait Events · Activity LogicalApplySendDataWait EventsReferenceLogicalApplySendData IPC 16 Waiting for a logical replication leader apply process to send data to a parallel apply process. 17 18 19 20 Brief rendezvous is normal when every participant con…Wait Events · IPC LogicalChangesReadWait EventsReferenceLogicalChangesRead IO 14 Waiting for a read from a logical changes file. No live core occurrence is expected on the audited release. If telemetry shows it, verify the exact patch version, ex…Wait Events · IO LogicalChangesWriteWait EventsReferenceLogicalChangesWrite IO 14 Waiting for a write to a logical changes file. No live core occurrence is expected on the audited release. If telemetry shows it, verify the exact patch version, ex…Wait Events · IO LogicalDecodingControlWait EventsReferenceLogicalDecodingControl LWLock 19 Waiting to read or update logical decoding status information. 20Wait Events · LWLock LogicalLauncherMainWait EventsReferenceLogicalLauncherMain Activity 10 Waiting in main loop of logical launcher process. 11 12 13 Waiting in main loop of logical replication launcher process. 14 15 16 17 18 19 20 This is normally…Wait Events · Activity LogicalParallelApplyMainWait EventsReferenceLogicalParallelApplyMain Activity 16 Waiting in main loop of logical replication parallel apply process. 17 18 19 20 This is normally expected idleness for the matching background process. I…Wait Events · Activity LogicalParallelApplyStateChangeWait EventsReferenceLogicalParallelApplyStateChange IPC 16 Waiting for a logical replication parallel apply process to change state. 17 18 19 20 Brief rendezvous is normal when every participant continues to ad…Wait Events · IPC LogicalRepLauncherDSAWait EventsReferenceLogicalRepLauncherDSA LWLock 16 Waiting to access logical replication launcher's dynamic shared memory allocator. 17 18 19 20 A brief sample is normal around short internal critical sections…Wait Events · LWLock LogicalRepLauncherHashWait EventsReferenceLogicalRepLauncherHash LWLock 16 Waiting to access logical replication launcher's shared hash table. 17 18 19 20 A brief sample is normal around short internal critical sections. Investigate…Wait Events · LWLock LogicalRepWorkerWait EventsReferenceLogicalRepWorker LWLock 10 Waiting for action on logical replication worker to finish. 11 12 13 Waiting to read or update the state of logical replication workers. 14 15 16 17 18 19 20 A bri…Wait Events · LWLock LogicalRewriteCheckpointSyncWait EventsReferenceLogicalRewriteCheckpointSync IO 10 Waiting for logical rewrite mappings to reach durable storage during a checkpoint. 11 12 13 14 15 16 17 18 19 20 The wait is normal when the workload is ex…Wait Events · IO LogicalRewriteMappingSyncWait EventsReferenceLogicalRewriteMappingSync IO 10 Waiting for mapping data to reach durable storage during a logical rewrite. 11 12 13 14 15 16 17 18 19 20 The wait is normal when the workload is expected to …Wait Events · IO LogicalRewriteMappingWriteWait EventsReferenceLogicalRewriteMappingWrite IO 10 Waiting for a write of mapping data during a logical rewrite. 11 12 13 14 15 16 17 18 19 20 The wait is normal when the workload is expected to perform this …Wait Events · IO LogicalRewriteSyncWait EventsReferenceLogicalRewriteSync IO 10 Waiting for logical rewrite mappings to reach durable storage. 11 12 13 14 15 16 17 18 19 20 The wait is normal when the workload is expected to perform this read, w…Wait Events · IO LogicalRewriteTruncateWait EventsReferenceLogicalRewriteTruncate IO 10 Waiting for truncate of mapping data during a logical rewrite. 11 12 13 14 15 16 17 18 19 20 The wait is normal when the workload is expected to perform this rea…Wait Events · IO LogicalRewriteWriteWait EventsReferenceLogicalRewriteWrite IO 10 Waiting for a write of logical rewrite mappings. 11 12 13 14 15 16 17 18 19 20 The wait is normal when the workload is expected to perform this read, write, sync, a…Wait Events · IO LogicalSubxactReadWait EventsReferenceLogicalSubxactRead IO 14 Waiting for a read from a logical subxact file. No live core occurrence is expected on the audited release. If telemetry shows it, verify the exact patch version, ex…Wait Events · IO LogicalSubxactWriteWait EventsReferenceLogicalSubxactWrite IO 14 Waiting for a write to a logical subxact file. No live core occurrence is expected on the audited release. If telemetry shows it, verify the exact patch version, ex…Wait Events · IO