Your message dated Tue, 7 Feb 2006 00:40:05 +0100 with message-id <[EMAIL PROTECTED]> and subject line postgresql: PostgreSQL upgrade doesn't work if its listening on localhost (127.0.0.1) has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database)
--- Begin Message --->From [EMAIL PROTECTED] Thu Jul 21 04:26:01 2005 Received: (at submit) by bugs.debian.org; 21 Jul 2005 11:26:01 +0000 Return-path: <[EMAIL PROTECTED]> Received: from bzq-232-117-212.bezeqint.net (beyonce.beyondsecurity.com) [192.117.232.212] by spohr.debian.org with esmtp (Exim 3.36 1 (Debian)) id 1DvZBh-0001sd-00; Thu, 21 Jul 2005 04:26:01 -0700 Received: from root by beyonce.beyondsecurity.com with local (Exim 4.34) id 1DvZAk-0005oq-Sg for [EMAIL PROTECTED]; Thu, 21 Jul 2005 14:25:02 +0300 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: Noam Rathaus <[EMAIL PROTECTED]> To: Debian Bug Tracking System <[EMAIL PROTECTED]> Subject: postgresql: PostgreSQL upgrade doesn't work if its listening on localhost (127.0.0.1) X-Mailer: reportbug 3.8 Date: Thu, 21 Jul 2005 14:25:02 +0300 Message-Id: <[EMAIL PROTECTED]> Delivered-To: [EMAIL PROTECTED] X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 (1.212-2003-09-23-exp) on spohr.debian.org X-Spam-Level: X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE autolearn=no version=2.60-bugs.debian.org_2005_01_02 Package: postgresql Version: 7.4.7-6sarge1 Severity: grave Justification: renders package unusable Trying to upgrade returns: Setting up postgresql (7.4.7-6sarge1) ... psql: could not connect to server: ÷� Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? Applying security update in database template0... dpkg: error processing postgresql (--configure): subprocess post-installation script returned error exit status 2 Setting up postgresql-doc (7.4.7-6sarge1) ... Errors were encountered while processing: postgresql E: Sub-process /usr/bin/dpkg returned an error code (1) ----------- This is because my PostgreSQL is listeing on localhost, and for some reason the upgrade is unable to upgrade. -- System Information: Debian Release: 3.1 Architecture: i386 (i686) Kernel: Linux 2.6.11.7 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages postgresql depends on: ii adduser 3.59 Add and remove users and groups ii debconf [debconf 1.4.30.11 Debian configuration management sy ii debianutils 2.8.4 Miscellaneous utilities specific t ii dpkg 1.10.25 Package maintenance system for Deb ii libc6 2.3.2.ds1-21 GNU C Library: Shared libraries an ii libcomerr2 1.35-6 The Common Error Description libra ii libkrb53 1.3.5-1 MIT Kerberos runtime libraries ii libpam0g 0.76-22 Pluggable Authentication Modules l ii libperl5.8 5.8.4-3 Shared Perl library ii libpq3 7.4.6-5 PostgreSQL C client library ii libreadline4 4.3-11 GNU readline and history libraries ii libssl0.9.7 0.9.7e-2 SSL shared libraries ii mailx 1:8.1.2-0.20040524cvs-3 A simple mail user agent ii postgresql-clien 7.4.7-6sarge1 front-end programs for PostgreSQL ii procps 1:3.2.1-2 The /proc file system utilities ii python2.3 2.3.4-18 An interactive high-level object-o ii ucf 1.13 Update Configuration File: preserv ii zlib1g 1:1.2.2-3 compression library - runtime -- debconf information: * postgresql/initdb/location: /var/lib/postgres/data postgresql/upgrade/preserve_location: $PGDATA/.. * postgresql/settings/day_month_order: European postgresql/upgrade/policy: true * postgresql/settings/locale: C postgresql/enable_lang: true * postgresql/purge_data_too: true postgresql/very_old_version_warning: true postgresql/upgrade/dump_location: $PGDATA/.. * postgresql/settings/encoding: per_locale postgresql/convert-pg_hba.conf: true
--- End Message ---
--- Begin Message --->From [EMAIL PROTECTED] Mon Feb 06 15:40:29 2006 Received: (at 319338-done) by bugs.debian.org; 6 Feb 2006 23:40:29 +0000 Return-path: <[EMAIL PROTECTED]> Received: from box79162.elkhouse.de ([213.9.79.162]) by spohr.debian.org with esmtp (Exim 4.50) id 1F6Fy9-0000VQ-JR for [EMAIL PROTECTED]; Mon, 06 Feb 2006 15:40:29 -0800 Received: from localhost.localdomain (unknown [195.227.105.180]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Martin Pitt (workstation)", Issuer "piware CA" (verified OK)) by box79162.elkhouse.de (Postfix) with ESMTP id 2DBE3DB07 for <[EMAIL PROTECTED]>; Tue, 7 Feb 2006 00:39:51 +0100 (CET) Received: by localhost.localdomain (Postfix, from userid 1000) id 160C06460; Tue, 7 Feb 2006 00:40:05 +0100 (CET) Date: Tue, 7 Feb 2006 00:40:05 +0100 From: Martin Pitt <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: postgresql: PostgreSQL upgrade doesn't work if its listening on localhost (127.0.0.1) Message-ID: <[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="GOzekVbrLdOLv44p" Content-Disposition: inline User-Agent: Mutt/1.5.11 X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 (1.212-2003-09-23-exp) on spohr.debian.org X-Spam-Level: * X-Spam-Status: No, hits=1.1 required=4.0 tests=BAYES_00, RCVD_IN_BL_SPAMCOP_NET,RCVD_IN_SBLXBL,RCVD_IN_SBLXBL_CBL, RCVD_IN_SORBS,RCVD_IN_SORBS_WEB autolearn=no version=2.60-bugs.debian.org_2005_01_02 --GOzekVbrLdOLv44p Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi Noam! Sun, 11 Dec 2005 15:57:32 +0100: > tag 319338 moreinfo unreproducible > thanks >=20 > Hi Noam! >=20 > Still puzzled about this bug. The log seems to indicate that the > postgres user could connect successfully, but the output says that the > connection could not be made. Is the log and the apt output from the > same run? Is that the complete postgresql.log? >=20 > Can you please send me the complete log and your pg_hba.conf? No answer to these questions for two months now, and I cannot reproduce this bug at all. I'm closing this bug for now until more information arrives. Thanks, Martin --=20 Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org In a world without walls and fences, who needs Windows and Gates? --GOzekVbrLdOLv44p Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQFD595VDecnbV4Fd/IRAr0JAKDfy2SPp1fPyRgUR7bJduTt0w6KyACfY3Nl XaK/+3DEmRCJVe3l+5eJPfw= =iQgB -----END PGP SIGNATURE----- --GOzekVbrLdOLv44p--
--- End Message ---
