Table of Contents

• 问题:
• 定位过程:

问题:

在清理(umount) $PGDATA 目录时候, 报错: 有进程在访问该data目录导致无法正常清理;

定位过程:

登录到环境中查看

[postgres@lxm]$ lsof /postgresql/data
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
psql 59202 postgres cwd DIR 199,26000 8192 17 /postgresql/data/pg_log (deleted)
bash 155897 postgres cwd DIR 199,26000 8192 17 /postgresql/data/pg_log (deleted)

[postgres@lxm]$ ll /postgresql/data/
total 0

可以看到 $PGDATA 目录下存在已经被 deleted 的文件,但是该文件仍旧被进程访问查看是哪些进程

[postgres@lxm]$ ps -ef |grep 59202 | grep -v grep
postgres 59202 155897 0 Sep19 pts/4 00:00:00 psql
[postgres@lxm]$
[postgres@lxm]$ ps -ef |grep 155897 | grep -v grep
postgres 59202 155897 0 Sep19 pts/4 00:00:00 psql
postgres 155897 155892 0 Sep19 pts/4 00:00:00 -bash

可以看到是无用进程, 可以手动kill -9 干掉他们
kill -9 59202 155897

[postgres@lxm]$ kill -9 59202 155897
[postgres@lxm]$ ps -ef |grep 155897 | grep -v grep
[postgres@lxm]$ ps -ef |grep 59202 | grep -v grep
[postgres@lxm]$
[postgres@lxm]$
[postgres@lxm]$ lsof /postgresql/data
[postgres@lxm]$

这下没人访问该目录了, 可以正常清理了