[ADMIN] Regarding postgres 9.1 with Redhat Linux

[Myint]

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





Your faster response if very much appreciated. Thank you.



Regards,

Myint WIn

[Kevin Grittner]

Post by Myint
LOG: could not bind IPv4 socket: Address already in use

I suspect that the rpm set up a cluster at a default location,
configured it to start automatically, and started it. You've
created another cluster offering a connection on the same port. You
need to just use the default cluster, stop and disable the default
cluster, or change the port number used by your new installation
(probably by modifying the postgresql.conf file).

-Kevin

[Scott Marlowe]

Post by Myint
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?

[Myint]

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:***@gmail.com]
Sent: Saturday, December 03, 2011 1:13 AM
To: Myint
Cc: pgsql-***@postgresql.org
Subject: Re: [ADMIN] Regarding postgres 9.1 with Redhat Linux

Post by Myint
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?

[Tank.zhang]

hi:
" HINT: Is another postmaster already running on port 5432? If not, wait afew seconds and retry."
please check system port 5432 runing?



------------------ Original ------------------
From: "Scott Marlowe"<***@gmail.com>;
Date: Sat, Dec 3, 2011 01:13 AM
To: "Myint"<***@oneempower.com>;
Cc: "pgsql-admin"<pgsql-***@postgresql.org>;
Subject: Re: [ADMIN] Regarding postgres 9.1 with Redhat Linux

Post by Myint
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?

--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin