Skip site navigation (1) Skip section navigation (2)

Cannot bind socket

From: "Suresh Gupta VG" <suresh(dot)g(at)zensar(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Cc: "Anupam Kumar" <anupam(dot)k(at)zensar(dot)com>
Subject: Cannot bind socket
Date: 2008-01-18 13:15:17
Message-ID: 3D5445983859B84B92669C0D883EA6FB0BE4E371@ZENMAILHQ1.ind.zensar.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi team,

 

I am using pgsql 8.2.5 on Solaris 9 sparc machine. I had a separate
server which contains my application running. I need to connect the
database from the application server same configuration Solaris 9. I am
trying to add the IP address and net mask number in the "pg_hba.conf" of
postgresql. When I restart the database, it is giving an error "LOG:
could not bind socket for statistics collector: Cannot assign requested
address". And the logs are telling the same error. Can any one help me
in this issue.

 

 

bash-2.05$ pg_ctl restart -D /db1/postgresql/data -o "-N 100 -B 200 -i"

LOG:  received smart shutdown request

LOG:  shutting down

waiting for server to shut down....LOG:  database system is shut down

 done

server stopped

server starting

bash-2.05$ LOG:  could not bind socket for statistics collector: Cannot
assign requested address

LOG:  trying another address for the statistics collector

LOG:  database system was shut down at 2008-01-18 16:06:04 AST

LOG:  checkpoint record is at 0/CBB0A0

LOG:  redo record is at 0/CBB0A0; undo record is at 0/0; shutdown TRUE

LOG:  next transaction ID: 0/788; next OID: 16632

LOG:  next MultiXactId: 1; next MultiXactOffset: 0

LOG:  database system is ready

 

 

LOG file .........

------------------

Sun Microsystems Inc.   SunOS 5.9       Generic May 2002

postmaster successfully started

LOG:  could not bind socket for statistics collector: Cannot assign
requested address

LOG:  database system was shut down at 2005-01-25 12:53:20 AST

LOG:  checkpoint record is at 0/4865778

LOG:  redo record is at 0/4865778; undo record is at 0/0; shutdown TRUE

LOG:  next transaction ID: 37753; next OID: 214365

LOG:  database system is ready

Regards,

G. V. Suresh Gupta

------------------------------------------------------------------------
---------------------------------------------------------

Innovative Technology Solutions(ITS), Zensar Technologies 

Zensar Knowledge Park, Plot#5, MIDC IT Tower, 

Kharadi, Off Nagar Road, Pune - 411014

Landline :  +91-20-66453471           | +91-9890898688                 

Email     :   suresh(dot)g(at)zensar(dot)com    | website:  www.zensar.com
<http://www.zensar.com/> 

 

 

 

 

 

 



DISCLAIMER:
This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails. 

Responses

pgsql-admin by date

Next:From: Jessica RichardDate: 2008-01-18 13:46:33
Subject: Re: select only user
Previous:From: Kevin KempterDate: 2008-01-18 04:45:25
Subject: more blob questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group