pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRegarding postgres 9.1 with Redhat Linux
5+ messages / 4 participants
[nested] [flat]
* Regarding postgres 9.1 with Redhat Linux
@ 2011-12-02 09:16 Myint <myint@ONEEMPOWER.COM>
2011-12-02 17:07 ` Re: Regarding postgres 9.1 with Redhat Linux Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-12-02 17:13 ` Re: Regarding postgres 9.1 with Redhat Linux Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Myint @ 2011-12-02 09:16 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Regarding postgres 9.1 with Redhat Linux
2011-12-02 09:16 Regarding postgres 9.1 with Redhat Linux Myint <myint@ONEEMPOWER.COM>
@ 2011-12-02 17:07 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
1 sibling, 0 replies; 5+ messages in thread
From: Kevin Grittner @ 2011-12-02 17:07 UTC (permalink / raw)
To: Myint <myint@ONEEMPOWER.COM>; pgsql-admin
"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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Regarding postgres 9.1 with Redhat Linux
2011-12-02 09:16 Regarding postgres 9.1 with Redhat Linux Myint <myint@ONEEMPOWER.COM>
@ 2011-12-02 17:13 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-19 04:03 ` Re: Regarding postgres 9.1 with Redhat Linux Myint <myint@ONEEMPOWER.COM>
1 sibling, 1 reply; 5+ messages in thread
From: Scott Marlowe @ 2011-12-02 17:13 UTC (permalink / raw)
To: Myint <myint@oneempower.com>; +Cc: pgsql-admin
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?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Regarding postgres 9.1 with Redhat Linux
2011-12-02 09:16 Regarding postgres 9.1 with Redhat Linux Myint <myint@ONEEMPOWER.COM>
2011-12-02 17:13 ` Re: Regarding postgres 9.1 with Redhat Linux Scott Marlowe <scott.marlowe@gmail.com>
@ 2011-12-19 04:03 ` Myint <myint@ONEEMPOWER.COM>
0 siblings, 0 replies; 5+ messages in thread
From: Myint @ 2011-12-19 04:03 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: 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 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.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?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Regarding postgres 9.1 with Redhat Linux
@ 2011-12-03 00:32 Tank.zhang <6220104@qq.com>
0 siblings, 0 replies; 5+ messages in thread
From: Tank.zhang @ 2011-12-03 00:32 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; Myint <myint@oneempower.com>; +Cc: pgsql-admin
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"<scott.marlowe@gmail.com>;
Date: Sat, Dec 3, 2011 01:13 AM
To: "Myint"<myint@oneempower.com>;
Cc: "pgsql-admin"<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?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2011-12-19 04:03 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-12-02 09:16 Regarding postgres 9.1 with Redhat Linux Myint <myint@ONEEMPOWER.COM>
2011-12-02 17:07 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-12-02 17:13 ` Scott Marlowe <scott.marlowe@gmail.com>
2011-12-19 04:03 ` Myint <myint@ONEEMPOWER.COM>
2011-12-03 00:32 Re: Regarding postgres 9.1 with Redhat Linux Tank.zhang <6220104@qq.com>
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