I have Cloudera Manager 5.9 installed on Ubuntu 12.04 with a built-in postgres database. I upgraded Ubuntu to 14.04 using a do-release update. During this process, Postgres also received a boost from 8.4 to 9.3. Now when I try to start the CM database with:
I get the following error in CM db.log:
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 8.4, which is not compatible with this version 9.3.15.
How do I get past this? I looked at a lot of documentation that talks about dumping a Postgres database via pg_dump and restoring using PSQL, but I don't know how this applies in the context of the Cloudera manager, especially when the database is not suitable.
In Ubuntu 12.04, when everything works, I believe that a dump can be done as follows:
psql. cdh, ?