Your message dated Sat, 01 Jun 2013 04:48:16 +0000
with message-id <[email protected]>
and subject line Bug#688960: fixed in postgresql-common 144
has caused the Debian Bug report #688960,
regarding postgresql-common - pg_upgradecluster fails with "OLD used in query
that is not in a rule"
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 [email protected]
immediately.)
--
688960: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=688960
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-common
Version: 134
Severity: grave
pg_upgradecluster from 8.4 to 9.1 fails:
| # pg_upgradecluster 8.4 main /srv/postgresql/9.1/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.1/main, data:
/srv/postgresql/9.1/main)...
| Moving configuration file /srv/postgresql/9.1/main/postgresql.conf to
/etc/postgresql/9.1/main...
| Moving configuration file /srv/postgresql/9.1/main/pg_hba.conf to
/etc/postgresql/9.1/main...
| Moving configuration file /srv/postgresql/9.1/main/pg_ident.conf to
/etc/postgresql/9.1/main...
| Configuring postgresql.conf to use port 5433...
| Disabling connections to the new cluster during upgrade...
| Roles, databases, schemas, ACLs...
| pg_dump: SQL command failed
| pg_dump: Error message from server: ERROR: OLD used in query that is not in
a rule
| LINE 1: LOCK TABLE old.eintraege IN ACCESS SHARE MODE
| ^
| pg_dump: The command was: LOCK TABLE old.eintraege IN ACCESS SHARE MODE
| pg_dumpall: pg_dump failed on database "jsopac", exiting
| Re-enabling connections to the old cluster...
| Re-enabling connections to the new cluster...
| Error during cluster dumping, removing new cluster
Reason is the use of the pg_dumpall from 9.1, which does not work with
the 8.4 server:
| # sudo -u postgres /usr/lib/postgresql/9.1/bin/pg_dumpall -s > out
| pg_dump: SQL command failed
| pg_dump: Error message from server: ERROR: OLD used in query that is not in
a rule
| LINE 1: LOCK TABLE old.eintraege IN ACCESS SHARE MODE
| ^
| pg_dump: The command was: LOCK TABLE old.eintraege IN ACCESS SHARE MODE
| pg_dumpall: pg_dump failed on database "jsopac", exiting
| # sudo -u postgres /usr/lib/postgresql/8.4/bin/pg_dumpall -s > out
| #
Bastian
-- System Information:
Debian Release: wheezy/sid
APT prefers stable
APT policy: (990, 'stable'), (500, 'stable-updates'), (500, 'testing'), (400,
'unstable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.2.0-3-amd64 (SMP w/1 CPU core)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
--- End Message ---
--- Begin Message ---
Source: postgresql-common
Source-Version: 144
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.
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 protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Christoph Berg <[email protected]> (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 [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Fri, 31 May 2013 21:37:47 -0700
Source: postgresql-common
Binary: postgresql-common postgresql-client-common postgresql-server-dev-all
postgresql postgresql-client postgresql-doc postgresql-contrib
Architecture: source all
Version: 144
Distribution: unstable
Urgency: low
Maintainer: Debian PostgreSQL Maintainers
<[email protected]>
Changed-By: Christoph Berg <[email protected]>
Description:
postgresql - object-relational SQL database (supported version)
postgresql-client - front-end programs for PostgreSQL (supported version)
postgresql-client-common - manager for multiple PostgreSQL client versions
postgresql-common - PostgreSQL database-cluster manager
postgresql-contrib - additional facilities for PostgreSQL (supported version)
postgresql-doc - documentation for the PostgreSQL database management system
postgresql-server-dev-all - extension build tool for multiple PostgreSQL
versions
Closes: 688960
Changes:
postgresql-common (144) unstable; urgency=low
.
* testsuite: Allow overriding the list of versions to test (-v).
* 040_upgrade: Add a test case for #688960 ("OLD used in query that is not
in a rule").
* pg_upgradecluster: Add --quote-all-identifiers to the pg_dump(all)
invocations so pg_dump-style upgrades do not fail when keywords get
un-reserved. (Closes: #688960; the pg_upgrade part of this will be fixed
in PostgreSQL upstream.)
* pg_ctlcluster: Add --mode shutdown option.
* pg_virtualenv: Allow running as non-root user.
Checksums-Sha1:
a0f45d7c35806786a69638ed16bb7881aaf3c42a 2151 postgresql-common_144.dsc
b2a29adb5e53b654913d6cdade982008656ce99f 159578 postgresql-common_144.tar.gz
5e0f661d2880936727a54e697d974c7c50b6b5e3 50818
postgresql-server-dev-all_144_all.deb
28da0e043f9b8844383cc6334a0c6e2c878100e3 46180
postgresql_9.3+142really9.1+144_all.deb
d388d6c9359b45e85ed91379aa992b5ac347b793 46202
postgresql-client_9.3+142really9.1+144_all.deb
d0250f4c3e19d30b1ecba6d3a8941a2fd40d1d1e 46192
postgresql-doc_9.3+142really9.1+144_all.deb
5c8a6da5a2bb4a05342ad03c8111d6f36775824a 46204
postgresql-contrib_9.3+142really9.1+144_all.deb
bd6c71f469aaa4cc5912659f29a6abf79727393d 155480 postgresql-common_144_all.deb
a0de7f959e24e7b0b5bb42ce95efda3dd33a6bc5 68338
postgresql-client-common_144_all.deb
Checksums-Sha256:
defa551127a1e5a56db5d35ff6fc7f5ff8e993c51c0cd7a34f3f0275feab0c0f 2151
postgresql-common_144.dsc
d21a9a8cc31650742f2b733682c657bb350831a34f7de9b3a8907e3595bb5cc0 159578
postgresql-common_144.tar.gz
666df44d6e9804ed79e52451c50ca9fea8b92176f24e7195590e3b5d22526076 50818
postgresql-server-dev-all_144_all.deb
54c1a65bcbc3552f1b7e2d516ab610a0c55fe7c2fa911ada89df626b5f3c3934 46180
postgresql_9.3+142really9.1+144_all.deb
6458e9f59ccdd3a1989c78d78b4a0d405835aed4c3acde6eac9c5798010214ee 46202
postgresql-client_9.3+142really9.1+144_all.deb
12e80110285c26513c51330a67bff204c73e1429e4f9c8fc3a8f38485c9c1630 46192
postgresql-doc_9.3+142really9.1+144_all.deb
815d9fdcf2bc4ed261b6ca30daac036a4b628ae2e00651985c7f3958e1d367be 46204
postgresql-contrib_9.3+142really9.1+144_all.deb
c6e1b86f3301d0eccaae78afa4bcb0b68999075703ff707a9a0e9070f7d21446 155480
postgresql-common_144_all.deb
b050d21ff83b6f1f3dd6b7537b63d60aef815051c792702a11927ffb83fbe25d 68338
postgresql-client-common_144_all.deb
Files:
9ea3a79ba57b0b7716accb9b3e5c9013 2151 database optional
postgresql-common_144.dsc
fdedf24ade9f5981f3837baa3325bb5a 159578 database optional
postgresql-common_144.tar.gz
e164ee1321a5036b4a822dc21a5a1fe0 50818 database optional
postgresql-server-dev-all_144_all.deb
6e01a0007a5866730ee734a9ce2ac68d 46180 database optional
postgresql_9.3+142really9.1+144_all.deb
69c775d5a96b212602ceee2a4bfdc056 46202 database optional
postgresql-client_9.3+142really9.1+144_all.deb
cb49c0feb4a4af2072acd2ea3442628f 46192 doc optional
postgresql-doc_9.3+142really9.1+144_all.deb
05afae9f70b956768922a456190c933c 46204 database optional
postgresql-contrib_9.3+142really9.1+144_all.deb
12e944d05fa4cc58a70ecaa8077f677c 155480 database optional
postgresql-common_144_all.deb
ab71155e6acf5b6168f60412be378f5c 68338 database optional
postgresql-client-common_144_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
iQIcBAEBCAAGBQJRqXtDAAoJEExaa6sS0qeu+/AP/j+4fv71IU1p9DncPi8Uo56J
3VmnB2daEy5aMexPg+3nloBhI9mAsNBm571Q49pICEXtP3x1TXiseQm5U1xAd9uK
MLKPzIDQDOoS3JKBsC5aIh3xMNzvTb4lE+Kqf4Oi0AsPAaFMfDjjrVt5GOqXPQj+
56IZn6RV1pUStps3vYGYyxJnx3C7rRp+BdKAlwA0lzeckYtUbwyP0AJpvUd2R7C6
Gt3KWqmZCaQoIgco98Q+WebMQgKAVH+rPhMHU6mE0GpFCsf5bmfD9K6Re1YaG+tC
4XE+ftqUxsoFgkqMcHVUKyEbUI5CtPnFG0zfn6k2b1M1V8YkWoL+fJuP6L37FdIT
QRkjc+tGCcoDjil86iPnGn2bqhzxRmAZMoAk691nphp4hall0mXv/W/kJ9kkpJJg
Vxpd5zm0qDD/P/jxusRTX+RUav2CuBhDjpqu+BrqA6rMPsuTXDxxNDquWSnTaYdr
+ohQu+D7Kr7jG6Oq7JpAo0jYQ+PUNnHq9deRZVC+Lx7NUXKJRnEAAds10pWJr9IM
FoR23b6ow9CqH6F2aFdWeX78FyBxeY0CPfy0Rh4cEYBpfwC8+2V771UQyJeN9QtR
Jc6uIqxudBz1D0x2AJX3vLhHJdB3wfUswmra/er4JRACTuzdMl4CWkDK664s23aB
EZCfomVfmeJPY0Bmo5zD
=MMvF
-----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
