Your message dated Mon, 08 Aug 2011 14:48:48 +0000
with message-id <[email protected]>
and subject line Bug#539651: fixed in postgresql-common 119
has caused the Debian Bug report #539651,
regarding postgresql-common: postgresql8.3->8.4 conversion problems
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.)
--
539651: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=539651
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-common
Version: 100
Severity: normal
After an apparently successfull conversion the db wouldn't start:
--------
Copying old configuration files...
Copying old start.conf...
Copying old pg_ctl.conf...
Stopping target cluster...
Stopping old cluster...
Disabling automatic startup of old cluster...
Configuring old cluster to use a different port (5434)...
Starting target cluster on the original port...
The PostgreSQL server failed to start. Please check the log output.
Error: Could not start target cluster; please check configuration and log files
--------
Postgres didn't start so there are no postgres logs to check. While checking
through the config files I found the following in the converted postgresql.conf:
external_pid_file = '/var/run/postgresql/8.4-mydb.pid' # write an
extra PID file
external_pid_file = '/var/run/postgresql/8.3-mydb.pid' # write an
extra PID file
(I have no "main" cluster by default, although one was (successfully) created
(and started) as part of the new install).
That's very minor though, and wasn't the cause of the problem. What was was
found in syslog and was caused by a change in the format of pg_hba.conf:
"authentication option not in name=value format"
I'm using ident maps for local authentication. Previously the authentication
options were simply a pair with no = sign required. It would be nice if the
conversion could check for this (anything following a known auth method on a
line has to be an auth option, which is now required to be in name=value
format), and warn the user if it finds any auth options that don't include an =
sign. (You could probably just insert an = sign between the 2 words and handle
the conversion automatically, but the user should still be warned in that
situation).
Failing that it would be nice to include this information in a news item
(although that would probably go with the newer postgres version rather than
postgresql-common).
Once I corrected that everything started up just fine. I suspect that this
isn't likely to hit most people, and is easy to fix once you track it down -
but isn't as seamless as it could be. And if you happen to not look at syslog
can be tricky to track down. Would be nice if the postmaster output was passed
through to the console in case of a startup failure.
Thanks in advance,
-jcm
-- System Information:
Debian Release: squeeze/sid
APT prefers testing
APT policy: (900, 'testing'), (100, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.30.4+00.amd64.fbcondecor (SMP w/2 CPU cores; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages postgresql-common depends on:
ii adduser 3.110 add and remove users and groups
ii debconf [debconf-2.0] 1.5.27 Debian configuration management sy
ii lsb-base 3.2-22 Linux Standard Base 3.2 init scrip
ii lsb-release 3.2-22 Linux Standard Base version report
ii postgresql-client-common 100 manager for multiple PostgreSQL cl
ii procps 1:3.2.8-1 /proc file system utilities
Versions of packages postgresql-common recommends:
ii ssl-cert 1.0.23 simple debconf wrapper for OpenSSL
postgresql-common suggests no packages.
-- debconf information:
* postgresql-common/obsolete-major:
--- End Message ---
--- Begin Message ---
Source: postgresql-common
Source-Version: 119
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_119_all.deb
to main/p/postgresql-common/postgresql-client-common_119_all.deb
postgresql-common_119.dsc
to main/p/postgresql-common/postgresql-common_119.dsc
postgresql-common_119.tar.gz
to main/p/postgresql-common/postgresql-common_119.tar.gz
postgresql-common_119_all.deb
to main/p/postgresql-common/postgresql-common_119_all.deb
postgresql-server-dev-all_119_all.deb
to main/p/postgresql-common/postgresql-server-dev-all_119_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 [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Martin Pitt <[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: Mon, 08 Aug 2011 15:31:17 +0200
Source: postgresql-common
Binary: postgresql-common postgresql-client-common postgresql-server-dev-all
Architecture: source all
Version: 119
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <[email protected]>
Changed-By: Martin Pitt <[email protected]>
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: 539611 539651 606336 618577 618583 632702 633801 635594 636957
Changes:
postgresql-common (119) unstable; urgency=low
.
[ Martin Pitt ]
* PgCommon.pm, set_conf_value(): Fix the case where a key exists first as a
commented value, and then uncommented. Add appropriate test cases to
t/005_PgCommon.t. (Closes: #539651)
* debian/postgresql-common.postgresql.init: Fix "status" command when some
clusters are down. (Closes: #635594)
* pg_upgradecluster: Only call pg_ctl with the -t option with old clusters
>= 8.4, as earlier versions do not yet support it. (Closes: #633801)
* debian/postgresql-common.postinst: Remove some obsolete transition
logic.
* architecture.html, cleanpg, debian/init.d-functions, pg_createcluster:
Remove obsolete references to per-version init scripts. (Closes: #636957)
* debian/maintscripts-functions: Remove our tsearch data symlinks on
removal. (Closes: #539611)
* PgCommon.pm: Make {read,set,disable,replace}_conf_value() case
independent for *.conf files, as per upstream specification. Add
appropriate test cases to t/005_PgCommon.t. (Closes: #618577)
* PgCommon.pm: Make {read,set,disable,replace}_conf_value() accept "key
value" lines without '=', as this is optional as per upstream
specification. Add appropriate test cases to t/005_PgCommon.t. Thanks
to Frederic Junod for the original patch suggestion. (Closes: #618583)
* PgCommon.pm, cluster_info(): If postgresql.conf defines an external PID
file, check its existence for determining if a cluster is running, instead
of poking the port. This is more efficient, and also gives correct results
for overlapping port numbers. Based on a patch from Jens Wilke, thanks!
(Closes: #606336)
* pg_buildext: Apply various improvements from Christoph Berg, thanks!
.
[ Peter Eisentraut ]
* pg_createcluster: Update comment alignment to match existing file better.
(Closes: #632702)
Checksums-Sha1:
a06fdc7b82968c15809e266c2054b7fd1d7b2336 1579 postgresql-common_119.dsc
58838cc13b1f72476347372cd7b9a692ef9507a7 130431 postgresql-common_119.tar.gz
3b5ff5e32ee11999749716a630fba8f3d55fa89f 130720 postgresql-common_119_all.deb
e872ed1279a52c8b9c7c744ebf30962624feb7ac 59452
postgresql-client-common_119_all.deb
e15d192902b63bb57c505a4e6b46bc8fb75725d7 45504
postgresql-server-dev-all_119_all.deb
Checksums-Sha256:
69dcbeb558cecd1cbecc8f67966f1a076708729d307332293978a87858a7c131 1579
postgresql-common_119.dsc
3179996b925f84a10867a7fce948e33898ed675c37d7e807e285eb3752be679e 130431
postgresql-common_119.tar.gz
df2ef99a33b7e957b541f9957f2236c3040c3f8a6360ad070efb3baf2b7cebe7 130720
postgresql-common_119_all.deb
cad73c5509ec836c32d6a4daff42e34bce4cbd802b52b3fcbb769edd22c3f9a3 59452
postgresql-client-common_119_all.deb
3d7dccdebe865371f1495621a34b87425d4f547ba6907df9a310711b1775831d 45504
postgresql-server-dev-all_119_all.deb
Files:
c77be19323cf06219b3095f37d4fcd63 1579 database optional
postgresql-common_119.dsc
eecc527531077e67dfa8c29c4ffc6160 130431 database optional
postgresql-common_119.tar.gz
0ee545f81e2b67fcb1035d88f6525ff6 130720 database optional
postgresql-common_119_all.deb
ac919a84415563b1c2d9dca6ce167a4d 59452 database optional
postgresql-client-common_119_all.deb
57a7c2260806068f5c76c3d6f906d0b6 45504 database optional
postgresql-server-dev-all_119_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iQIcBAEBCAAGBQJOP+YMAAoJEPmIJawmtHufGDoP/0i5sPSmhME26cYk7wRjhOtf
MPhLoMQporyQBt74uxHIeH+QkACNtwRw8QQzvyxFjmv+Q79oU07qTu+m5Ju2TTTV
Es3fOZ1jq8TFI6gi67uU1a/R/a/veOiEQQNqqO5HB+cFaNH/3R+892bwh2++508z
lDsz7EYHvsTRP+oCsaN49jyUHU//YYRS7MxlfkoMgDCobjMONadmJvhN8jcghGOl
+u+eG4spbDi0vgMvQDK6j2/IYkOUFVGIO+Qt11hNtXDe7/5Er0Dg59NJeIlNF88y
tSALqZj6WPhBRTe5piR3Ykxa8fxoLUrkvTV4EZHTKwq7LIDOwgl1kE5NlZKyb/fY
w9e2K8YhXM5/o2HKIpRBY1dw1S4sgoYHgMr0A3hBPi4/Fp0oPeswIgZDiN7XQrft
9n5twawSv4yBQ3zrcM4uLEXFdS+hkgJPkW+CewKM0jVJ/M9M7ksU3P8PIfujP88D
mq+3351nD+lSca+ThaKcXQigHFgC1WnZ83ogh8lhnuPtCffNVN6ujHJMPE2Re3Cc
5GOXYAWLEtpz9pNXevStQkRrulRDKfj8f/Cg1KW/CT2CiFrBkrMSFDJhmMrtXH91
hs9KqlF46axVZbRf0/KS893zupCow2ltOnny+cEF9uVwPmEqxeKfXOxC04JbYUhL
1GrL7WlGvgQZzP6DMoX/
=gubJ
-----END PGP SIGNATURE-----
--- End Message ---
