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!
> >>
> >
> >
>
>