Re: ERROR from pg_restore - From OS X to Ubuntu

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Naoko Reeves *EXTERN*" <naokoreeves(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR from pg_restore - From OS X to Ubuntu
Date: 2011-11-04 09:06:35
Message-ID: D960CB61B694CF459DCFB4B0128514C20713EBCF@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Naoko Reeves wrote:
> I dumped from:
> [...] PostgreSQL 9.0.4 [...]

> to:
> [...] PostgreSQL 9.1.1 [...]

> During the restoration I got the following errors:
>
> ERROR: could not access file "$libdir/targetinfo": No such file or
directory
> ERROR: function public.pldbg_get_target_info(text, "char") does not
exist
> ERROR: could not access file "$libdir/plugins/plugin_debugger": No
such file or directory
> ERROR: function public.plpgsql_oid_debug(oid) does not exist
>
> My question is:
> 1. Is this safe to ignore? I don't recall using any of the function
> 2. If not, how can I install those missing libraries?

I'd say it is safe to ignore.
You must have the EDB debugger installed in the 9.0.4 database, but not
in the destination database.

You'll probably end up with some garbage (types etc.) in the public
schema
that you should remove if you ever want to install the EDB debugger in
the
target database, but other than that they should not bother you.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Mieslinger 2011-11-04 09:28:38 Re: Recommendations for SSDs in production?
Previous Message Graham Murray 2011-11-04 08:37:44 Re: postgresql-9.1.1 PQescapeByteaConn() generating incorrectly quoted output.