postgres456061020:43pts/100:00:00/optt/10.5/bin/postgres -D /DATA/postgres4560745606020:43?00:00:00postgres: logger process postgres4560845606020:43?00:00:00postgres: startup process recovering000000010000000000000008postgres4561045606020:43?00:00:00postgres: checkpointer process postgres4561145606020:43?00...
S 17:49 0:00 /usr/pgsql-9.4/bin/postmaster -D /var/lib/pgsql/9.4/data postgres 11510 0.0 0.0 324796 4336 ? Ss 17:49 0:00 postgres: startup process recovering 000000010000000500000001 postgres 11513 0.0 0.0 331892 3700 ? Ss 17:49 0:00 postgres: wal receiver process streaming 5/103A1...
blocking_activity.queryAScurrent_statement_in_blocking_processFROMpg_catalog.pg_locks blocked_locksJOINpg_catalog.pg_stat_activity blocked_activityONblocked_activity.pid=blocked_locks.pidJOINpg_catalog.pg_locks blocking_locksONblocking_locks.locktype=blocked_locks.locktypeANDblocking_locks.DATABASEISNOTDIS...
00:00:00 postgres: startup process recovering 00000003000000000000001C postgres 1929 1927 0 11:20 ? 00:00:00 postgres: checkpointer process postgres 1930 1927 0 11:20 ? 00:00:00 postgres: writer process postgres 1931 1927 0 11:20 ? 00:00:00 postgres: stats collector process postgres 1932 ...
pg 15330 15329 0 10:26 ? 00:00:00 postgres: startup process recovering 000000010000000000000003 1. 2. 3. 4. pg流复制原理 pg流复制主要分为2个阶段,实例恢复阶段和主备同步阶段。 实例恢复阶段:当pg库异常宕机后,数据库启动时,pg会重放宕机前的最后一个checkpoint之后的所有WAL日志(这跟oracle、mysql等...
\_ postgres: startup process recovering 000000010000000000000005 \_ postgres: checkpointer process...\_ postgres: startup process recovering 000000010000000000000007 \_ postgres: checkpointer process...| 0/8000610 replay_location | 0/8000610 sync_priority | 0 sync_state | async 5 流复制槽异步热备(...
从服务器上,可以看到 wal receiver 进程,和recovering进程正在恢复archive log $ ps aux|grep postgres postgres115080.00.132468415128? S17:490:00/usr/pgsql-9.4/bin/postmaster-D/var/lib/pgsql/9.4/datapostgres115100.00.03247964336? Ss17:490:00postgres: startup process recovering000000010000000500000001postgres...
postgres 13107 13105 0 17:18 ? 00:00:00 postgres: startup recovering 00000001000000000000000D postgres 13108 13105 0 17:18 ? 00:00:00 postgres: checkpointer postgres 13109 13105 0 17:18 ? 00:00:00 postgres: background writer postgres 13110 13105 0 17:18 ? 00:00:00 postgres: stats coll...
*/ void InitStandaloneProcess(const char *argv0) { Assert(!IsPostmasterEnvironment); MyProcPid = getpid(); /* reset MyProcPid */ MyStartTime = time(NULL); /* set our start time in case we call elog */ /* Initialize process-local latch support */ InitializeLatchSuppo...
psql startup process is reporting 99% IO time iniotopbut 0 bytes read/write so I'm not sure what's going on here. CPU load is around 50% on one core of a total of 8 (so, <10%). I've not done any tuning of psql configuration beyond defaults for the omnibus docker image. ...