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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
