Re: postgres 8.3.8 and Solaris 10_x86 64 bit problems?

u235sentinel píše v ne 18. 10. 2009 v 17:50 -0600:
> Are you sure about this?  When I try to build and don't have openssl in 
> the lib/include path it claims it needs it.  As I'm building 64 bit I 
> can now build postgres in 64 bit with openssl 98k just fine.  However 
> when I run it I'm getting the same error message.

If you want to link against to builtin OpenSSL you need following setup:

./configure ...
--with-openssl --with-includes=/usr/sfw/include
--with-libs=/usr/lib/amd64:/usr/sfw/lib/amd64

and important is:

LD_OPTIONS="-R/usr/sfw/lib/amd64 -L/usr/sfw/lib/amd64"

Or if you don't need own compilation, you can use built-in PostgreSQL
8.3. It is located in /usr/postgres/8.3/bin or /usr/postgres/8.3/bin/64.
See man postgres_83 for details. Also you need to apply last patch
138827-05:

http://sunsolve.sun.com/search/document.do?assetkey=1-21-138827-05-1

Or if you still needs own compilation try to compile openssl 98k with
Sun Studio.

Or  if you cannot compile it with Sun Studio, you can try -mimpure-text
gcc switch to compile OpenSSL. It is workaround for some kind of linking
issues.
Let me know it it helps Zdenek


> I'm curious if this is a lost hope.  My boss is recommending we flatten 
> the Sun box and install redhat linux (which I'm fine with).  I'd rather 
> not as threading in Solaris is better.
> 
> Thoughts?
> 
> thanks
> 
> 
> Zdenek Kotala wrote:
> > You can look on 
> > http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=ghost_moth&dt=2009-10-07%2021:06:00 
> >
> >
> > How it is built. You also does not needed own version of Openssl. All 
> > security fixes are backported.  It is located in /usr/sfw/lib or 
> > /usr/sfw/lib/64
> >
> > Sometimes are problem with gcc and solaris linker. IIRC, I had problem 
> > with PLPerl compilation.
> >
> >     Zdenek
> >
> > Dne  8.10.09 03:48, u235sentinel napsal(a):
> >> So I compiled postgres with Solaris 10 and have problems running it.
> >>
> >> # ./pg_ctl
> >> ld.so.1: pg_ctl: fatal: relocation error: R_AMD64_32: file 
> >> /usr/local/postgres64/lib/libpq.so.5: symbol (unknown): value 
> >> 0xfffffd7fff1cf210 does not fit
> >> Killed
> >>
> >> # ldd pg_ctl
> >>       libpq.so.5 =>    /usr/local/postgres64/lib/libpq.so.5
> >>       libm.so.2 =>     /usr/lib/64/libm.so.2
> >>       libxml2.so.2 =>  /usr/lib/64/libxml2.so.2
> >>       libz.so.1 =>     /usr/lib/64/libz.so.1
> >>       libreadline.so.6 =>      /usr/local/lib/libreadline.so.6
> >>       libcurses.so.1 =>        /usr/lib/64/libcurses.so.1
> >>       librt.so.1 =>    /usr/lib/64/librt.so.1
> >>       libsocket.so.1 =>        /usr/lib/64/libsocket.so.1
> >>       libc.so.1 =>     /usr/lib/64/libc.so.1
> >>       libpthread.so.1 =>       /usr/lib/64/libpthread.so.1
> >>       libnsl.so.1 =>   /lib/64/libnsl.so.1
> >>       libgcc_s.so.1 =>         /usr/sfw/lib/amd64/libgcc_s.so.1
> >>       libaio.so.1 =>   /lib/64/libaio.so.1
> >>       libmd.so.1 =>    /lib/64/libmd.so.1
> >>       libmp.so.2 =>    /lib/64/libmp.so.2
> >>       libscf.so.1 =>   /lib/64/libscf.so.1
> >>       libdoor.so.1 =>  /lib/64/libdoor.so.1
> >>       libuutil.so.1 =>         /lib/64/libuutil.so.1
> >>       libgen.so.1 =>   /lib/64/libgen.so.1
> >>
> >> # file /usr/local/postgres64/lib/libpq.so.5
> >> /usr/local/postgres64/lib/libpq.so.5:   ELF 64-bit LSB dynamic lib 
> >> AMD64 Version 1 [SSE CMOV], dynamically linked, not stripped
> >>
> >>
> >> What am I missing???
> >>
> >> Here's my environment.
> >>
> >> Solaris 10 x86_64 with postgres 8.3.8 and openssl 98k using gcc 
> >> version 3.4.3 (csl-sol210-3_4-branch+sol_rpath)
> >> , sunstudio12.1 and GNU Make 3.80
> >>
> >> I've even monkied with LD_LIBRARY_PATH but getting the same issues.  
> >> Seems when I don't compile in openssl everything is fine.
> >>
> >> Thanks!
> >>
> >
> >
> 
>