Skip site navigation (1) Skip section navigation (2)

Re: Re: PostgreSQL solaris faq

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Marc Liyanage <liyanage(at)access(dot)ch>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Re: PostgreSQL solaris faq
Date: 2000-10-18 21:18:24
Message-ID: 200010182118.RAA17847@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-docs
Added.


> 
> Hi there, I just received this for inclusion into
> the solaris faq:
> 
> --------------------------------------
> 
> 
> 
> From: Michel Decima <michel(dot)decima(at)rd(dot)francetelecom(dot)fr>
> To: <liyanage(at)access(dot)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(at)access(dot)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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2000-10-19 01:43:08
Subject: Re: Re: PostgreSQL solaris faq
Previous:From: Marc LiyanageDate: 2000-10-18 19:55:02
Subject: Re: PostgreSQL solaris faq

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group