Hi Martin -- I'm still seeing an anomoly in the upgrade. After do-release upgrade, postgres-8.4 is no longer running. I see at the beginning of the upgrade, the explicit stop of the service, but I never see it started again. After I upgrade, I get the following:
root@ubuntu:~# sudo -u postgres psql -l could not change directory to "/root" psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? root@ubuntu:~# dpkg -l |grep postgres ii postgresql-8.4 8.4.14-0ubuntu12.04 object-relational SQL database, version 8.4 server ii postgresql-client-8.4 8.4.14-0ubuntu12.04 front-end programs for PostgreSQL 8.4 ii postgresql-client-common 129ubuntu1 manager for multiple PostgreSQL client versions ii postgresql-common 129ubuntu1 PostgreSQL database-cluster manager root@ubuntu:~# ps -ef |grep postgres root 23383 1116 0 16:41 pts/0 00:00:00 grep --color=auto postgres root@ubuntu:~# root@ubuntu:~# sudo service postgresql start root@ubuntu:~# sudo service postgresql-8.4 start * Starting PostgreSQL 8.4 database server ...done. root@ubuntu:~# sudo -u postgres psql -l could not change directory to "/root" List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- foo | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres (4 rows) root@ubuntu:~# I'll also attach the screen log from the do-release-upgrade attempt. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1058218 Title: do-release-upgrade (lucid->precise) leaves postgres 8.4 in bad state To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.4/+bug/1058218/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs