postgresql: postinst assumes /var/lib/postgres exists

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

Message-Id: <20041030164459.622BE875D0@two>
Date: Sat, 30 Oct 2004 12:44:59 -0400
From: Brian DeRocher <email address hidden>
To: Debian Bug Tracking System <email address hidden>
Subject: postgresql: postinst assumes /var/lib/postgres exists

Package: postgresql
Version: 7.2.1-2woody6
Severity: grave
Tags: patch patch
Justification: renders package unusable

Upon upgrading PostgreSQL wouldn't start. The postinst was failing.
I install PostgreSQL to a location other than /var/lib/. I just
removed /var/lib/postgres as a parameter to chmod, since it already
included $PGHOME on line 439.

439c439
< chown -R postgres.postgres ${PGDATA} ${PGHOME} /var/lib/postgres /var/run/postgresql
---
> chown -R postgres.postgres ${PGDATA} ${PGHOME} /var/run/postgresql

-- System Information
Debian Release: 3.0
Architecture: i386
Kernel: Linux two 2.4.18-k6 #1 Sun Apr 14 12:43:22 EST 2002 i586
Locale: LANG=C, LC_CTYPE=C

Versions of packages postgresql depends on:
ii adduser 3.47 Add and remove users and groups
ii debianutils 1.16.2woody1 Miscellaneous utilities specific t
ii libc6 2.2.5-11.5 GNU C Library: Shared libraries an
ii libpam0g 0.72-35 Pluggable Authentication Modules l
ii libpgsql2 7.2.1-2woody6 Shared library libpq.so.2 for Post
ii libreadline4 4.2a-5 GNU readline and history libraries
ii libssl0.9.6 0.9.6c-2.woody.6 SSL shared libraries
ii postgresql-client 7.2.1-2woody6 Front-end programs for PostgreSQL
ii procps 1:2.0.7-8.woody1 The /proc file system utilities.
ii python2.1 2.1.3-3.2 An interactive object-oriented scr
ii zlib1g 1:1.1.4-1.0woody0 compression library - runtime

Message-Id: <email address hidden>
Date: Sun, 31 Oct 2004 10:13:57 +0100
From: Martin Pitt <email address hidden>
To: <email address hidden>
Subject: severity of 278952 is important

# Automatically generated email from bts, devscripts version 2.8.5
severity 278952 important

Message-Id: <email address hidden>
Date: Sun, 31 Oct 2004 10:17:10 +0100
From: Martin Pitt <email address hidden>
To: <email address hidden>
Subject: tagging 278952

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

This is not really a major bug (already downgraded in Debian).

Fixed in arch head, to be uploaded soon.

Message-Id: <email address hidden>
Date: Wed, 10 Nov 2004 07:02:10 -0500
From: Martin Pitt <email address hidden>
To: <email address hidden>
Subject: Bug#278952: fixed in postgresql 7.4.6-3

Source: postgresql
Source-Version: 7.4.6-3

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-3_i386.deb
  to pool/main/p/postgresql/libecpg-dev_7.4.6-3_i386.deb
libecpg4_7.4.6-3_i386.deb
  to pool/main/p/postgresql/libecpg4_7.4.6-3_i386.deb
libpgtcl-dev_7.4.6-3_i386.deb
  to pool/main/p/postgresql/libpgtcl-dev_7.4.6-3_i386.deb
libpgtcl_7.4.6-3_i386.deb
  to pool/main/p/postgresql/libpgtcl_7.4.6-3_i386.deb
libpq3_7.4.6-3_i386.deb
  to pool/main/p/postgresql/libpq3_7.4.6-3_i386.deb
postgresql-client_7.4.6-3_i386.deb
  to pool/main/p/postgresql/postgresql-client_7.4.6-3_i386.deb
postgresql-contrib_7.4.6-3_i386.deb
  to pool/main/p/postgresql/postgresql-contrib_7.4.6-3_i386.deb
postgresql-dev_7.4.6-3_i386.deb
  to pool/main/p/postgresql/postgresql-dev_7.4.6-3_i386.deb
postgresql-doc_7.4.6-3_all.deb
  to pool/main/p/postgresql/postgresql-doc_7.4.6-3_all.deb
postgresql_7.4.6-3.diff.gz
  to pool/main/p/postgresql/postgresql_7.4.6-3.diff.gz
postgresql_7.4.6-3.dsc
  to pool/main/p/postgresql/postgresql_7.4.6-3.dsc
postgresql_7.4.6-3_i386.deb
  to pool/main/p/postgresql/postgresql_7.4.6-3_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: Wed, 10 Nov 2004 12:38:59 +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-3
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: 147823 149057 149789 254058 257117 263503 265307 271277 273891 277725 278952 280423
Changes:
 postgresql (7.4.6-3)...

postgresql 7.4.6-3 is in Hoary now, so this bug can be closed.