Error after updating postgresql
Hi, after upgrade to Mandrake 9.0, I can't start my postgresql server. I
find that when I run postmaster, I get the following message:
postmaster successfully started
PGSTAT: bind(2): Cannot assign requested address
I find that this is not related, there are no program using this port.
And even if I disable using TCP I still can't setup the server. However,
if I don't run "postmaster" but run "postgres", then it is ok to start.
I have check the log file, but don't get anything logged. Anyone know why?
--
\\\|///
\- - -//
( @ @ )
-----------oOOo-(_)-oOOo------------------------------------------------
Visit my homepage at http://www.carfield.com.hk
Programming discussion groups
Software design: news://news.carfield.com.hk/programming.design
Design Pattern: news://news.carfield.com.hk/programming.design.pattern
java: news://news.carfield.com.hk/programming.java
linux: news://news.carfield.com.hk/programming.linux
------------------------------------------------------------------------
On 1 Oct 2002 at 1:46, Carfield Yim wrote:
Hi, after upgrade to Mandrake 9.0, I can't start my postgresql server. I
find that when I run postmaster, I get the following message:postmaster successfully started
PGSTAT: bind(2): Cannot assign requested address
Check your config. Which port is this? Does it start without -i option? Is /tmp
full? Is it writable.
What is error in /var/log/messages?
HTH
Bye
Shridhar
--
Finagle's First Law: If an experiment works, something has gone wrong.
Carfield Yim <carfield@desktop.carfield.com.hk> writes:
Hi, after upgrade to Mandrake 9.0, I can't start my postgresql server. I
find that when I run postmaster, I get the following message:
postmaster successfully started
PGSTAT: bind(2): Cannot assign requested address
Your networking configuration is messed up: it's disallowing loopback
connections to 127.0.0.1.
If you can't fix that, you can set stats_start_collector = false in
postgresql.conf to disable statistics collection, but this isn't a
very good solution...
regards, tom lane
tgl@sss.pgh.pa.us (Tom Lane) wrote in message news:<25147.1033754452@sss.pgh.pa.us>...
Carfield Yim <carfield@desktop.carfield.com.hk> writes:
Hi, after upgrade to Mandrake 9.0, I can't start my postgresql server. I
find that when I run postmaster, I get the following message:postmaster successfully started
PGSTAT: bind(2): Cannot assign requested addressYour networking configuration is messed up: it's disallowing loopback
connections to 127.0.0.1.If you can't fix that, you can set stats_start_collector = false in
postgresql.conf to disable statistics collection, but this isn't a
very good solution...regards, tom lane
Thx, I find that my problem is there is error of /etc/init.d/network
which make my system don't have
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
after fixing this, postgresql run well, thx