问题002:psql: could not connect to server: No such file or directory

今天好好的服务突然打不开了,以为是postresql问题,到服务器上瞧瞧,结果发现本地无法登陆psql控制台,怪了,之前好好的没动过服务器啊。

平时正常运行的命令莫名奇妙报错:

su - postgres psql

/usr/bin/psql: line 19: use: command not found
/usr/bin/psql: line 20: use: command not found
/usr/bin/psql: line 21: use: command not found
/usr/bin/psql: psql: line 23: syntax error near unexpected token `$version,'
/usr/bin/psql: psql: line 23: `my ($version, $cluster, $db, $port, $host);'

sudo -u postgres psql

psql: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

ls /va 按Tab快速补齐时报错:

odoo-bash: cannot create temp file for here-document: No space left on device
-bash: cannot create temp file for here-document: No space left on device

经查是 /dev/vda1 磁盘空间满了

df -h

Filesystem      Size  Used Avail Use% Mounted on
/dev/vda1       189G  180G     0 100% /
udev             10M     0   10M   0% /dev
tmpfs           1.6G  8.5M  1.6G   1% /run
tmpfs           4.0G     0  4.0G   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           4.0G     0  4.0G   0% /sys/fs/cgroup
tmpfs           801M     0  801M   0% /run/user/1001

查看根目录下所有文件及目录大小

sudo du -sh /*

9.2G    backup
8.9M    bin
31M boot
0   dev
9.1M    etc
2.5G    home
0   initrd.img
206M    lib
4.0K    lib64
164K    lost+found
8.0K    media
4.0K    mnt
135G    odoo
4.0K    opt
du: cannot access ‘proc/4028/task/4028/fd/4’: No such file or directory
du: cannot access ‘proc/4028/task/4028/fdinfo/4’: No such file or directory
du: cannot access ‘proc/4028/fd/4’: No such file or directory
du: cannot access ‘proc/4028/fdinfo/4’: No such file or directory
0   proc
300K    root
8.5M    run
5.4M    sbin
18G srv
0   sys
556K    tmp
2.3G    usr
14G var
0   vmlinuz
先去占用空间最大的135G的 odoo 目录中去看看有没有要清理的文件

cd /odoo
sudo du -sh *

127G    backups
8.1G    backups1
20K ssl
原来是我的备份长时间没清理,到今天终于把硬盘空间耗完了,找到原因,那么就清理一下吧。

sudo rm -rf backups/*

然后我重启了一个应用服务和postgresql服务,OK,问题解决了,我的应用服务可以正常访问了。

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。