pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed9.1 to 9.2 upgrade surprises
2+ messages / 2 participants
[nested] [flat]
* 9.1 to 9.2 upgrade surprises
@ 2014-01-01 16:07 Milos Gajdos <gy2kre@centrum.cz>
0 siblings, 1 reply; 2+ messages in thread
From: Milos Gajdos @ 2014-01-01 16:07 UTC (permalink / raw)
To: 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!
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 9.1 to 9.2 upgrade surprises
@ 2014-01-01 16:34 David Johnston <polobo@yahoo.com>
parent: Milos Gajdos <gy2kre@centrum.cz>
0 siblings, 0 replies; 2+ messages in thread
From: David Johnston @ 2014-01-01 16:34 UTC (permalink / raw)
To: pgsql-admin
Milos Gajdos wrote
> 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 ]
> ~ $
So why is it you think dropping a cluster is going to cause the entire
installation of 9.1 to go away?
The attempt to restart the 9.1 databases succeeds but it is successful in
starting zero clusters. I'll admit that it could be more descriptive but it
isn't hurting anything for the attempt.
Note that the reason the init.d script tries to start the 9.1 server is
because of the presence of a "/usr/lib/postgresql/9.1" directory.
The uninstall routine does appear buggy but I'm not really in a position to
look into or comment on it.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/9-1-to-9-2-upgrade-surprises-tp5784987p5784988.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-01-01 16:34 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-01-01 16:07 9.1 to 9.2 upgrade surprises Milos Gajdos <gy2kre@centrum.cz>
2014-01-01 16:34 ` David Johnston <polobo@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox