pg中使用 pg_waldump 分析 wal - 重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

317467fb662b6ac89.png (366.73 KB, 下载次数: 5)

3 天前上传

太多，如果想只分析一段

3.看一段
  postgres=# select pg_current_wal_lsn(),pg_walfile_name(pg_current_wal_lsn())
;
pg_current_wal_lsn |    pg_walfile_name
--------------------+--------------------------
0/7E2DE990       | 0000000E000000000000007E
(1 row)

postgres=# checkpoint;
CHECKPOINT
postgres=# select pg_current_wal_lsn(),pg_walfile_name(pg_current_wal_lsn())
;
pg_current_wal_lsn |    pg_walfile_name
--------------------+--------------------------
0/7E2DEA40       | 0000000E000000000000007E
(1 row)

[postgres@db124 pg_wal]$ pg_waldump -p $PGDATA/pg_wal 0000000E000000000000007E -s 0/7E2DE990 -e 0/7E2DEA40

rmgr: Standby    len (rec/tot):    50/ 50, tx:       0, lsn: 0/7E2DE990, prev 0/7E2DE958, desc: RUNNING_XACTS nextXid 2135 latestCompletedXid 2134 oldestRunningXid 2135
rmgr: XLOG       len (rec/tot): 114/ 114, tx:       0, lsn: 0/7E2DE9C8, prev 0/7E2DE990, desc: CHECKPOINT_ONLINE redo 0/7E2DE990; tli 14; prev tli 14; fpw true; xid 0:2135; oid 26139; multi 4; offset 7; oldest xid 479 in DB 1; oldest multi 1 in DB 1; oldest/newest commit timestamp xid: 0/0; oldest running xid 2135; online
[postgres@db124 pg_wal]$

-s 开始
-e 结束
-p 目录

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)