9.1 to 9.2 upgrade surprises

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux