Message-ID: <4E42216A.4090109@ringerc.id.au>
Date: Wed, 10 Aug 2011 14:12:58 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:5.0) Gecko/20110624 Thunderbird/5.0
MIME-Version: 1.0
To: Venkat Balaji <venkat.balaji@verse.in>
CC: pgsql-admin@postgresql.org
Subject: Re: Postgresql 9.0.1 installation error
References: 
 <CAFrxt0gxTJuqLtnXvvM=DEGQ+CJQMLt1UfdMJB4b8sEbTJO7uw@mail.gmail.com>
	<4E40A0DD.3090400@ringerc.id.au>
	<CAFrxt0gaYk1DFx3YThNj6Qu3DQ7HF6vnd3dvOhYXp9FLwDLueg@mail.gmail.com>
In-Reply-To: 
 <CAFrxt0gaYk1DFx3YThNj6Qu3DQ7HF6vnd3dvOhYXp9FLwDLueg@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
> (mockbuild@x86-004.build.bos.redhat.com
> <mailto: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

OK. In that case, please show the output of:

ldd ./psql

run in exactly the same environment as you'd run ./psql and get a crash.


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

OK, you haven't built with debugging. Try rebuilding with --enable-debug 
to configure, then re-running the gdb command. When you get a crash and 
the above message is printed out, you'll get a prompt like:

(gdb)

Type "bt" at that prompt and press enter. The resulting stack trace 
shows more information about what led up to the crash.

Debugging memory related crashes in C isn't simple. Just because it 
crashes in libpq doesn't mean the fault is in libpq. It might be, or it 
might be that some other library is corrupting memory that causes libpq 
to crash later, corrupting the stack, returning a bad pointer from a 
function call, library headers not matching linked library sizes so 
returned struct sizes/offsets are wrong, and lots lots more. It's not 
simple.

--
Craig Ringer