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

Zdenek Kotala wrote:
> Andrew Chernow píše v po 19. 10. 2009 v 14:14 -0400:
>   
>>> # ./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
>>>       
{snip}
>>> /usr/local/postgres64/lib/libpq.so.5:   ELF 64-bit LSB dynamic lib AMD64 
>>> Version 1 [SSE CMOV], dynamically linked, not stripped
>>>
>>> Ok.  So looking good. Maybe there is a library or header libpq needs 
>>> that I'm missing in 64 bit?
>>>
>>> # ldd /usr/local/postgres64/lib/libpq.so.5
>>>       
>> Are you sure that all pg_ctl referenced libraries and all libpq.so 
>> referenced libraries were built as 64-bit using PIC?  Are you linking 
>> with any static library that may contain 32-bit objects?  That error is 
>> most commonly PIC or arch-mismatch.
>>
>>     
>
> Agree, I went through linker bugs and missing PIC is often root cause of
> this problem. See
>
> http://bugs.opensolaris.org/bugdatabase/view_bug.do?bug_id=6261066
>
> Problem was that ./configure badly setup PIC switch on amd64 platform.
>
> Please, could you compile pure postgreSQL without other own libraries
> like readline and openssl? It should help to find which library is
> culprit.
>
>     Zdenek
>
>
>
>   
I really appreciate all the comments about this problem.  I'm not a 
developer but I've been around the block a few times here.

I "think" I have it working now.  At least it compiled and I was able to 
run initdb, pg_ctl and psql to login to my new test database.  All in 64 
bit with openssl compiled in.

How I did it.

I've been SO focued on postgres thinking it was the entire problem that 
I forgot about ssl.  Even though openssl compiled just fine, it 
contributed to the problem.  After recompiling it with gcc and using 
-fpic and -m64 I recompiled postgres also with -fpic and -m64.  Seems 
that was the magic sauce here.

Now I'm running and will add a few more things in like readline.  The 
goal is to build plr and plperl and load them into postgres.

Crossing my fingers those will go smoother.

Thanks a bunch!!