postgresSQL清理xlog

最新推荐文章于 2024-08-08 18:33:23 发布

wish503

最新推荐文章于 2024-08-08 18:33:23 发布

阅读量2.5k

点赞数

分类专栏： postgres

本文链接：https://blog.csdn.net/wish503/article/details/52759587

版权

本文详细介绍了如何清理PostgreSQL的xlog文件，包括停库、查询NextXID和NextOID、清理XLOG以及启库等步骤，旨在帮助用户释放存储空间并确保数据库正常运行。

摘要由CSDN通过智能技术生成

pg_log可以直接用rm删除，但是pg_xlog不行，清理步骤如下：

1、停库：

[postgres@cnsz081285:d0cmu:7490 /paic/pg7490/data/pg_xlog]$ pg stop
waiting for server to shut down.... done
server stopped
Lock file exists. exit
Lock file exists. exit
Pgagent status is 100.
Can not find the pid file. 7490 is not runing.

2查询NextXID和NextOID
[postgres@cnsz081285:d0cmu:7490 /paic/pg7490/data/pg_xlog]$ pg_controldata
pg_control version number:            942
Catalog version number:               201510051
Database system identifier:           6307074520783085345
Database cluster state:               shut down
pg_control last modified:             Sat 08 Oct 2016 06:28:29 PM CST
Latest checkpoint location:           8/E4010378
Prior checkpoint location:            8/E40102D0
Latest checkpoint's REDO location:    8/E4010378
Latest checkpoint's REDO WAL file:    00000