时间戳

首页 > 解决方案 > Postgres 数据库还原错误：警告：还原时忽略错误：38 进程返回退出代码 1

postgresql - Postgres 数据库还原错误：警告：还原时忽略错误：38 进程返回退出代码 1

问题描述

我正在使用 Postgres 9.5.1 并尝试恢复 Postgres 数据库。出现以下错误：

   pg_restore: [archiver (db)] Error while PROCESSING TOC:
    pg_restore: [archiver (db)] Error from TOC entry 527; 1255 1117686 FUNCTION pldbg_abort_target(integer) postgres
    pg_restore: [archiver (db)] could not execute query: ERROR:  could not access file "$libdir/plugin_debugger": No such file or directory
        Command was: CREATE FUNCTION pldbg_abort_target(session integer) RETURNS SETOF boolean
        LANGUAGE c STRICT
        AS '$libdir/plugin_debug...
    pg_restore: [archiver (db)] could not execute query: ERROR:  function public.pldbg_abort_target(integer) does not exist
        Command was: ALTER FUNCTION public.pldbg_abort_target(session integer) OWNER TO postgres;


    pg_restore: creating FUNCTION "public.pldbg_attach_to_port(integer)"
    pg_restore: [archiver (db)] Error from TOC entry 528; 1255 1117687 FUNCTION pldbg_attach_to_port(integer) postgres
    pg_restore: [archiver (db)] could not execute query: ERROR:  could not access file "$libdir/plugin_debugger": No such file or directory
        Command was: CREATE FUNCTION pldbg_attach_to_port(portnumber integer) RETURNS integer
        LANGUAGE c STRICT
        AS '$libdir/plugin_debugg...
    pg_restore: [archiver (db)] could not execute query: ERROR:  function public.pldbg_attach_to_port(integer) does not exist
        Command was: ALTER FUNCTION public.pldbg_attach_to_port(portnumber integer) OWNER TO postgres;


    pg_restore: creating FUNCTION "public.pldbg_continue(integer)"
    pg_restore: [archiver (db)] Error from TOC entry 529; 1255 1117688 FUNCTION pldbg_continue(integer) postgres
    pg_restore: [archiver (db)] could not execute query: ERROR:  could not access file "$libdir/plugin_debugger": No such file or directory
        Command was: CREATE FUNCTION pldbg_continue(session integer) RETURNS breakpoint
        LANGUAGE c STRICT
        AS '$libdir/plugin_debugger', '...
    pg_restore: [archiver (db)] could not execute query: ERROR:  function public.pldbg_continue(integer) does not exist
        Command was: ALTER FUNCTION public.pldbg_continue(session integer) OWNER TO postgres;

     pg_restore: creating FUNCTION "public.pldbg_create_listener()"
        pg_restore: [archiver (db)] Error from TOC entry 530; 1255 1117689 FUNCTION pldbg_create_listener() postgres
        pg_restore: [archiver (db)] could not execute query: ERROR:  could not access file "$libdir/plugin_debugger": No such file or directory
            Command was: CREATE FUNCTION pldbg_create_listener() RETURNS integer
            LANGUAGE c STRICT
            AS '$libdir/plugin_debugger', 'pldbg_creat...
        pg_restore: [archiver (db)] could not execute query: ERROR:  function public.pldbg_create_listener() does not exist
            Command was: ALTER FUNCTION public.pldbg_create_listener() OWNER TO postgres;
.................
WARNING: errors ignored on restore: 38

Process returned exit code 1.

错误太长了，我只添加了几个错误。我检查了数据库，几乎所有数据都出现在数据库中。我需要帮助解决这个错误。

标签： postgresqlpg-restore

解决方案

您必须在目标数据库的软件目录中安装 EDB PL/pgSQL 调试器才能消除这些错误消息。

此外，这似乎是调试器的旧版本，因为它没有作为扩展安装。

您可以放心地忽略属于此模块的所有错误，因为它仅用于调试。

如果您需要调试器，请获取当前版本并将其作为扩展安装。

推荐阅读