Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

PG_STAT_REPLICATION

Updated on 2024-09-30 GMT+08:00

PG_STAT_REPLICATION displays information about log synchronization status, such as the locations of the sender sending logs and the receiver receiving logs.

Table 1 PG_STAT_REPLICATION columns

Name

Type

Description

pid

bigint

PID of the thread.

usesysid

oid

User system ID.

usename

name

Username.

application_name

text

Program name.

client_addr

inet

Client address.

client_hostname

text

Client name.

client_port

integer

Client port number.

backend_start

timestamp with time zone

Program start time.

state

text

Log replication state (catch-up or consistent streaming).

sender_sent_location

text

Location where the sender sends logs.

receiver_write_location

text

Location where the receiver writes logs.

receiver_flush_location

text

Location where the receiver flushes logs.

receiver_replay_location

text

Location where the receiver replays logs.

sync_priority

integer

Priority of synchronous duplication (0 indicates asynchronization).

sync_state

text

Synchronization state (asynchronous duplication, synchronous duplication, or potential synchronization).

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback