pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: PostgreSQL solaris faq
6+ messages / 4 participants
[nested] [flat]
* Re: PostgreSQL solaris faq
@ 2000-10-18 19:55 Marc Liyanage <liyanage@access.ch>
0 siblings, 1 reply; 6+ messages in thread
From: Marc Liyanage @ 2000-10-18 19:55 UTC (permalink / raw)
To: pgsql-docs
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
_________________________________________________________________
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Re: PostgreSQL solaris faq
@ 2000-10-18 21:18 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Marc Liyanage <liyanage@access.ch>
0 siblings, 1 reply; 6+ messages in thread
From: Bruce Momjian @ 2000-10-18 21:18 UTC (permalink / raw)
To: Marc Liyanage <liyanage@access.ch>; +Cc: pgsql-docs
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Re: PostgreSQL solaris faq
@ 2000-10-19 01:43 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2000-10-19 01:43 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Marc Liyanage <liyanage@access.ch>; pgsql-docs
Instead of putting this in the FAQ, why don't we fix the solaris
template files!?
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Re: PostgreSQL solaris faq
@ 2000-10-19 01:45 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Bruce Momjian @ 2000-10-19 01:45 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Marc Liyanage <liyanage@access.ch>; pgsql-docs
I have no idea why it would not always be in there. Solaris guys?
> Instead of putting this in the FAQ, why don't we fix the solaris
> template files!?
>
> regards, tom lane
>
--
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Re: PostgreSQL solaris faq
@ 2000-10-19 14:44 Peter Eisentraut <peter_e@gmx.net>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Peter Eisentraut @ 2000-10-19 14:44 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Marc Liyanage <liyanage@access.ch>; pgsql-docs
Bruce Momjian writes:
> I have no idea why it would not always be in there. Solaris guys?
This only works for the GNU linker. I was going to write up a configure
test for that in the next few days.
(Btw., there is no solaris_sparc_gcc template. The entry is wrong.)
>
>
> > Instead of putting this in the FAQ, why don't we fix the solaris
> > template files!?
> >
> > regards, tom lane
> >
>
>
>
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Re: PostgreSQL solaris faq
@ 2000-10-19 15:54 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2000-10-19 15:54 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Marc Liyanage <liyanage@access.ch>; pgsql-docs
Good answer. THanks.
> Bruce Momjian writes:
>
> > I have no idea why it would not always be in there. Solaris guys?
>
> This only works for the GNU linker. I was going to write up a configure
> test for that in the next few days.
>
> (Btw., there is no solaris_sparc_gcc template. The entry is wrong.)
>
> >
> >
> > > Instead of putting this in the FAQ, why don't we fix the solaris
> > > template files!?
> > >
> > > regards, tom lane
> > >
> >
> >
> >
>
> --
> Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
>
>
--
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2000-10-19 15:54 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-18 19:55 Re: PostgreSQL solaris faq Marc Liyanage <liyanage@access.ch>
2000-10-18 21:18 ` Bruce Momjian <pgman@candle.pha.pa.us>
2000-10-19 01:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-10-19 01:45 ` Bruce Momjian <pgman@candle.pha.pa.us>
2000-10-19 14:44 ` Peter Eisentraut <peter_e@gmx.net>
2000-10-19 15:54 ` Bruce Momjian <pgman@candle.pha.pa.us>
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