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!