Re: restoreing dumps fail

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: restoreing dumps fail
Date: 2002-05-14 15:32:12
Message-ID: 200205141232.12695.martin@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mar 14 May 2002 12:27, Tom Lane wrote:
> =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin(at)bugs(dot)unl(dot)edu(dot)ar> writes:
> >> Hmm, that's bizarre. How did you compile the array_iterator module?
> >> There is no _fini routine in the source code, so this must be something
> >> inserted by the compiler.
> >
> > Could it be, that the array_iterator was compiled with some old
> > postgres-7.0.x and then was left there???
>
> That's a good point. Look at your dump script to see if it's trying to
> do any CREATE FUNCTION commands with absolute paths to .so files. If
> so, you probably want to fix those to be $libdir-relative paths (a new
> feature in 7.2, makes maintenance a lot easier).

Done!!! Thaks for all the tups Tom!

Recompiled the array_iterator.so, copied it to the new lib dir, and now it
passed like a charme. :-)

Lots of thanks to all!!!

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message tony 2002-05-14 15:49:20 Re: Using COPY
Previous Message Alvaro Herrera 2002-05-14 15:31:26 Re: Configure problems with readline Mandrake 8.2 and