Your message dated Sun, 11 Dec 2005 16:22:38 +0100
with message-id <[EMAIL PROTECTED]>
and subject line Bug#315052: Lost postgresql.conf on upgrade to 7.5
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)
--------------------------------------
Received: (at submit) by bugs.debian.org; 20 Jun 2005 10:05:24 +0000
>From [EMAIL PROTECTED] Mon Jun 20 03:05:24 2005
Return-path: <[EMAIL PROTECTED]>
Received: from smtp.tele2bedrift.no [193.216.69.194]
by spohr.debian.org with smtp (Exim 3.35 1 (Debian))
id 1DkJ9I-0005G9-00; Mon, 20 Jun 2005 03:05:00 -0700
Received: (qmail 20300 invoked from network); 20 Jun 2005 10:03:39 -0000
Received: from unknown (HELO ?127.0.0.1?) (193.216.25.68)
by smtp.tele2bedrift.no with SMTP; 20 Jun 2005 10:03:39 -0000
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Jeff Williams <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: Lost postgresql.conf on upgrade to 7.5
X-Mailer: reportbug 3.14
Date: Mon, 20 Jun 2005 12:03:36 +0200
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-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
Package: postgresql
Version: 7.5.6
Severity: normal
My postgresql.conf seems to have been lost on the transition to 7.5. I'm
pretty sure I had the default postgresql.conf in /etc/postgresql/ but
after the transition the file /etc/postgresql/7.4/main/postgresql.conf
(which I assume should be the same file) was empty. As a result the
server stopped listening for tcp/ip connections.
The only cause I can think of is that my disk usage has been pushing the
100% mark and maybe it filled up?
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: powerpc (ppc)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.11.7
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Versions of packages postgresql depends on:
ii postgresql-7.4 1:7.4.8-9 object-relational SQL database, ve
ii postgresql-client 7.5.6 front-end programs for PostgreSQL
postgresql recommends no packages.
-- debconf information:
postgresql/upgrade/preserve_location: /var/lib/postgres/preserve
* postgresql/settings/day_month_order: European
postgresql/convert-postmaster.init: true
* postgresql/upgrade/policy: false
postgresql/enable_lang: true
postgresql/contains_POSTGRESHOME: true
postgresql/very_old_version_warning: true
postgresql/upgrade/dump_location: /var/lib/postgres
postgresql/convert-pg_hba.conf: true
* postgresql/settings/vacuum_full:
* postgresql/initdb/location: /var/lib/postgres/data
shared/postgresql/upgrade74: false
* postgresql/settings/locale: C
postgresql/peer-to-ident: true
postgresql/missing_conf: true
* postgresql/purge_data_too: false
* postgresql/settings/encoding: per_locale
* postgresql/settings/date_style: ISO
---------------------------------------
Received: (at 315052-done) by bugs.debian.org; 11 Dec 2005 15:23:10 +0000
>From [EMAIL PROTECTED] Sun Dec 11 07:23:09 2005
Return-path: <[EMAIL PROTECTED]>
Received: from box79162.elkhouse.de ([213.9.79.162])
by spohr.debian.org with esmtp (Exim 4.50)
id 1ElT2b-00061S-CS
for [EMAIL PROTECTED]; Sun, 11 Dec 2005 07:23:09 -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 B53F685
for <[EMAIL PROTECTED]>; Sun, 11 Dec 2005 16:22:34 +0100 (CET)
Received: by localhost.localdomain (Postfix, from userid 1000)
id 50D492ED3; Sun, 11 Dec 2005 16:22:38 +0100 (CET)
Date: Sun, 11 Dec 2005 16:22:38 +0100
From: Martin Pitt <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Bug#315052: Lost postgresql.conf on upgrade to 7.5
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL
PROTECTED]> <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="Cgrdyab2wu3Akvjd"
Content-Disposition: inline
In-Reply-To: <[EMAIL PROTECTED]>
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=-2.4 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER,
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
--Cgrdyab2wu3Akvjd
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Hi!
Martin Pitt [2005-09-22 0:25 +0200]:
> Martin Pitt [2005-06-29 0:20 +0200]:
> > Jeff Williams [2005-06-20 15:00 +0200]:
> > > I can't still see the output as I did the upgrade on Saturday after
> > > being away for two weeks. But thinking back, I remember that the upgr=
ade
> > > of postgresql failed. But I'm pretty sure it gave the message:
> > >=20
> > > "Not migrating invalid PostgreSQL data directory /usr/lib/postgres/da=
ta
> > > (no PG_VERSION)."
> >=20
> > That's understandable, I assume that your data directory is actually
> > /var/lib/postgres/data. Did you manually change this at some time?
>=20
> Do you remember whether you changed that path in any configuration
> file?
>=20
> > Do you still happen to have the original
> > /etc/postgresql/postmaster.conf file? (maybe with a .dpkg-old suffix)?
> > Does it configure /usr/lib/postgres/data as data directory?
>=20
> Still of interest to me.
>=20
> > Are you really sure that it works? I. e. did the upgrade eventually
> > migrate your cluster in /var/lib/postgres/data? Can you please check
> > with pg_lsclusters and psql -l and confirm to me?
>=20
> ?
>=20
> I still need some information about this bug, otherwise I cannot do
> anything about it and will just close it.
I did not get any answer for almost two months now, I close this bug
for now. I will reopen it if I get more information.
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?
--Cgrdyab2wu3Akvjd
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)
iD8DBQFDnEQ+DecnbV4Fd/IRAgVfAKC6k2a3rJ61KglWJXixevWkP7hefwCgz1zA
/LABQn9l4idtJberF8S/DHM=
=8OnI
-----END PGP SIGNATURE-----
--Cgrdyab2wu3Akvjd--
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
