reassign 463100 dbconfig-common thanks Hi Markus and Sean,
I'm looking at this and it appears that the problem is in dbconfig-common. Bacula itself has never made a backup there as far as I know (certainly that code isn't in the current tree). Yet the version of dbconfig-common in sid also doesn't seem to make a backup. So perhaps this bug is already fixed in sid? Or is there something else that we can do to prevent a backup of a potentially huge database? These can run into the millions of records. Thanks, -- John On Tue January 29 2008 8:13:52 am Markus Schulz wrote: > Package: bacula-director-pgsql > Version: 1.38.11-8 > Severity: minor > > It's impossible to use db-config for database upgrades for big-bacula > databases cause it want to consume too much memory. > > ************************** > Richte bacula-director-pgsql ein (1.38.11-8) ... > dbconfig-common: writing config to > /etc/dbconfig-common/bacula-director-pgsql.conf detected upgrade from > previous non-dbconfig version. > creating database backup in > /var/cache/dbconfig-common/backups/bacula-director-pgsql_1.36.2-2sarge1.pg >sql. /usr/share/dbconfig-common/internal/pgsql: xrealloc: > ../bash/subst.c:512: cannot reallocate 682980864 bytes (0 bytes allocated) > dpkg: Fehler beim Bearbeiten von bacula-director-pgsql (--configure): > Unterprozess post-installation script gab den Fehlerwert 2 zurück dpkg: > Abhängigkeitsprobleme verhindern Konfiguration von bacula-server: > bacula-server hängt ab von bacula-director-sqlite3 (= 1.38.11-8) | > bacula-director; aber: Paket bacula-director-sqlite3 ist nicht > installiert. > Paket bacula-director ist nicht installiert. > Paket bacula-director-pgsql, das bacula-director bereitstellt, ist noch > nicht konfiguriert. dpkg: Fehler beim Bearbeiten von bacula-server > (--configure): > Abhängigkeitsprobleme - lasse es unkonfiguriert > Fehler traten auf beim Bearbeiten von: > bacula-director-pgsql > bacula-server > E: Sub-process /usr/bin/dpkg returned an error code (1) > ************************** > > a compressed pg_dump for this database done by myself: > # pg_dump -Fc -f bacula-dump.sql bacula > will produce a file with: > -rw-r--r-- 1 postgres postgres 190196567 2008-01-29 15:03 bacula-dump.sql > > Perhaps the db-config script can be done in a lower memory consuming > variant. A manually upgrade with the script > /usr/share/bacula-director/update_postgresql_tables works flawless. > > -- System Information: > Debian Release: 4.0 > APT prefers stable > APT policy: (500, 'stable') > Architecture: i386 (i686) > Shell: /bin/sh linked to /bin/bash > Kernel: Linux 2.6.18-5-xen-686 > Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15) > > Versions of packages bacula-director-pgsql depends on: > ii bacula-director-common 1.38.11-8 Network backup, recovery and > verif ii dbconfig-common 1.8.29+etch1 common framework for > packaging dat ii debconf [debconf-2.0] 1.5.11etch1 Debian > configuration management sy ii libc6 2.3.6.ds1-13etch4 > GNU C Library: Shared libraries ii libgcc1 1:4.1.1-21 > GCC support library > ii libpq4 8.1.11-0etch1 PostgreSQL C client library > ii libssl0.9.8 0.9.8c-4etch1 SSL shared libraries > ii libstdc++6 4.1.1-21 The GNU Standard C++ Library > v3 ii libwrap0 7.6.dbs-13 Wietse Venema's TCP > wrappers libra ii postgresql-client 7.5.22 front-end > programs for PostgreSQL ii postgresql-client-8.1 8.1.11-0etch1 > front-end programs for PostgreSQL ii python2.4 2.4.4-3 > An interactive high-level object-o ii sqlite3 > 3.3.8-1.1 A command line interface for SQLit > > Versions of packages bacula-director-pgsql recommends: > ii postgresql 7.5.22 object-relational SQL > database man ii postgresql-8.1 8.1.11-0etch1 > object-relational SQL database, ve > > -- debconf information: > bacula-director-pgsql/pgsql/authmethod-admin: ident > bacula-director-pgsql/pgsql/no-empty-passwords: > bacula-director-pgsql/upgrade-backup: true > bacula-director-pgsql/install-error: abort > * bacula-director-pgsql/create_tables: false > bacula-director-pgsql/purge: false > * bacula-director-pgsql/pgsql_root_username: postgres > bacula-director-pgsql/pgsql/method: unix socket > bacula-director-pgsql/db/app-user: bacula > bacula-director-pgsql/dbconfig-reinstall: false > bacula-director-pgsql/db/dbname: bacula > bacula-director-pgsql/remote/host: > bacula-director-pgsql/pgsql/admin-user: postgres > bacula-director-pgsql/internal/skip-preseed: true > bacula-director-pgsql/database-type: pgsql > bacula-director-pgsql/remote/port: > * bacula-director-pgsql/remove_catalog_on_purge: false > bacula-director-pgsql/drop_db: false > bacula-director-pgsql/remote/newhost: > bacula-director-pgsql/remove-error: abort > bacula-director-pgsql/passwords-do-not-match: > bacula-director-pgsql/internal/reconfiguring: false > * bacula-director-pgsql/pgsql/authmethod-user: ident > * bacula-director-pgsql/db_host: localhost > bacula-director-pgsql/pgsql/manualconf: > bacula-director-pgsql/dbconfig-install: true > * bacula-director-pgsql/dbconfig-upgrade: false > bacula-director-pgsql/db_user: bacula > bacula-director-pgsql/dbconfig-remove: > bacula-director-pgsql/upgrade-error: abort > bacula-director-pgsql/pgsql/changeconf: false
