随笔 - 404  文章 - 4  评论 - 0  阅读 - 25万

【PgSQL问题排查】PostgreSQL could not read symbolic link "pg_tblspc/tbsberkly": Invalid argument

 

[postgres@zehost ~]$ pg_rman backup -b full -U postgres -Z -h 127.0.0.1 -p 5432
Password for user postgres:
INFO: copying database files
WARNING: could not read symbolic link "pg_tblspc/tbsberkly": Invalid argument
WARNING: could not read symbolic link "pg_tblspc/tbsmem": Invalid argument
INFO: copying archived WAL files


[postgres@zehost pg_tblspc]$ cd /data/pgsql_5432/data/pg_tblspc
[postgres@zehost pg_tblspc]$ ll
total 8
lrwxrwxrwx 1 postgres postgres 33 Sep 3 21:54 16413 -> /data/pgsql_5432/tbsdata/tbs_berkley
lrwxrwxrwx 1 postgres postgres 33 Sep 3 21:54 16415 -> /data/pgsql_5432/tbsdata/tbs_mem

drwx------ 2 postgres postgres 4096 Sep 3 21:54 tbsberkly
drwx------ 2 postgres postgres 4096 Sep 3 21:54 tbsmem

[postgres@zehost pg_tblspc]$ ll tbsberkly/
total 0
[postgres@zehost pg_tblspc]$ ll tbsmem/
total 0
[postgres@zehost pg_tblspc]$ mv tbsberkly /tmp/
[postgres@zehost pg_tblspc]$ mv tbsmem /tmp/
[postgres@zehost pg_tblspc]$ ll
total 0
lrwxrwxrwx 1 postgres postgres 33 Sep 3 21:54 16413 -> /data/pgsql_5432/tbsdata/tbs_berkley
lrwxrwxrwx 1 postgres postgres 33 Sep 3 21:54 16415 -> /data/pgsql_5432/tbsdata/tbs_mem
lrwxrwxrwx 1 postgres postgres 36 Sep 3 21:54 20806 -> /data/pgsql_5432/tbsdata/tbs_pgbench

 

[postgres@zehost ~]$ pg_ctl stop
waiting for server to shut down.... done
server stopped
[postgres@zehost ~]$ pg_ctl start
waiting for server to start....2020-09-26 21:36:14.413 CST [6673] LOG: starting PostgreSQL 12.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit
2020-09-26 21:36:14.414 CST [6673] LOG: listening on IPv4 address "0.0.0.0", port 5432
2020-09-26 21:36:14.414 CST [6673] LOG: listening on IPv6 address "::", port 5432
2020-09-26 21:36:14.416 CST [6673] LOG: listening on Unix socket "/data/pgsql_5432/.s.PGSQL.5432"
2020-09-26 21:36:14.574 CST [6673] LOG: redirecting log output to logging collector process
2020-09-26 21:36:14.574 CST [6673] HINT: Future log output will appear in directory "/data/pgsql_5432/logs".
done
server started

posted on   HelonTian  阅读(768)  评论(0编辑  收藏  举报
编辑推荐:
· SQL Server 2025 AI相关能力初探
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· SQL Server 2025 AI相关能力初探
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
历史上的今天:
2019-09-26 HANA LOG日志过大处理办法
2018-09-26 查看Oracle数据库中的执行计划
< 2025年3月 >
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

点击右上角即可分享
微信分享提示