Обсуждение: ERROR from pg_restore - From OS X to Ubuntu

On Fri, Nov 4, 2011 at 05:40, Naoko Reeves <naokoreeves@gmail.com> wrote:
> I dumped from:
> OS: OS X 10.5.8
> pg version: PostgreSQL 9.0.4 on x86_64-apple-darwin, compiled by GCC
> i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664), 64-bit
> Installation Method: EDB installer
> to:
> OS: Ubuntu 10.04.3 64bit
> pg version: PostgreSQL 9.1.1 on x86_64-pc-linux-gnu, compiled by
> gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit
> installation Method: apt-get install postgresql-9.1 postgresql-contrib-9.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?
> Thank you very much for your time in advance.

It looks like it's the pl/pgsql debugger that has those functions. If
you're not using it then you can safely ignore them, but if you do use
it, expect it to be broken.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

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