Re: Regarding postgres 9.1 with Redhat Linux

Hi All,

Tcp problem already fixed. But now there is serious problem when we query into database by using ./psql -U postgres -d postgres and show as following.

./psql: line 30: 21991 Segmentation fault LD_LIBRARY_PATH=$PG_BIN_PATH/../lib:$LD_LIBRARY_PATH "$PG_BIN_PATH/psql.bin" "

Our linux version as following .
Linux
2.6.18-164.el5xen

Your support is much appreciated.

Regards,
Myint

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Saturday, December 03, 2011 1:13 AM
To: Myint
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Regarding postgres 9.1 with Redhat Linux

On Fri, Dec 2, 2011 at 2:16 AM, Myint <myint(at)oneempower(dot)com> wrote:
> Dear admin,
>
>
>
>                    We have installed postgres 9.1 rpm package to red hat
> Linux  2.6.18- x86_64 x86_64 x86_64 GNU/Linux. After we setup and install
> database we can create data folder on /app/postgres/oe. But when we try to
> start up the database as  ./pg_ctl -D /app/postgres/oe start. It was giving
> the following error. Could you please advise how to solve this problem? Or
> should we back up data and re-install everything from begin? The error we
> received as following.
>
>
>
> LOG:  could not bind IPv4 socket: Address already in use
>
> HINT:  Is another postmaster already running on port 5432? If not, wait a
> few seconds and retry.
>
> WARNING:  could not create listen socket for "localhost"
>
> FATAL:  could not create any TCP/IP sockets

Sounds like you've already got an old version of pg installed. Either
change the 9.1 install to use a different port, shut down or uninstall
the old version. What does "ps ax|grep postgres" say about other
processes on the machine?