[Pkg-postgresql-public] Bug#840882: Acknowledgement (postgresql-common: Prescribed Upgrade fails)

2016-10-16 Thread Helge Kreutzmann 
Hello,
after a reboot I see:
helge@samd:~/texte/TODO$ psql rechnung
psql (9.6.0, Server 9.5.4)
Geben Sie »help« für Hilfe ein.

And on first sight the DB looks fine.

So maybe a full reboot is necessary?

What is strange is, that the server is 9.5.4:
helge@samd:~/texte/TODO$ dpkg -l "*postgres*" | grep ii | grep 5
ii  postgresql-9.5  9.5.4-3  amd64 object-relational SQL 
database, version 9.5 server
ii  postgresql-client-9.5   9.5.4-3  amd64front-end programs 
for PostgreSQL 9.5
ii  postgresql-plperl-9.5   9.5.4-3  amd64PL/Perl procedural 
language for PostgreSQL 9.5

Greetings

  Helge

-- 
  Dr. Helge Kreutzmann deb...@helgefjell.de
   Dipl.-Phys.   http://www.helgefjell.de/debian.php
64bit GNU powered gpg signed mail preferred
   Help keep free software "libre": http://www.ffii.de/


signature.asc
Description: Digital signature
___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#840882: postgresql-common: Prescribed Upgrade fails

2016-10-15 Thread Helge Kreutzmann 
Package: postgresql-common
Version: 177
Severity: important

A while ago this machine was installed with testing.

A few days ago I was informed to upgrade postgresql. This worked
flawlessly in previous versions of Debian.

Now I drop the default main in 9.6, i.e.
root@samd:~# pg_dropcluster --stop 9.6 main
Redirecting stop request to systemctl

Now I do the update as prescribe in the upgrade notice:
root@samd:~# pg_upgradecluster 9.5 main
Stopping old cluster...
Notice: extra pg_ctl/postgres options given, bypassing systemctl for stop 
operation
pg_ctl: Server fährt nicht herunter
TIPP: Die Option »-m fast« beendet Sitzungen sofort, statt auf das Beenden
durch die Sitzungen selbst zu warten.
Error: Could not stop old cluster

In english:
Stopping old cluster...
Notice: extra pg_ctl/postgres options given, bypassing systemctl for stop 
operation
pg_ctl: Server does not shut down
Hint: The option »-m fast« terminates session immediately, instead of waiting 
for the session
to terminate itself
Error: Could not stop old cluster

I cannot find any information in /var/log/postgresql.

I'm now lost how to finish the upgrade…

-- System Information:
Debian Release: stretch/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 4.5.5samd.10-grsec (SMP w/4 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) (ignored: LC_ALL 
set to de_DE.UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages postgresql-common depends on:
ii  adduser   3.115
ii  debconf [debconf-2.0] 1.5.59
ii  init-system-helpers   1.45
ii  lsb-base  9.20160629
ii  postgresql-client-common  177
ii  procps2:3.3.12-2
ii  ssl-cert  1.0.38
ii  ucf   3.0036

Versions of packages postgresql-common recommends:
ii  logrotate  3.8.7-2

postgresql-common suggests no packages.

-- debconf information:
* postgresql-common/obsolete-major:
* postgresql-common/ssl: true
  postgresql-common/catversion-bump:

-- 
  Dr. Helge Kreutzmann deb...@helgefjell.de
   Dipl.-Phys.   http://www.helgefjell.de/debian.php
64bit GNU powered gpg signed mail preferred
   Help keep free software "libre": http://www.ffii.de/


signature.asc
Description: Digital signature
___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#716854: Bug#716854: postgresql-common: Upgrade Wheezy -> Testing fails: insserv rejected the script header

2013-09-29 Thread Helge Kreutzmann 
Hello Christoph,
On Sun, Sep 29, 2013 at 01:36:14PM +0200, Christoph Berg wrote:
> sorry, I just forgot to reply here.

No problem.

> The problem is the old postgresql-8.1 init script that also provides
> "postgresql" next to the new-style postgresql init script. You need to
> purge postgresql-8.1, or manually remove/edit that file first.

Did that, helped and bug is fixed. Thanks.

> As 8.1 was only part of a very old release (etch?), I don't think we
> are going to provide a fix to automate this. I'm wondering how you got
> that box upgraded to wheezy (or even squeeze) without hitting the same
> problem. We had a fix for the same problem with postgresql-8.3 in
> postgresql-common version 112 from 2010, so that's quite a while ago.

I initially installed this machine on testing 2005 and run testing
for a long time. Finally it ran Squeeze until a few weeks ago, where I
dist-upgraded to wheezy, removed lots of packages, and dist-upgraded
to testing. Atm I cannot reproduce the exact version history, as this
machine has been retired for a while (as my main machine). 

> The new "postgresql" init script will take over management of the 8.1
> cluster as well. (If you still have any data in there, please
> upgrade!)

No, all data bases have been imported on my main machine happily
running wheezy.

Thanks for your excellent postgresql database packaging, it is highly
appreciated.

Greetings

Helge
-- 
  Dr. Helge Kreutzmann deb...@helgefjell.de
   Dipl.-Phys.   http://www.helgefjell.de/debian.php
64bit GNU powered gpg signed mail preferred
   Help keep free software "libre": http://www.ffii.de/


signature.asc
Description: Digital signature
___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#716854: Bug#716854: postgresql-common: Upgrade Wheezy -> Testing fails: insserv rejected the script header

2013-09-28 Thread Helge Kreutzmann 
Hello Christoph,
On Sat, Jul 20, 2013 at 07:22:50PM +0200, Helge Kreutzmann wrote:
> Hello Christoph,
> On Mon, Jul 15, 2013 at 09:34:09AM +0200, Christoph Berg wrote:
> > Control: tag -1 moreinfo
> > 
> > Re: Helge Kreutzmann 2013-07-13 
> > <20130713163701.GA17133@Debian-50-lenny-64-minimal>
> > > postgresql-common (145) wird eingerichtet ...
> > 
> > > insserv: script postgresql: service postgresql already provided!
> > > insserv: exiting now!
> > > update-rc.d: error: insserv rejected the script header
> > > dpkg: Fehler beim Bearbeiten von postgresql-common (--configure):
> > >  Unterprozess installiertes post-installation-Skript gab den Fehlerwert 1 
> > > zurück
> > 
> > Hi Helge,
> > 
> > what does egrep '^#.*postgresql' /etc/init.d/* report on this system?
> 
> remaxp:~# egrep '^#.*postgresql' /etc/init.d/*
> /etc/init.d/exim4:# Should-Start:  postgresql mysql clamav-daemon 
> greylist spamassassin
> /etc/init.d/exim4:# Should-Stop:   postgresql mysql clamav-daemon 
> greylist spamassassin
> /etc/init.d/postgresql:# Provides:  postgresql
> /etc/init.d/postgresql:# set them in 
> /etc/postgresql///environment instead.
> /etc/init.d/postgresql-8.1:# Provides:  postgresql postgresql-8.1
> /etc/init.d/postgresql-8.1:# set them in 
> /etc/postgresql/8.1//environment instead.

Does this help you? I'd really like to get the dist-upgrade to
complete without error.

Thanks!

Greetings

 Helge

-- 
  Dr. Helge Kreutzmann deb...@helgefjell.de
   Dipl.-Phys.   http://www.helgefjell.de/debian.php
64bit GNU powered gpg signed mail preferred
   Help keep free software "libre": http://www.ffii.de/


signature.asc
Description: Digital signature
___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#716854: Bug#716854: postgresql-common: Upgrade Wheezy -> Testing fails: insserv rejected the script header

2013-07-20 Thread Helge Kreutzmann 
Hello Christoph,
On Mon, Jul 15, 2013 at 09:34:09AM +0200, Christoph Berg wrote:
> Control: tag -1 moreinfo
> 
> Re: Helge Kreutzmann 2013-07-13 
> <20130713163701.GA17133@Debian-50-lenny-64-minimal>
> > postgresql-common (145) wird eingerichtet ...
> 
> > insserv: script postgresql: service postgresql already provided!
> > insserv: exiting now!
> > update-rc.d: error: insserv rejected the script header
> > dpkg: Fehler beim Bearbeiten von postgresql-common (--configure):
> >  Unterprozess installiertes post-installation-Skript gab den Fehlerwert 1 
> > zurück
> 
> Hi Helge,
> 
> what does egrep '^#.*postgresql' /etc/init.d/* report on this system?

remaxp:~# egrep '^#.*postgresql' /etc/init.d/*
/etc/init.d/exim4:# Should-Start:  postgresql mysql clamav-daemon greylist 
spamassassin
/etc/init.d/exim4:# Should-Stop:   postgresql mysql clamav-daemon greylist 
spamassassin
/etc/init.d/postgresql:# Provides:  postgresql
/etc/init.d/postgresql:# set them in 
/etc/postgresql///environment instead.
/etc/init.d/postgresql-8.1:# Provides:  postgresql postgresql-8.1
/etc/init.d/postgresql-8.1:# set them in 
/etc/postgresql/8.1//environment instead.

Greetings

   Helge

-- 
  Dr. Helge Kreutzmann deb...@helgefjell.de
   Dipl.-Phys.   http://www.helgefjell.de/debian.php
64bit GNU powered gpg signed mail preferred
   Help keep free software "libre": http://www.ffii.de/


signature.asc
Description: Digital signature
___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

[Pkg-postgresql-public] Bug#716854: postgresql-common: Upgrade Wheezy -> Testing fails: insserv rejected the script header

2013-07-13 Thread Helge Kreutzmann 
Package: postgresql-common
Version: 145
Severity: important

Dear Maintainer,
*** Please consider answering these questions, where appropriate ***

   * What led up to the situation?

I upgraded a machine from Oldstable to Stable, and I'm now in the 
process of upgrading to Testing (Jessie). I upgrade a few packages a 
time (and their dependencies, as specified by the package relations)

   * What exactly did you do (or not do) that was effective (or
 ineffective)?

apt-get update
apt-get install … postgresql-common …

   * What was the outcome of this action?

See below for error message

   * What outcome did you expect instead?

No error message, just a sucessful upgrade run.

*** End of the template - remove these lines ***


Please not that after the failed update I retried it with apt-get -f 
install. The following is the output:

postgresql-common (145) wird eingerichtet ...
supported_versions: WARNING: Unknown Debian release: 7
Kein Verzeichnis, Anmeldung mit HOME=/
insserv: warning: script 'K01anon-proxy' missing LSB tags and overrides
insserv: warning: script 'K01chrony' missing LSB tags and overrides
insserv: warning: script 'K01dbus-1' missing LSB tags and overrides
insserv: warning: script 'K01hotplug' missing LSB tags and overrides
insserv: warning: script 'K01hotplug-net' missing LSB tags and overrides
insserv: warning: script 'K01ipfm' missing LSB tags and overrides
insserv: warning: script 'K01iptables' missing LSB tags and overrides
insserv: warning: script 'K01modutils' missing LSB tags and overrides
insserv: warning: script 'S21libdevmapper1.00' missing LSB tags and overrides
insserv: warning: script 'S20initrd-tools.sh' missing LSB tags and overrides
insserv: warning: script 'S20nviboot' missing LSB tags and overrides
insserv: script postgresql: service postgresql already provided!
insserv: exiting now!
update-rc.d: error: insserv rejected the script header
dpkg: Fehler beim Bearbeiten von postgresql-common (--configure):
 Unterprozess installiertes post-installation-Skript gab den Fehlerwert 1 zurück
Fehler traten auf beim Bearbeiten von:
 postgresql-common
E: Sub-process /usr/bin/dpkg returned an error code (1)


-- System Information:
Debian Release: 7.1
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32.44-grsec
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) (ignored: LC_ALL 
set to de_DE.UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages postgresql-common depends on:
ii  adduser   3.113+nmu3
ii  debconf [debconf-2.0] 1.5.49
ii  logrotate 3.8.5-1
ii  lsb-base  4.1+Debian12
ii  postgresql-client-common  145
ii  procps1:3.3.4-2
ii  ssl-cert  1.0.32

postgresql-common recommends no packages.

postgresql-common suggests no packages.

-- debconf information:
* postgresql-common/obsolete-major:
  postgresql-common/untransitioned:

-- 
  Dr. Helge Kreutzmann deb...@helgefjell.de
   Dipl.-Phys.   http://www.helgefjell.de/debian.php
64bit GNU powered gpg signed mail preferred
   Help keep free software "libre": http://www.ffii.de/


signature.asc
Description: Digital signature
___
Pkg-postgresql-public mailing list
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public