If you need to change the postgres external database for CUCM, there a few steps to follow:
- Change database server name
- External server setup -> External databases
- Unassign servers and disable persistent chat
- Messaging -> Group Chat and Persistent Chat
- Change “Persistant Chat Database Assigntment” to unsassigned
- Uncheck “Enable Persistant Chat” and Save
- Assign servers and enable persistent chat
- Messaging -> Group Chat and Persistent Chat
- Change “Persistant Chat Database Assigntment” to sassigned
- Check “Enable Persistant Chat” and Save
- Restart Cisco XCP Router
- Start XCP Text Conference Manager
This blog post helped figure out the process: http://collabtechnotes.blogspot.com/2015/07/postgre-sql-cisco-xcp-message-archiver.html