Re: Troubles Starting Postgres

From: Derek Neighbors <derek(at)gnue(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Troubles Starting Postgres
Date: 2002-03-30 18:57:51
Message-ID: 20020330115751.080ad603.derek@gnue.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> PGSTAT tries to bind to 127.0.0.1 to create a loopback UDP path for
> passing statistics data. Not clear why this would fail unless you
> have some network filtering software in there to prevent it. Without
> more info about your platform, network config, etc, there's little
> more I can say...

Bad luser no donut.

Seems when i configured this box in /etc/hosts I put

127.0.0.1 computername localhost (instead of)
127.0.0.1 localhost computername

Which made 'auto lo' fail in my interfaces file which during debugging got commented out. Subsequently when the machine was rebooted a while back trouble shooting hardware issues lo never restarted. Networking has been all well and dandy to the net, but postgres actually wanted localhost. So problem solved.

aegagrus:/etc/network# ps ax |grep postgres
8288 pts/0 S 0:00 /usr/lib/postgresql/bin/postmaster
8289 pts/0 S 0:00 postgres: stats buffer process
8292 pts/0 S 0:00 postgres: stats collector process
aegagrus:/etc/network#

Thank you very much for responding to what was a dumb question.

-Derek

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Greg Sikorski 2002-03-31 04:08:07 <= Index.
Previous Message Derek Neighbors 2002-03-30 18:42:24 Re: Troubles Starting Postgres