9.1 to 9.2 upgrade surprises

Поиск
Список
Период
Сортировка
От Milos Gajdos
Тема 9.1 to 9.2 upgrade surprises
Дата
Msg-id 20140101170732.5A3C7F70@centrum.cz
обсуждение исходный текст
Ответы Re: 9.1 to 9.2 upgrade surprises  (David Johnston <polobo@yahoo.com>)
Список 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
somehowtries 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!



В списке pgsql-admin по дате отправления:

Предыдущее
От: Omer Faruk SEN
Дата:
Сообщение: Migration from 8.2 to 8.4 or major version migration and how postgres db is handled?
Следующее
От: David Johnston
Дата:
Сообщение: Re: 9.1 to 9.2 upgrade surprises