Bug#307888: postgresql: upgrade to 7.4.7-6 does not succeed

2005-05-06 Thread Didrik Pinte
Package: postgresql
Version: 7.4.7-6
Severity: important


Hi,

I tried to dist-upgrade my sid yesterday and the upgrade of postgresql
did not work. There is an error during the configuration. Here is the
visible output :

geru-itea:/home/did# dpkg --debug=2 --configure postgresql
Paramétrage de postgresql (7.4.7-6) ...
D02: fork/exec /var/lib/dpkg/info/postgresql.postinst ( )
Applying security update in database aardewerk...
Applying security update in database dcl...
Applying security update in database dolibarr...
Applying security update in database mapgic...
Applying security update in database mapgicbv...
Applying security update in database moodle...
Applying security update in database template1...
Applying security update in database template_gis...
dpkg : erreur de traitement de postgresql (--configure) :
 le sous-processus post-installation script a retourné une erreur de
 sortie d'état 2
 Des erreurs ont été rencontrées pendant l'exécution :
  postgresql


I tried to find the problem in /var/lib/dpkg/info/postgresql.postinst
but i'm not enough familiar with the file to identify the problem.

I hope this will help to debug the problem.

Didrik


-- System Information:
Debian Release: 3.1
  APT prefers unstable
  APT policy: (990, 'unstable'), (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.10-1-686
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)

Versions of packages postgresql depends on:
ii  adduser  3.63Add and remove users and groups
ii  debconf [debconf 1.4.49  Debian configuration management sy
ii  debianutils  2.13.2  Miscellaneous utilities specific t
ii  dpkg 1.10.27 Package maintenance system for Deb
ii  libc62.3.2.ds1-21GNU C Library: Shared libraries an
ii  libcomerr2   1.37-2  common error description library
ii  libkrb53 1.3.6-3 MIT Kerberos runtime libraries
ii  libpam0g 0.76-22 Pluggable Authentication Modules l
ii  libperl5.8   5.8.4-8 Shared Perl library
ii  libpq3   7.4.7-6 PostgreSQL C client library
ii  libreadline4 4.3-15  GNU readline and history libraries
ii  libssl0.9.7  0.9.7e-3SSL shared libraries
ii  mailx1:8.1.2-0.20040524cvs-4 A simple mail user agent
ii  postgresql-clien 7.4.7-6 front-end programs for PostgreSQL
ii  procps   1:3.2.5-1   /proc file system utilities
ii  python2.32.3.5-3 An interactive high-level object-o
ii  ucf  1.18Update Configuration File: preserv
ii  zlib1g   1:1.2.2-4   compression library - runtime

-- debconf information:
* postgresql/upgrade/preserve_location: /var/lib/postgres/preserve
* postgresql/settings/day_month_order: European
  postgresql/convert-postmaster.init: true
* postgresql/upgrade/policy: true
  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/initdb/location: /var/lib/postgres/data
* postgresql/settings/locale: C
  postgresql/peer-to-ident: true
  postgresql/missing_conf: true
* postgresql/purge_data_too: false
* postgresql/settings/encoding: LATIN1
* postgresql/settings/date_style: ISO



Bug#307888: postgresql: upgrade to 7.4.7-6 does not succeed

2005-05-06 Thread Ingo Klinkmann
The postinstall script will return with errors and the upgrade will fail 
 if a database is not accessible.
Some possible reasons are:
- datallowconn=false
- data directory not available

Quick-Fix: make the database accessible before upgrade to 7.4.7-6
eg: psql -c update pg_database SET datallowconn=true WHERE 
datname='databasename' template1

Greetings
Ingo Klinkmann
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]


Bug#307888: postgresql: upgrade to 7.4.7-6 does not succeed

2005-05-06 Thread Martin Pitt
Hi!

Didrik Pinte [2005-05-06  8:51 +0200]:
 Applying security update in database template_gis...
 dpkg : erreur de traitement de postgresql (--configure) :
  le sous-processus post-installation script a retourné une erreur de
  sortie d'état 2

Can you manually connect to this database?

Martin

-- 
Martin Pitt   http://www.piware.de
Ubuntu Developerhttp://www.ubuntulinux.org
Debian Developer http://www.debian.org


signature.asc
Description: Digital signature


Bug#307888: postgresql: upgrade to 7.4.7-6 does not succeed

2005-05-06 Thread Didrik Pinte
Le vendredi 06 mai 2005 à 10:10 +0200, Martin Pitt a écrit :
 Hi!
 
 Didrik Pinte [2005-05-06  8:51 +0200]:
  Applying security update in database template_gis...
  dpkg : erreur de traitement de postgresql (--configure) :
   le sous-processus post-installation script a retourné une erreur de
   sortie d'état 2
 
 Can you manually connect to this database?
 
 Martin

Yes I can :

[EMAIL PROTECTED]:/home/did$ psql -d dolibarr
Bienvenue dans psql 7.4.7, l'interface interactive de PostgreSQL.

Tapez:  \copyright pour les termes de distribution
\h pour l'aide-mémoire sur les commandes SQL
\? pour l'aide-mémoire sur les commandes internes
\g ou terminez avec un point-virgule pour exécuter une requête
\q pour quitter

dolibarr=# \q


Didrik