Re: restoreing dumps fail - Mailing list pgsql-general

From Martín Marqués
Subject Re: restoreing dumps fail
Date
Msg-id 200205141232.12695.martin@bugs.unl.edu.ar
Whole thread Raw
In response to Re: restoreing dumps fail  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mar 14 May 2002 12:27, Tom Lane wrote:
> =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin@bugs.unl.edu.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@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Question about setval() function
Next
From: Scott Marlowe
Date:
Subject: Re: transitioning postgres oid