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
> >
> > ------------------------------------------------------------
> > David Ouellet Defence Research Establishment
> > Computer Engineer Val-Cartier
> > ------------------------------------------------------------
>
> --
>
> Make it a great day
> Terry Mackintosh <[EMAIL PROTECTED]> http://www.terrym.com
> sysadmin/owner I'm excited about life! How about YOU!?
> Professional Web Hosting and site design to include programming
> Proudly powered by R H Linux, Apache, PHP, PostgreSQL, other Open Source
> -----------------------------------------------------------------------
> Only if you know where you're going can you get there.
------------------------------------------------------------
David Ouellet Defence Research Establishment
Computer Engineer Val-Cartier
------------------------------------------------------------
