PG_DUMP 问题记录

最新推荐文章于 2023-12-06 15:18:19 发布

Omega29

最新推荐文章于 2023-12-06 15:18:19 发布

阅读量1.8k

点赞数

文章标签： postgresql 数据库

本文链接：https://blog.csdn.net/Omega29/article/details/122937969

版权

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

摘要由CSDN通过智能技术生成

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) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault('f',p.proowner))) WITH