pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCannot bind socket
2+ messages / 2 participants
[nested] [flat]
* Cannot bind socket
@ 2008-01-18 13:15 Suresh Gupta VG <suresh.g@zensar.com>
2008-01-18 15:42 ` Re: Cannot bind socket Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Suresh Gupta VG @ 2008-01-18 13:15 UTC (permalink / raw)
To: pgsql-admin; +Cc: Anupam Kumar <anupam.k@zensar.com>
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.g@zensar.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.
Attachments:
image001.jpg (image/jpeg, 3.1K) download
view image
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Cannot bind socket
2008-01-18 13:15 Cannot bind socket Suresh Gupta VG <suresh.g@zensar.com>
@ 2008-01-18 15:42 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2008-01-18 15:42 UTC (permalink / raw)
To: Suresh Gupta VG <suresh.g@zensar.com>; +Cc: pgsql-admin@postgresql.org, "Anupam Kumar" <anupam.k@zensar.com>
"Suresh Gupta VG" <suresh.g@zensar.com> writes:
> 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
AFAICT you do not have a problem here. The database started up fine.
If you don't like the chatter in the log, fix your name resolution setup
(/etc/hosts or DNS) so that it doesn't return a non-working translation
of "localhost". It looks to me like it probably returns both IPv6 and
IPv4 translations when the kernel will only take one of them.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-01-18 15:42 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-18 13:15 Cannot bind socket Suresh Gupta VG <suresh.g@zensar.com>
2008-01-18 15:42 ` Tom Lane <tgl@sss.pgh.pa.us>
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