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@xxxxxxxxx] Sent: Saturday, December 03, 2011 1:13 AM To: Myint Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Regarding postgres 9.1 with Redhat Linux On Fri, Dec 2, 2011 at 2:16 AM, Myint <myint@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
