9.1 to 9.2 upgrade surprises

From: Milos Gajdos <gy2kre(at)centrum(dot)cz>
To: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: 9.1 to 9.2 upgrade surprises
Date: 2014-01-01 16:07:32
Message-ID: 20140101170732.5A3C7F70@centrum.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

So I upgraded our Postgresql boxes from 9.1 to 9.2.
Everything went pretty smooth except for a few glitches , but now all's good.

After the upgrade I dropped the original 9.1 cluster:

$ sudo pg_dropcluster 9.1.old main

After this I correctly ended up with just newly installed 9.2 cluster:

~ $ sudo pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
9.2 main 5432 online postgres /var/lib/postgresql/9.2/main /var/log/postgresql/postgresql-9.2-main.log
~ $

Now, when I try to restart postgresql I get the following:
~ $ /etc/init.d/postgresql restart
* Restarting PostgreSQL 9.1 database server [ OK ]
* Restarting PostgreSQL 9.2 database server [ OK ]
~ $

W00T ?! 9.1 ? I thought I had removed that one....Now, I'm guessing that has to do with this ?

$
~ $ ls -l /etc/postgresql/
total 8
drwxr-xr-x 3 postgres postgres 4096 Jan 1 16:01 9.1
drwxr-xr-x 3 postgres postgres 4096 Dec 30 18:21 9.2
~ $

Upgrade process made a backup of all 9.1 configuration files and pg_dropcluster didn't remove it and init scripts stil somehow tries to restart it ?

NoW, the weirdest thing. I tried to remove 9.1 package as I dont need those...these are ALL PG packages installed:

~ $ dpkg -l|grep postgres
ii check-postgres 2.18.0-1 script for monitoring PostgreSQL databases
ii pgdg-keyring 2013.2 keyring for apt.postgresql.org
ii postgresql 9.1+129ubuntu1 object-relational SQL database (supported version)
ii postgresql-9.1 9.1.9-0ubuntu12.04 object-relational SQL database, version 9.1 server
ii postgresql-9.2 9.2.6-1.pgdg12.4+1 object-relational SQL database, version 9.2 server
ii postgresql-9.2-dbg 9.2.6-1.pgdg12.4+1 debug symbols for postgresql-9.2
ii postgresql-9.2-repmgr 2.0~beta1-2.pgdg12.4+1 replication manager support modules for PostgreSQL 9.2
ii postgresql-client 9.1+129ubuntu1 front-end programs for PostgreSQL (supported version)
ii postgresql-client-9.1 9.1.9-0ubuntu12.04 front-end programs for PostgreSQL 9.1
ii postgresql-client-9.2 9.2.6-1.pgdg12.4+1 front-end programs for PostgreSQL 9.2
ii postgresql-client-common 151.pgdg12.4+1 manager for multiple PostgreSQL client versions
ii postgresql-common 151.pgdg12.4+1 PostgreSQL database-cluster manager
ii postgresql-contrib-9.1 9.1.9-0ubuntu12.04 additional facilities for PostgreSQL
ii postgresql-contrib-9.2 9.2.6-1.pgdg12.4+1 additional facilities for PostgreSQL
ii postgresql-server-dev-9.1 9.1.9-0ubuntu12.04 development files for PostgreSQL 9.1 server-side programming
ii postgresql-server-dev-9.2 9.2.6-1.pgdg12.4+1 development files for PostgreSQL 9.2 server-side programming
~ $

So I ran this and got the BIGGEST SURPRISE so far - LOOKS LIKE REMOVAL OF 9.1 PACKAGES TRIES TO INSTALL 9.3 ones ??? UHH
I have INDEED aborted the uninstall straight away and would like some PG gurus opinion on this:

$ sudo apt-get remove --purge postgresql-9.1 postgresql-client-9.1 postgresql-contrib-9.1 postgresql-server-dev-9.1
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following package was automatically installed and is no longer required:
libkrb5-dev
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
postgresql postgresql-9.3 postgresql-client postgresql-client-9.3
Suggested packages:
oidentd ident-server locales-all postgresql-doc-9.3
The following packages will be REMOVED:
postgresql-9.1* postgresql-client-9.1* postgresql-contrib-9.1* postgresql-server-dev-9.1*
The following NEW packages will be installed:
postgresql-9.3 postgresql-client-9.3
The following packages will be upgraded:
postgresql postgresql-client
2 upgraded, 2 newly installed, 4 to remove and 133 not upgraded.
Need to get 5,408 kB of archives.
After this operation, 2,966 kB of additional disk space will be used.
Do you want to continue [Y/n]? n
Abort.

THanks!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Johnston 2014-01-01 16:34:43 Re: 9.1 to 9.2 upgrade surprises
Previous Message Omer Faruk SEN 2013-12-27 12:20:56 Migration from 8.2 to 8.4 or major version migration and how postgres db is handled?