Postgres Pro
Downloads
Home   >   mailing lists

Thread: Error after updating postgresql

Error after updating postgresql

From
Carfield Yim
Date:
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
------------------------------------------------------------------------

Re: Error after updating postgresql

From
"Shridhar Daithankar"
Date:
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.

Re: Error after updating postgresql

From
Tom Lane
Date:
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

Re: Error after updating postgresql

From
carfield@programmer.net (Carfield Yim)
Date:
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