|
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
DISCLAIMER: |
