PG_DUMP 问题记录

最新推荐文章于 2024-06-24 16:06:08 发布

原创

最新推荐文章于 2024-06-24 16:06:08 发布 · 2.2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#postgresql #数据库

在尝试使用pg_dump进行数据库备份时遇到了错误：column p.proisagg does not exist。该问题可能是由于客户端与服务端的版本不一致造成的。错误提示表明可能需要引用的是列名'p.prolang'而非'p.proisagg'。解决方案通常涉及更新客户端到与服务端相匹配的版本，或者调整备份脚本来适应现有数据库的结构。

pg_dump: [archiver (db)] query failed: ERROR: column p.proisagg does not exist
LINE 1: ...g_proc'::regclass AND pip.objsubid = 0) WHERE NOT p.proisagg
^
HINT: Perhaps you meant to reference the column "p.prolang".
pg_dump: [archiver (db)] query was: SELECT p.tableoid, p.oid, p.proname, p.prolang, p.pronargs, p.proargtypes, p.prorettype, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(p.proacl,pg_catalog.acldefault('f',p.proowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault('f',p.proowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) AS proacl, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FR