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