Received: from candle.pha.pa.us (pgman@nav-43.dsl.navpoint.com [162.33.245.46]) by hub.org (8.10.1/8.11.0) with ESMTP id e9ILIeP92997 for ; Wed, 18 Oct 2000 17:18:40 -0400 (EDT) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id RAA17847; Wed, 18 Oct 2000 17:18:24 -0400 (EDT) From: Bruce Momjian Message-Id: <200010182118.RAA17847@candle.pha.pa.us> Subject: Re: Re: PostgreSQL solaris faq In-Reply-To: "from Marc Liyanage at Oct 18, 2000 09:55:02 pm" To: Marc Liyanage Date: Wed, 18 Oct 2000 17:18:24 -0400 (EDT) CC: pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL77 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200010/23 X-Sequence-Number: 338 Added. > > Hi there, I just received this for inclusion into > the solaris faq: > > -------------------------------------- > > > > From: Michel Decima > To: > 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