I am able to resolve this problem using the following process: Step 1: Take a dump of the running postgres database on Ubuntu 14.02 # sudo su # su - postgres # pg_dump -h localhost -p 7432 -U scm scm > scm.sql Step 2: Upgrade Ubuntu to 16.04 # sudo do-release-upgrade Step 3: Rename the old data directory # mv /var/lib/cloudera-scm-server-db/data/ /var/lib/cloudera-scm-server-db/data9-3 Step 4: Restart cloudera-scm-server-db service. This will create an empty database which we will populate using the backup taken in step 1 # sudo service cloudera-scm-server-db restart Step 5: Now restore the database # sudo su # su - postgres # psql -h localhost -p 7432 -U scm (password can be obtained like this: grep password /etc/cloudera-scm-server/db.properties) scm> \i scm.sql Step 6: Now restart cloudera-scm-server service: # sudo service cloudera-scm-service restart However, I'm now running into another problem. the cloudera-scm-agent services do not start. There is an error in supervisord.out. I will open another thread for this: Traceback (most recent call last): File "/usr/lib/cmf/agent/build/env/bin/supervisord", line 8, in <module> from pkg_resources import load_entry_point File "/usr/lib/cmf/agent/build/env/lib/python2.7/site-packages/pkg_resources/__init__.py", line 36, in <module> import plistlib File "/usr/lib/python2.7/plistlib.py", line 62, in <module> import datetime ImportError: No module named datetime
... View more
