Cloudera Manager Server Database fails to start

[#1]

After a hostname change, the cloudera manager server database fails to start. This causes the manager not to start either. The files in /etc/cloudera-scm-server/db.mgmt.properties show the old hostname.

a) Where are the logs for the cloudera manager server database on Ubuntu 14.04?

b) How do I get the database started.

c) For many reasons, I can't use the old hostname any more

thanks

Verghese

[#2]

And it is definitely some stale state, but I don't know where this state is:

org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)

[#3 · Accepted solution]

I figured out what the problem was and am posting this as a community service:

a) Cloudera server db log is in /var/log/cloudera-scm-server/db.log

b) Once I found the log, the problem was lack of memory on the new system since psql needs a contiguous chunk.

Due to the lomem issue, the server failed to start and did not clear out stale state in management properties.