2020-06-10 17:35:23 CST:192.168.216.71(36613):postgres@postgres:[9347]: FATAL: 08006: connection to client lost
2020-06-10 17:35:23 CST:192.168.216.71(36613):postgres@postgres:[9347]: LOCATION: ProcessInterrupts, postgres.c:3021
2020-06-10 17:35:23 CST:192.168.216.71(36613):postgres@postgres:[9347]: STATEMENT: WITH RECURSIVE files (path, filename, size, isdir) AS (
SELECT ‘’ AS path, filename, size, isdir FROM
(SELECT pg_ls_dir(’.’, true, false) AS filename) AS fn,
pg_stat_file(fn.filename, true) AS this
UNION ALL
SELECT parent.path || parent.filename || ‘/’ AS path,
fn, this.size, this.isdir
FROM files AS parent,
pg_ls_dir(parent.path || parent.filename, true, false) AS fn,
pg_stat_file(parent.path || parent.filename || ‘/’ || fn, true) AS this
WHERE parent.isdir = ‘t’
)
SELECT path || filename, size, isdir,
pg_tablespace_location(pg_tablespace.oid) AS link_target
FROM files
LEFT OUTER JOIN pg_tablespace ON files.path = ‘pg_tblspc/’
AND oid::text = files.filename
我standby端在主库完成recover后,执行pg_rewind,一直无法成功,master日志显示其执行递归查询,消耗大量的底层磁盘空间,而且报错了,无法执行成功,FATAL: 08006错误,麻烦帮分析一下,谢谢。
