Re: ERROR from pg_restore - From OS X to Ubuntu

Got it. Thank you very much!

On Fri, Nov 4, 2011 at 2:06 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote:

> 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
>

--
Naoko Reeves
http://www.anypossibility.com/