postgresql: syntax error in postgresql-startup

Automatically imported from Debian bug report #282940 http://bugs.debian.org/282940

Message-ID: <email address hidden>
Date: Thu, 25 Nov 2004 11:25:46 -0300
From: John Lenton <email address hidden>
To: <email address hidden>
Subject: postgresql: syntax error in postgresql-startup

------=_Part_24_17448375.1101392746885
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Package: postgresql
Version: 7.4.6-4
Severity: grave
Justification: renders package unusable

*** Please type your report below this line ***

There's a very silly syntax error in postgresql-startup that makes
postgresql not start. Attached is a patch to fix it (although it's
so simple you might rather do it by hand!)

-- System Information:
Debian Release: 3.1
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.7++
Locale: LANG=en_US, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)

Versions of packages postgresql depends on:
ii adduser 3.59 Add and remove users and groups
ii debconf [debconf 1.4.40 Debian configuration management sy
ii debianutils 2.10.3 Miscellaneous utilities specific t
ii libc6 2.3.2.ds1-18 GNU C Library: Shared libraries an
ii libcomerr2 1.35-8 The Common Error Description libra
ii libkrb53 1.3.4-4 MIT Kerberos runtime libraries
ii libpam0g 0.76-22 Pluggable Authentication Modules l
ii libperl5.8 5.8.4-4 Shared Perl library
ii libpq3 7.4.6-4 PostgreSQL C client library
ii libreadline4 4.3-15 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.6-4 front-end programs for PostgreSQL
ii procps 1:3.2.4-1 The /proc file system utilities
ii python2.3 2.3.4-16 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: UNICODE
  postgresql/convert-pg_hba.conf: true

------=_Part_24_17448375.1101392746885
Content-Type: text/x-patch; name="simple.patch"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="simple.patch"

--- /usr/lib/postgresql/bin/postgresql-startup.~1~=092004-11-25 11:18:21.00=
0000000 -0300
+++ /usr/lib/postgresql/bin/postgresql-startup=092004-11-25 11:18:43.000000=
000 -0300
@@ -143,7 +143,7 @@
     # cleaned up automatically in Debian at startup, we need to see
     # if there is a stale pid file lef...

Message-ID: <email address hidden>
Date: Thu, 25 Nov 2004 15:57:27 +0100
From: Martin Pitt <email address hidden>
To: John Lenton <email address hidden>, <email address hidden>
Cc: <email address hidden>
Subject: Re: Bug#282940: postgresql: syntax error in postgresql-startup

--61jdw2sOBCFtR2d/
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

severity 282940 important
thanks

Hi John!

John Lenton [2004-11-25 11:25 -0300]:
> There's a very silly syntax error in postgresql-startup that makes
> postgresql not start. Attached is a patch to fix it (although it's
> so simple you might rather do it by hand!)

Darn, thanks for pointing me at it. I will fix it in the next release.
However, I downgraded it to important because it only affects a
corner case (improper shutdown of the server) and, more importantly,
the error is already in Sarge. Since 7.4.6-4 fixes some severe bugs, I
would like to have this version migrate to testing before I upload
another one.

Thanks,

Martin

--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntulinux.org
Debian GNU/Linux Developer http://www.debian.org

--61jdw2sOBCFtR2d/
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBpfLXDecnbV4Fd/IRApqUAKDEvx4d9bCn0jTwWO/WIBiLsOVbjACfeV3L
/vvrYDQkuStBbv1exDpKp0k=
=w1UH
-----END PGP SIGNATURE-----

--61jdw2sOBCFtR2d/--

Message-Id: <email address hidden>
Date: Thu, 25 Nov 2004 16:00:01 +0100
From: Martin Pitt <email address hidden>
To: <email address hidden>
Subject: tagging 282940

# Automatically generated email from bts, devscripts version 2.8.5
tags 282940 pending

Already fixed in arch head, will be fixed by next Debian upload.

Message-Id: <email address hidden>
Date: Wed, 01 Dec 2004 04:47:13 -0500
From: Martin Pitt <email address hidden>
To: <email address hidden>
Subject: Bug#282940: fixed in postgresql 7.4.6-5

Source: postgresql
Source-Version: 7.4.6-5

We believe that the bug you reported is fixed in the latest version of
postgresql, which is due to be installed in the Debian FTP archive:

libecpg-dev_7.4.6-5_i386.deb
  to pool/main/p/postgresql/libecpg-dev_7.4.6-5_i386.deb
libecpg4_7.4.6-5_i386.deb
  to pool/main/p/postgresql/libecpg4_7.4.6-5_i386.deb
libpgtcl-dev_7.4.6-5_i386.deb
  to pool/main/p/postgresql/libpgtcl-dev_7.4.6-5_i386.deb
libpgtcl_7.4.6-5_i386.deb
  to pool/main/p/postgresql/libpgtcl_7.4.6-5_i386.deb
libpq3_7.4.6-5_i386.deb
  to pool/main/p/postgresql/libpq3_7.4.6-5_i386.deb
postgresql-client_7.4.6-5_i386.deb
  to pool/main/p/postgresql/postgresql-client_7.4.6-5_i386.deb
postgresql-contrib_7.4.6-5_i386.deb
  to pool/main/p/postgresql/postgresql-contrib_7.4.6-5_i386.deb
postgresql-dev_7.4.6-5_i386.deb
  to pool/main/p/postgresql/postgresql-dev_7.4.6-5_i386.deb
postgresql-doc_7.4.6-5_all.deb
  to pool/main/p/postgresql/postgresql-doc_7.4.6-5_all.deb
postgresql_7.4.6-5.diff.gz
  to pool/main/p/postgresql/postgresql_7.4.6-5.diff.gz
postgresql_7.4.6-5.dsc
  to pool/main/p/postgresql/postgresql_7.4.6-5.dsc
postgresql_7.4.6-5_i386.deb
  to pool/main/p/postgresql/postgresql_7.4.6-5_i386.deb

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to <email address hidden>,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Martin Pitt <email address hidden> (supplier of updated postgresql package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing <email address hidden>)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Mon, 29 Nov 2004 18:49:09 +0100
Source: postgresql
Binary: postgresql-client libecpg4 libpgtcl-dev libpq3 postgresql-doc libecpg-dev postgresql-dev postgresql libpgtcl postgresql-contrib
Architecture: source i386 all
Version: 7.4.6-5
Distribution: unstable
Urgency: low
Maintainer: Oliver Elphick <email address hidden>
Changed-By: Martin Pitt <email address hidden>
Description:
 libecpg-dev - development files for ECPG (Embedded PostgreSQL for C)
 libecpg4 - run-time library for ECPG programs
 libpgtcl - Tcl procedural language, library and front-end for PostgreSQL
 libpgtcl-dev - Tcl library for PostgreSQL - development files
 libpq3 - PostgreSQL C client library
 postgresql - object-relational SQL database management system
 postgresql-client - front-end programs for PostgreSQL
 postgresql-contrib - additional facilities for PostgreSQL
 postgresql-dev - development files for libpq (PostgreSQL library)
 postgresql-doc - documentation for the PostgreSQL database management system
Closes: 282940 282973 282977 282984 283079 283458
Changes:
 postgresql (7.4.6-5) unstable; urgency=low
 .
   * Fixed silly...

7.4.6-5 is in Hoary now, closing.