Your message dated Thu, 19 May 2011 09:48:20 +0000 with message-id <e1qmzq8-0005s7...@franck.debian.org> and subject line Bug#627227: fixed in postgresql-common 116 has caused the Debian Bug report #627227, regarding postgres-common: pg_upgradecluster fails with ERROR: function replace(... to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact ow...@bugs.debian.org immediately.) -- 627227: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=627227 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
--- Begin Message ---Package: postgresql-common Version: 115 Severity: normal pg_upgradecluster failed with the same error during an attempt to upgrade an 8.4 cluster as well as an 8.3 cluster. The output from running the command is: myhost:~# pg_upgradecluster 8.3 main Stopping old cluster... Disabling connections to the old cluster during upgrade... Restarting old cluster with restricted connections... Creating new cluster (configuration: /etc/postgresql/9.0/main, data: /var/lib/postgresql/9.0/main)... Moving configuration file /var/lib/postgresql/9.0/main/postgresql.conf to /etc/postgresql/9.0/main... Moving configuration file /var/lib/postgresql/9.0/main/pg_hba.conf to /etc/postgresql/9.0/main... Moving configuration file /var/lib/postgresql/9.0/main/pg_ident.conf to /etc/postgresql/9.0/main... Configuring postgresql.conf to use port 5433... Disabling connections to the new cluster during upgrade... Roles, databases, schemas, ACLs... Fixing hardcoded library paths for stored procedures... ERROR: function replace(bytea, unknown, unknown) does not exist LINE 3: replace(probin, '/usr/lib/postgresql/lib', '$libdir'), ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Error: Could not fix library paths Re-enabling connections to the old cluster... Re-enabling connections to the new cluster... Error during cluster dumping, removing new cluster Although postgresql-common does not depend explicitly on perl, pg_upgradecluster is a perl script. Perhap the recent upgrade from 5.10 -> 5.12 of perl may be the cause of the problem. My perl is: ii perl 5.12.3-6 Larry Wall's Practical Extraction and Report Please let me know if I can be assistance in squashing this bug. -- System Information: Debian Release: wheezy/sid APT prefers unstable APT policy: (800, 'unstable'), (300, 'oldstable'), (300, 'experimental') Architecture: i386 (x86_64) Kernel: Linux 2.6.38-2-amd64 (SMP w/2 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages postgresql-common depends on: ii adduser 3.112+nmu2 add and remove users and groups ii debconf [debconf-2.0] 1.5.39 Debian configuration management sy ii lsb-base 3.2-27 Linux Standard Base 3.2 init scrip ii postgresql-client-common 115 manager for multiple PostgreSQL cl ii procps 1:3.2.8-10 /proc file system utilities ii ssl-cert 1.0.28 simple debconf wrapper for OpenSSL postgresql-common recommends no packages. postgresql-common suggests no packages. -- debconf-show failed
--- End Message ---
--- Begin Message ---Source: postgresql-common Source-Version: 116 We believe that the bug you reported is fixed in the latest version of postgresql-common, which is due to be installed in the Debian FTP archive: postgresql-client-common_116_all.deb to main/p/postgresql-common/postgresql-client-common_116_all.deb postgresql-common_116.dsc to main/p/postgresql-common/postgresql-common_116.dsc postgresql-common_116.tar.gz to main/p/postgresql-common/postgresql-common_116.tar.gz postgresql-common_116_all.deb to main/p/postgresql-common/postgresql-common_116_all.deb postgresql-server-dev-all_116_all.deb to main/p/postgresql-common/postgresql-server-dev-all_116_all.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 627...@bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Martin Pitt <mp...@debian.org> (supplier of updated postgresql-common 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 ftpmas...@debian.org) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Format: 1.8 Date: Thu, 19 May 2011 11:30:16 +0200 Source: postgresql-common Binary: postgresql-common postgresql-client-common postgresql-server-dev-all Architecture: source all Version: 116 Distribution: unstable Urgency: low Maintainer: Martin Pitt <mp...@debian.org> Changed-By: Martin Pitt <mp...@debian.org> Description: postgresql-client-common - manager for multiple PostgreSQL client versions postgresql-common - PostgreSQL database-cluster manager postgresql-server-dev-all - extension build tool for multiple PostgreSQL versions Closes: 617493 627227 Changes: postgresql-common (116) unstable; urgency=low . * debian/supported-versions: Move Debian testing/unstable and Ubuntu 11.10 to 9.0. * pg_upgradecluster: Revert to the previous encode()/decode() wrapping in the "probin" fixup for cluster upgrades from versions < 9.0. Earlier versions' replace() function indeed does work on bytea types, not strings, so this broke upgrades to 8.4. (Closes: #627227) * pg_upgradecluster: Drop all unversioned configuration option transitions, which were still from the 7.4 → 8.0 days. These are obsolete, and versions >= 96 only support clusters >= 8.1 anyway. In some cases they actively break stuff, like inadvertently setting log_statement=all. (Closes: #617493) * t/060_obsolete_confparams.t: Fix remaining "{,log_}timezone=unknown" example configuration files, to also fix upgrade tests for 8.4 → 9.1. Checksums-Sha1: 093d2decb5f1289bc218147e36108f161b67a4cd 1579 postgresql-common_116.dsc 7a498853c025542d807e4b977ee2fecec9a889ae 129038 postgresql-common_116.tar.gz f8f341b879cf86846ee94036a86c9a2040b0e622 127228 postgresql-common_116_all.deb 96f5df5021b1d7b484445c0019aa7092becd5034 56190 postgresql-client-common_116_all.deb ff47918a1a8b6740088abfc2620b78f14b118dd6 41372 postgresql-server-dev-all_116_all.deb Checksums-Sha256: 2094243f256d3463a9699110456a52209e457334fcc405510d83f2692437bfee 1579 postgresql-common_116.dsc dd4e3ea3d780dffbf38ec9a98346fb581f78fae843af684e8f8b154ef2f48e72 129038 postgresql-common_116.tar.gz 6f833f8849965bc37e00052c8d20c80753a5b30f6bb14a5757b3a37127933c14 127228 postgresql-common_116_all.deb c97ea1fd57460dc64149a07e724d7808987be875ec18b7b7fe500e8c2a5aaa92 56190 postgresql-client-common_116_all.deb 519ef3c1f5717a10d29ea4e14b4a0c19b2404630c3e984682f3752f0063120f8 41372 postgresql-server-dev-all_116_all.deb Files: 6dc73718799ffbc2d6c98f96bbd018e0 1579 database optional postgresql-common_116.dsc 97893d48d094a724467af3c49bf9d186 129038 database optional postgresql-common_116.tar.gz f8a1c56a759e085bc92395299bb50c66 127228 database optional postgresql-common_116_all.deb 254a8ee67d520402a06290ed3b402063 56190 database optional postgresql-client-common_116_all.deb 8e6388fdff0829fe3ef4a106ff809d09 41372 database optional postgresql-server-dev-all_116_all.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iQIcBAEBCAAGBQJN1ONWAAoJEPmIJawmtHufBJYP/igxl+WWSMIFD9H4XuPL7EPi bDV3RUVo5rVO6W2o0x397J8iib6Sb19JkFF2sBXb2r6TQOmzdEA/JmnxP5K+ANX2 /Oo+i8DfnOjHYtLxWS4FKn3hbDquxVKOLw67xn5xji7MPxryTr0S8KCwG0DtBzjM 4aLW4YVOUFyrE7bbZHIDS7FjSjANmef31s87U8Xaeh9D6L8Ly3aS4wYY/hbvpnFJ a5nFEaufTKhXQ98++94g5h6J0qTkFGJXHm1BmG6oW7siGHLMT/cPFY7SEbKPQagG x1/tRUONqW5ZpSFa7B65qC3f5xJkoMSB1454+mPCLPilTJqRwA1tnC7pyLcGWVoQ ++iwEfs5y+f2l4mJRZ4gGFNPQ6YZSscEY1TkQVyaUUv0smTGoPhUJnbpcycHeBOe rb5sbY+haRLmY4IEBTDcV7x8Lg8Uiqt79HxBzvClJvY0sod6NGSjxRaGDELZ/rmM Qj7P4h6JUZzY5FphHzdLxbBEEL3+qNcZPgjAJLUxS7gZz2rcTWOXwcgbaJpjnHcs Xymd9s42B3wpLHZKcZzv5TkfLBYQOBeRV8MapdHz3thC5RCadeSbjhmswNfE3J22 Dce7QfjIPpFtlvz3v/j1Aqd8u0E//hNCkJooooq9poZM1xVEXLYxVhFJ9713CLQu 6xzQiSMotbKd9jh8pfl2 =nfs5 -----END PGP SIGNATURE-----
--- End Message ---
