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!)
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
--- /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 left when the system crashed:
if [ -f "$PGDATA/postmaster.pid" ]; then
-=09pid=3D"`cat $PGDATA/postmaster.pid | head -1)`"
+=09pid=3D"`cat $PGDATA/postmaster.pid | head -1`"
=09if [ "`ps -o comm h p $pid`" =3D postmaster ]; then
=09 echo The postmaster is already running
=09 exit 1
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 Transfer- Encoding: 7bit Disposition: inline
Content-Type: text/plain; charset=US-ASCII
Content-
Content-
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: en_US.UTF- 8 (charmap=UTF-8)
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=
Versions of packages postgresql depends on: 0.20040524cvs- 3 A simple mail user agent
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-
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: initdb/ location: /var/lib/ postgres/ data upgrade/ preserve_ location: $PGDATA/.. settings/ day_month_ order: European upgrade/ policy: true settings/ locale: C enable_ lang: true purge_data_ too: true very_old_ version_ warning: true upgrade/ dump_location: $PGDATA/.. settings/ encoding: UNICODE convert- pg_hba. conf: true
* postgresql/
postgresql/
* postgresql/
postgresql/
* postgresql/
postgresql/
* postgresql/
postgresql/
postgresql/
* postgresql/
postgresql/
------= _Part_24_ 17448375. 1101392746885 Transfer- Encoding: quoted-printable Disposition: attachment; filename= "simple. patch"
Content-Type: text/x-patch; name="simple.patch"
Content-
Content-
--- /usr/lib/ postgresql/ bin/postgresql- startup. ~1~=092004- 11-25 11:18:21.00= postgresql/ bin/postgresql- startup= 092004- 11-25 11:18:43.000000= postmaster. pid" ]; then postmaster. pid | head -1)`" postmaster. pid | head -1`"
0000000 -0300
+++ /usr/lib/
000 -0300
@@ -143,7 +143,7 @@
# cleaned up automatically in Debian at startup, we need to see
# if there is a stale pid file left when the system crashed:
if [ -f "$PGDATA/
-=09pid=3D"`cat $PGDATA/
+=09pid=3D"`cat $PGDATA/
=09if [ "`ps -o comm h p $pid`" =3D postmaster ]; then
=09 echo The postmaster is already running
=09 exit 1
------= _Part_24_ 17448375. 1101392746885- -