I've had exactly same problem with PostgreSQL 6.4.x and 6.5.0 on Solaris
2.5.1 and 7 (latest GNU compilers and tools). Since I didn't have time
to delve into code to find out why and not a priority, I installed
RedHat 5.2 (then 6) on my Sun Sparc and PostgreSQL worked ok, compiling
6.4.2 and 6.5 from scratch. The error occurs with the various regression
tests involving triggers and functions that want to load shareable
library to resolve "SPI_" variables. Otherwise, in compilation of
PostgreSQL, there is no other indication of problems and system works
perfectly ok under Solaris.
Callum
David Ouellet wrote:
>
> It is a new install on Solaris 7. There is no file /etc/ld.so so following
> the instructions, I added /usr/local/pgsql/lib to my LD_LIBRARY_PATH.
>
> Terry Mackintosh wrote:
>
> > Hi David
> >
> > Is this a new install? on a Linux box? if so did you add
> > /usr/local/pgsql/lib to /etc/ld.so.conf and then run ldconfig? That is
> > what is sounds like you did not do.
> >
> > David Ouellet wrote:
> > >
> > > I'm having the following problem with functions and triggers (and it
> > > isn't an SQL problem.)
> > >
> > > With PostgreSQL version 6.4.2 when I try to use a function or trigger
> > > (either in C or plpgsql) I get the following message:
> > >
> > > ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: ld.so.1:
> > > /usr/local/pgsql/bin/postmaster: fatal: relocation error: file
> > > /usr/local/pgsql/lib/plpgsql.so: symbol SPI_tuptable: referenced symbol
> > > not found
> > >
> > > The actual symbol not found depends on the function but it seems to me
> > > that
> > > the dynamic loader is having some problems. I know that these symbols
> > > are located in the posgres executable but the loader does not.
> > >
> > > I then compiled and installed version 6.5.1 but I get the following
> > > error message when trying to start the Postmaster process:
> > >
> > > IpcMemoryCreate: shmget failed (Invalid argument) key=5423001,
> > > size=1073152, permission=600
> > > FATAL 1: ShmemCreate: cannot create region
> > >
> > > If somebody has any ideas on how to fix either of these problems, please
> > >
> > > let me know.
> > >
> > > Thanks
