Обсуждение: Regarding postgres 9.1 with Redhat Linux
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
"Myint" <myint@ONEEMPOWER.COM> wrote: > 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
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?
> 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-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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?