[ADMIN] problems compiling postgres 8.3.7 on Solaris 10 64 bit with openssl

2009-09-17 Thread u235sentinel
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 helpe

Re: [ADMIN] problems compiling postgres 8.3.7 on Solaris 10 64 bit with openssl

2009-09-17 Thread u235sentinel
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 ps

Re: [ADMIN] problems compiling postgres 8.3.7 on Solaris 10 64 bit with openssl

2009-09-17 Thread u235sentinel
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 d

Re: [ADMIN] problems compiling postgres 8.3.7 on Solaris 10 64 bit with openssl

2009-09-19 Thread u235sentinel
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 l

[ADMIN] compiling postgres with static libraries?

2009-10-05 Thread u235sentinel
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 ./config

[ADMIN] postgres 8.3.8 and Solaris 10 problems?

2009-10-06 Thread u235sentinel
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/postg

Re: [ADMIN] compile postgresql with krb

2009-10-07 Thread u235sentinel
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

Re: [ADMIN] postgres 8.3.8 and Solaris 10 problems?

2009-10-08 Thread u235sentinel
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 lis

[ADMIN] Postgres Triggers issue

2010-02-10 Thread u235sentinel
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 tri