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
