Package: postgresql-8.3 Version: 8.3.5-1 Severity: important
Why is postgresql-8.3 not resolving localhost when it starts despite localhost being resolvable by everything else on my system as far as I can see? This transcript demonstrates the problem: lenin:~# cat /etc/hosts 127.0.0.1 localhost.localdomain localhost # The following lines are desirable for IPv6 capable hosts # (added automatically by netbase upgrade) ::1 ip6-localhost ip6-loopback fe00::0 ip6-localnet ff00::0 ip6-mcastprefix ff02::1 ip6-allnodes ff02::2 ip6-allrouters ff02::3 ip6-allhosts lenin:~# hostname --fqdn localhost.localdomain lenin:~# ping -c 1 localhost PING localhost.localdomain (127.0.0.1) 56(84) bytes of data. 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=1 ttl=64 time=0.047 ms --- localhost.localdomain ping statistics --- 1 packets transmitted, 1 received, 0% packet loss, time 0ms rtt min/avg/max/mdev = 0.047/0.047/0.047/0.000 ms lenin:~# /etc/init.d/postgresql-8.3 start # listen_addresses = 'localhost' Starting PostgreSQL 8.3 database server: mainThe PostgreSQL server failed to start. Please check the log output: 2009-01-25 20:39:15 EST LOG: could not load root certificate file "root.crt": no SSL error reported 2009-01-25 20:39:15 EST DETAIL: Will not verify client certificates. 2009-01-25 20:39:16 EST LOG: could not translate host name "localhost", service "5432" to address: Name or service not known 2009-01-25 20:39:16 EST WARNING: could not create listen socket for "localhost" 2009-01-25 20:39:16 EST FATAL: could not create any TCP/IP sockets failed! failed! lenin:~# /etc/init.d/postgresql-8.3 start # listen_addresses = '127.0.0.1' Starting PostgreSQL 8.3 database server: main. lenin:~# Unless 'listen_addresses' in /etc/postgresql/8.3/main/postgresql.conf is assigned 127.0.0.1 (instead of the default 'localhost'), the server fails to start as the transcript above demonstrates with the log error: LOG: could not translate host name "localhost", service "5432" to address: Name or service not known As far as I can tell there is nothing outside of the postgresql-8.3 package which is incorrectly configured on this system.; nothin else complains of being unable to resolve localhost. Some clues; this (lenny) system has been upgraded from etch. It is not a fresh install. Where should I be looking to work out what's wrong here? Does postgresql-8.3 use the usual gethostbyname() ? -- System Information: Debian Release: 5.0 APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.26-1-686 (SMP w/2 CPU cores) Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Shell: /bin/sh linked to /bin/bash Versions of packages postgresql-8.3 depends on: ii libc6 2.7-16 GNU C Library: Shared libraries ii libcomerr2 1.41.3-1 common error description library ii libkrb53 1.6.dfsg.4~beta1-4 MIT Kerberos runtime libraries ii libldap-2.4-2 2.4.11-1 OpenLDAP libraries ii libpam0g 1.0.1-4 Pluggable Authentication Modules l ii libpq5 8.3.5-1 PostgreSQL C client library ii libssl0.9.8 0.9.8g-14 SSL shared libraries ii libxml2 2.6.32.dfsg-5 GNOME XML library ii locales 2.7-16 GNU C Library: National Language ( ii postgresql-client-8.3 8.3.5-1 front-end programs for PostgreSQL ii postgresql-common 94 PostgreSQL database-cluster manage ii ssl-cert 1.0.23 simple debconf wrapper for OpenSSL ii tzdata 2008h-2 time zone and daylight-saving time postgresql-8.3 recommends no packages. Versions of packages postgresql-8.3 suggests: pn oidentd | ident-server <none> (no description available) -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
