[ADMIN] problems compiling postgres 8.3.7 on Solaris 10 64 bit with openssl
Not sure if this is the right list but here goes. I have gnu gcc and make on a Solaris 10 AMD64 system and having a bit of a problem compling postgres 8.3.7 with openssl. I've even tried with a newly compiled version of openssl. Verison 98 h-k. I did read the solaris faq and it hasn't helped. I"m curious if I"m missing a bit of instruction somewhere in the docs that will tip me off on how to build postgres. I've been able to build it just fine btw without openssl. But when I tie ssl in it seems to compile but running pg_ctl gives me a relocate error on libpq.so. I'll copy / paste the error if I'm in the right place :-) Thanks! -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] problems compiling postgres 8.3.7 on Solaris 10 64 bit with openssl
Joshua D. Drake wrote: On Thu, 2009-09-17 at 12:06 -0600, u235sentinel wrote: This doesn't answer your question but why not use prepackaged binaries? We're using prepackaged binaries from postgres.org and it seem to be core dumping or seg faulting... well.. at least psql is. It doesn't seem to be very stable. The 64 bit version at least. I figured after a couple weeks of working on this I'd just start over with my own build -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] problems compiling postgres 8.3.7 on Solaris 10 64 bit with openssl
John P Weatherman wrote: It would also be helpful to know what your LD_LIBRARY_PATH looks like and if you can do a 'find / -name libpq.so -print' to see where all the copies of this library may reside. Yeap, it's a fine place for it. Sorry for the quick post but I was rushing during lunch and I can't get gmail to work from work. Blocked on our proxy apparently :-( Here is the LIBRARY_PATH # echo $LD_LIBRARY_PATH /usr/local/ssl98k/lib:/usr/lib/amd64:/usr/sfw/lib/64:/usr/local/lib:/usr/sfw/lib:/usr/openwin/lib I've switched it all around to hopefully help find stuff. And btw, the ssl98k is a new 64 build I put together. There were errors using the one that came with solaris... weird. I'll write it down if interested. I figured the latest build should resolve any problems. And btw, ssl98k works great by itself. Seems pretty stable. Here is how I run configure # ./configure --prefix=/usr/local/postgres CC="cc -m64 -I/usr/local/ssl98k/include -L/usr/local/ssl98k/lib -I/usr/local/include" --with-openssl This runs fine however when I run make then try running pg_ctl (for example) here is the error I get /usr/local/postgres/bin/pg_ctl --help ld.so.1: pg_ctl: fatal: relocation error: R_AMD64_32: file /usr/local/postgres/lib/libpq.so.5: symbol (unknown): value 0xfd7fff1ccad0 does not fit Killed Thoughts on what I am doing wrong? And openssl is confirmed at 64 bit. # file openssl openssl:ELF 64-bit LSB executable AMD64 Version 1, dynamically linked, not stripped, no debugging information available I have this working just fine under 64 bit without openssl. It's very stable and all. But I do have a requirement to encrypt everything so I have to go this route. Thanks a bunch!! -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] problems compiling postgres 8.3.7 on Solaris 10 64 bit with openssl
I'm curious if there are any thoughts on what I'm missing here. The 64 bit postgres runs just fine without openssl. As soon as I tie that in I get headaches :/ Thanks! u235sentinel wrote: John P Weatherman wrote: It would also be helpful to know what your LD_LIBRARY_PATH looks like and if you can do a 'find / -name libpq.so -print' to see where all the copies of this library may reside. Yeap, it's a fine place for it. Sorry for the quick post but I was rushing during lunch and I can't get gmail to work from work. Blocked on our proxy apparently :-( Here is the LIBRARY_PATH # echo $LD_LIBRARY_PATH /usr/local/ssl98k/lib:/usr/lib/amd64:/usr/sfw/lib/64:/usr/local/lib:/usr/sfw/lib:/usr/openwin/lib I've switched it all around to hopefully help find stuff. And btw, the ssl98k is a new 64 build I put together. There were errors using the one that came with solaris... weird. I'll write it down if interested. I figured the latest build should resolve any problems. And btw, ssl98k works great by itself. Seems pretty stable. Here is how I run configure # ./configure --prefix=/usr/local/postgres CC="cc -m64 -I/usr/local/ssl98k/include -L/usr/local/ssl98k/lib -I/usr/local/include" --with-openssl This runs fine however when I run make then try running pg_ctl (for example) here is the error I get /usr/local/postgres/bin/pg_ctl --help ld.so.1: pg_ctl: fatal: relocation error: R_AMD64_32: file /usr/local/postgres/lib/libpq.so.5: symbol (unknown): value 0xfd7fff1ccad0 does not fit Killed Thoughts on what I am doing wrong? And openssl is confirmed at 64 bit. # file openssl openssl:ELF 64-bit LSB executable AMD64 Version 1, dynamically linked, not stripped, no debugging information available I have this working just fine under 64 bit without openssl. It's very stable and all. But I do have a requirement to encrypt everything so I have to go this route. Thanks a bunch!! -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] compiling postgres with static libraries?
Is there a way to compile postgres with static libraries instead of dynamic? I know it will make the binaries bigger but I have a need to do this. I've been reading through the make/automake, cc, gcc and ld man pages AND googling a bit. Not getting it to run properly. When I run the ./configure it says cc cannot create a test object when I try -d n, -B static or -static. What am I missing? I'm thinking this is something I need to do with ld and use LDFLAGS but that's just a guess. Thanks! -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] postgres 8.3.8 and Solaris 10 problems?
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 0xfd7fff1cf210 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 Thanks! -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] compile postgresql with krb
rahimeh khodadadi wrote: Hi, When I compile postgresql 8.4.1 as below , it gives error like "checking for library containing krb5_sendauth... no configure: error: could not find function 'krb5_sendauth' required for Kerberos 5 " Of course, I already installled the krb-libs ./configure --with-krb5 --without-readline --without-zlib --with-openssl Please help me. wish I can help but I can't get this dang thing to compile myself without it freaking out during run time. It's weird. I know my problem is with Solaris. Should have installed Linux instead. I've built this several times already with RedHat and Ubuntu. Still not sure how to get it building properly under Solaris :/ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] postgres 8.3.8 and Solaris 10 problems?
raghu ram wrote: could you please try to start the Postgres service using below steps cd /bin ./pg_ctl -D < data directory path> start Thanks & Regards Raghu I've tried to initially start it and am getting the same results with the above command :/ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Postgres Triggers issue
I have a strange problem we noticed the other day with triggers. We're running 8.3.3 on Solaris 10 (intel) and have a feed that comes in regularly to populate a table we're working on. The feed works just fine inserting rows however the following trigger stops the feed until we remove the trigger. Any thoughts on what I'm doing wrong here? Thanks! --- CREATE OR REPLACE FUNCTION r.m_t() RETURNS trigger AS $BODY$ BEGIN INSERT INTO temp_m_t VALUES (NEW.*,1+1); RETURN NULL; END; $BODY$ LANGUAGE 'plpgsql'; CREATE TRIGGER tafter AFTER INSERT OR UPDATE ON r.m_a FOR EACH ROW EXECUTE PROCEDURE r.m_t(); -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
