From: Craig Ringer <ringerc@ringerc.id.au>
To: Venkat Balaji <venkat.balaji@verse.in>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql 9.0.1 installation error
Date: Tue, 09 Aug 2011 10:52:13 +0800
Message-ID: <4E40A0DD.3090400@ringerc.id.au> (raw)
In-Reply-To: <CAFrxt0gxTJuqLtnXvvM=DEGQ+CJQMLt1UfdMJB4b8sEbTJO7uw@mail.gmail.com>
References: <CAFrxt0gxTJuqLtnXvvM=DEGQ+CJQMLt1UfdMJB4b8sEbTJO7uw@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ringerc@ringerc.id.au, venkat.balaji@verse.in
Subject: Re: Postgresql 9.0.1 installation error
In-Reply-To: <4E40A0DD.3090400@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox