PRIO: low Hi,
in src/backend/postmaster/pgstat.c there is a hard coded bind to 127.0.0.1 that fails if 127.0.0.1 is not configured on loopback interface (e.g. administrator explicitly removed this IP). This should _not_ be the case in normal setups. --- gmake check --- ... ============== creating temporary installation ============== ============== initializing database system ============== ============== starting postmaster ============== pg_regress: postmaster did not start Examine ./log/postmaster.log for the reason. kill: 97857: No such process rm regress.o gmake[2]: Leaving directory `/u1/local/src/postgresql/postgresql-7.2.1/src/test/regress' gmake[1]: Leaving directory `/u1/local/src/postgresql/postgresql-7.2.1/src/test' % cat src/test/regress/log/postmaster.log PGSTAT: bind(2): Can't assign requested address --- snipp --- With postgresql-7.2.1 (and perhaps also earlier versions ?) this prevents postmaster from starting if one does not configure 'stats_start_collector = false'. This works as a workaround. One may also patch the sources and recompile of course. I have seen that there were changes in CVS already but the 127.0.0.1 is still hard coded in there. I discovered that after playing with some routing daemons on my test machine and therefor had removed 127.0.0.1. OS was FreeBSD 4.5-STABLE but that shouldn't matter. -- Greetings Bjoern A. Zeeb bzeeb at Zabbadoz dot NeT 56 69 73 69 74 http://www.zabbadoz.net/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html