Re: Postgresql 9.0.1 installation error - Mailing list pgsql-admin

From Venkat Balaji
Subject Re: Postgresql 9.0.1 installation error
Date
Msg-id CAFrxt0iALqDJhFd55YC22npfEgKFJA4PeMzMhC6LLU=6VWgRew@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql 9.0.1 installation error  (Venkat Balaji <venkat.balaji@verse.in>)
List pgsql-admin
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 <venkat.balaji@verse.in> 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 (mockbuild@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 set
3. Yes, this seems to be a libpq settings problem.
     Below is the GDB result -

    [postgres@warehouse1 bin]$ ./psql -p 5444
LOG:  unexpected EOF on client connection
Segmentation fault
[postgres@warehouse1 bin]$ gdb --args ./psql -p 5444
GNU gdb (GDB) Red Hat Enterprise Linux (7.0.1-23.el5_5.2)
Copyright (C) 2009 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
Reading symbols from /opt/Postgres9.0.1/bin/psql...(no debugging symbols found)...done.
(gdb) run
Starting program: /opt/Postgres9.0.1/bin/psql -p 5444
[Thread debugging using libthread_db enabled]

Program received signal SIGSEGV, Segmentation fault.
0x00002aaaaaac2ecc in resetPQExpBuffer () from /opt/Postgres9.0.1/lib/libpq.so.5

Thanks
Nag

On Tue, Aug 9, 2011 at 8:22 AM, Craig Ringer <ringerc@ringerc.id.au> wrote:
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 EDB or your operating system. Fair enough, albeit somewhat unusual for many production setups.


When i said "./psql -p 5445", I am getting the below error

The most likely cause is that the dynamic linker is using a different library than what Pg was compiled against for libssl, libpg, or something like that.

You have neglected to mention the platform you're using or any of the other important data, so it's hard to give any more detailed instructions about how to track the issue down. It'd help if you mentioned what OS you were using, whether you uninstalled/deleted any prior versions of Pg, what your LD_LIBRARY_PATH is, what `ldd' reports when run on psql, etc.


[postgres@warehouse1 bin]$ ./psql -p 5445
LOG:  unexpected EOF on client connection
Segmentation fault

Most likely you have linkage problems, but if not it'd help if you'd get a backtrace of that client crash. Assuming you're on a machine with gdb:

gdb --args ./psql -p 5445
(gdb) run
.... blah blah
.... terminated with SIGSEGV (Segmentation fault)
(gdb) bt

   2. The same version of PostgreSQL was installed in the     same server in a
different location and is working fine without any issues -
3. Postgres process is running fine. When i am connecting from a
different PG installer bin directory,
    I am able to connect.

It's *EXTREMELY* likely to be an issue where you're linking to a different libpq possibly compiled with different options, then.

--
Craig Ringer


pgsql-admin by date:

Previous
From: Venkat Balaji
Date:
Subject: LDAP configuration
Next
From: Raghavendra
Date:
Subject: Re: Postgres process