lightdb切换wal日志

zjh@mydb_for_ora=# insert into big_table select id,uuid() from generate_series(1,1000) id;
INSERT 0 1000
zjh@mydb_for_ora=#  select pg_switch_wal();
 pg_switch_wal 
---------------
 0/40022D20
(1 row)

 查看LSN所在的文件

select pg_walfile_name('1/521B5A70');

 

posted @ 2022-12-15 15:37  zhjh256  阅读(24)  评论(0编辑  收藏  举报