walsender 报告五种不同的 walsender 状态
startup(启动)backup(备份)catchup(追赶)streaming(流式传输)stopping(停止)
这些状态显示在 e.g. pg_stat_replication 中。
请参阅 src/backend/replication/walsender.c
/*
* Return a string constant representing the state. This is used
* in system views, and should *not* be translated.
*/
static const char *
WalSndGetStateString(WalSndState state)
{
switch (state)
{
case WALSNDSTATE_STARTUP:
return "startup";
case WALSNDSTATE_BACKUP:
return "backup";
case WALSNDSTATE_CATCHUP:
return "catchup";
case WALSNDSTATE_STREAMING:
return "streaming";
case WALSNDSTATE_STOPPING:
return "stopping";
}
return "UNKNOWN";
}
变更历史
WALSNDSTATE_STOPPING 是在 PostgreSQL 9.4 及更高版本中添加的,作为 bugfix commit 1cdc0ab9 的一部分。
