Hi All,
Tcp problem already fixed. But now there is serious problem when we query into database by using ./psql -U postgres -d
postgresand 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.marlowe@gmail.com]
Sent: Saturday, December 03, 2011 1:13 AM
To: Myint
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Regarding postgres 9.1 with Redhat Linux
On Fri, Dec 2, 2011 at 2:16 AM, Myint <myint@oneempower.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?