How to update the Cloudera Manager Postgres database

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:

# sudo service cloudera-scm-server-db start

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:

#pg_dump -h localhost -p 7432 -U scm > /tmp/scm_server_db_backup.$(date +%Y%m%d)

psql. cdh, ?

+4

Source: https://habr.com/ru/post/1665280/


All Articles