From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Marc Liyanage <liyanage@access.ch>
Cc: pgsql-docs@postgresql.org
Subject: Re: Re: PostgreSQL solaris faq
Date: Wed, 18 Oct 2000 17:18:24 -0400 (EDT)
Message-ID: <200010182118.RAA17847@candle.pha.pa.us> (raw)
In-Reply-To: <p0500190db613b05e88f3@195.49.55.21>
Added.
>
> Hi there, I just received this for inclusion into
> the solaris faq:
>
> --------------------------------------
>
>
>
> From: Michel Decima <michel.decima@rd.francetelecom.fr>
> To: <liyanage@access.ch>
> Subject: PostgreSQL Solaris FAQ
> Date: Wed, 18 Oct 2000 18:28:02 +0200
>
> hello,
>
> I see you are the maintainer of the PostgreSQL Solaris FAQ, so i submit
> to you something to add:
>
> If you compile postgreSQL on a solaris box with GNU gcc and GNU ld, you
> will have troubles with procedural languages. The error message is for
> plpgsql :
>
> 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 CurrentMemoryContext: referenced
> symbol not found
>
> (and the same for pltcl).
>
> the solution is to use the --export-dynamic switch when linking postgres
> executable. You can add the following line to the solaris_sparc_gcc
> template:
>
> LDFLAGS:-Wl,--export-dynamic
>
> I found this hint here:
> http://www.postgresql.org/mhonarc/pgsql-hackers/2000-03/msg00030.html
>
> I spent two days in the mailing lists archives and hacking around, so I think
> the solaris FAQ is a good place to put this hint ;)
>
>
> MD.
>
> some infos about my configuration :
>
>
> OS: Solaris 2.7
>
> Used Software:
> gcc-2.95.2
> make-3.79
> binutils-2.9.1
> flex-2.5.4
> bison-1.28
>
> Source: postgresql-7.0.2
> Configuration:
> ./configure \
> --prefix=/usr/local/pgsql \
> --with-x \
> --with-perl \
> --with-odbc \
> --without-CXX \
> --with-tcl \
> --with-includes=/usr/local/pgtools/include \
> --with-libs=/usr/local/pgtools/lib \
> --with-tclconfig=/usr/local/pgtools/lib \
> --with-tkconfig=/usr/local/pgtools/lib
>
> Environment variables:
> PGHOME=/usr/local/pgsql
> PGLIB=/usr/local/pgsql/lib
> PGDATA=/var/local/lib/pgsql/data
> LD_LIBRARY_PATH=/lib:/usr/lib:/usr/openwin/lib:/usr/local/pgsql/lib
> --
> _________________________________________________________________
> Marc Liyanage liyanage@access.ch
> http://www.access.ch/ml
>
> Experience is what you get when you didn't get what you wanted
> _________________________________________________________________
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: pgman@candle.pha.pa.us, liyanage@access.ch
Subject: Re: Re: PostgreSQL solaris faq
In-Reply-To: <200010182118.RAA17847@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox