Re: [ADMIN] Postgresql 9.0.1 installation error

2011-08-15 Thread Venkat Balaji
Hi, This issue is resolved. Root Cause - 1. libpq library compilation problem 2. make file had the old configurations of previously performed installations Solution 1 - "make clean" must be fired after "./configure" command and before "make install" command. Other work around ( possibly ) -

Re: [ADMIN] Postgresql 9.0.1 installation error

2011-08-10 Thread Venkat Balaji
Thanks Craig for your detailed explanation ! I had rebuilt the PG 9.0.1 with --enable-debug option. As of now, i had downloaded a fresh package and re-installed. Its perfectly working fine for me. I will further try to debug this issue. Will let you know what i find. Thanks Nag On Wed, Aug 10,

Re: [ADMIN] Postgresql 9.0.1 installation error

2011-08-10 Thread Craig Ringer
On 10/08/2011 3:43 PM, Venkat Balaji wrote: libpq.so.5 => /opt/Postgres9.0.1/lib/libpq.so.5 OK, so it looks like it's runtime linking to the correct libpq, assuming that the copy in /opt/Postgres9.0.1/ is the one for ... well .. 9.0.1 . That was my first suspicion about what might b

Re: [ADMIN] Postgresql 9.0.1 installation error

2011-08-10 Thread Venkat Balaji
Below is the output of "ldd" and "gdb output with 'bt argument' " ldd output [postgres@warehouse1 bin]$ ldd ./psql libpq.so.5 => /opt/Postgres9.0.1/lib/libpq.so.5 (0x2b354bb1a000) libedit.so.0 => /usr/lib64/libedit.so.0 (0x2b354bd49000) libc.so.6 => /lib64

Re: [ADMIN] Postgresql 9.0.1 installation error

2011-08-09 Thread Craig Ringer
On 9/08/2011 2:31 PM, Venkat Balaji wrote: Hi Craig, Thank you very much for your reply ! Here is my reply - 1. We are using RHEL with the below version Linux version 2.6.18-194.26.1.el5 (mockbu...@x86-004.build.bos.redhat.com ) (gcc version 4.1.2

Re: [ADMIN] Postgresql 9.0.1 installation error

2011-08-09 Thread Venkat Balaji
Hi, I tried installing without "--with-openssl" option. The installation was successful and ./psql is working perfectly ok. So, i suspect this is because of enabling openssl option. Thanks Nag On Tue, Aug 9, 2011 at 12:01 PM, Venkat Balaji wrote: > Hi Craig, > > Thank you very much for your re

Re: [ADMIN] Postgresql 9.0.1 installation error

2011-08-08 Thread Venkat Balaji
Hi Craig, Thank you very much for your reply ! Here is my reply - 1. We are using RHEL with the below version Linux version 2.6.18-194.26.1.el5 (mockbu...@x86-004.build.bos.redhat.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-48)) #1 SMP Fri Oct 29 14:21:16 EDT 2010 2. LD_LIBRARY_PATH is not

Re: [ADMIN] Postgresql 9.0.1 installation error

2011-08-08 Thread Craig Ringer
On 8/08/2011 7:11 PM, Venkat Balaji wrote: We had installed PostgreSQL9.0.1 for which i had executed the below commands - ./configure --with-openssl --prefix=/opt/Postgresql9.0.1/ make install installed successfully OK, you're building Pg from source rather than using packages provided by ED

Re: [ADMIN] Postgresql 9.0.1 installation error

2011-08-08 Thread Lou Picciano
r ecpg . First off, have you read through your build logs? Are you sure everything is happening as you expect? - Original Message - From: "Venkat Balaji" To: "Lou Picciano" Cc: pgsql-admin@postgresql.org Sent: Monday, August 8, 2011 8:11:41 AM Subject: Re: [ADMIN]

Re: [ADMIN] Postgresql 9.0.1 installation error

2011-08-08 Thread Venkat Balaji
Yes, i can connect from the different bin without any issues, but, may not be able to get the SSL services, since that built is not SSL compiles. Below is the detailed explaination - Here is what i have done - ./configure --with-openssl --prefix=/opt/Postgresql9.0.1/ make install The below bin