Thread: ERROR from pg_restore - From OS X to Ubuntu
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.
Naoko
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
Got it. Thank you very much!
--
Naoko Reeves
On Fri, Nov 4, 2011 at 2:06 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Naoko Reeves wrote:
> I dumped from:
> [...] PostgreSQL 9.0.4 [...]
> to:
> [...] PostgreSQL 9.1.1 [...]I'd say it is safe to ignore.
> 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?
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