Secondary External database and backup PostgreSQL for CUPS

[dan hale]

Hello All, I have a Presence Redundancy Group and I'm using persistent chat with PostgreSQL. Do I point my secondary CUPS server (backup) to the same PostgreSQL database or do I need to spin up another PostgreSQL database.

With that in mind if I do connect the secondary CUPS server to the primary  PostgreSQL database what are my options to back up the original.

I'm running CUPS 10.5

Thanks,

Daniel

[Jaime Valencia · Accepted solution]

Read here

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/im_presence/database_setup/10_5_2/CUP0_BK_D4BFFAC9_00_database-setup-guide-imp-1052/CUP0_BK_D4BFFAC9_00_database-setup-guide-imp-1052_chapter_00.html#CUP0_RF_E760A341_00

And FYI, CUPS only goes as far as 8.6, with 9.x+ the name is IM&P

As to backing up the DB, refer to PostgreSQL info for that.

[dan hale]

Thanks Jaime for the link. If I'm using balanced mode High Availability for my users (splitting my users between two nodes) would there be any issues with having two databases for persistent and group chat.

According to the link "Each node requires its own logical database"

Would or could there be any issues with users that start a group/persistent chat and one user is on one node and the other is associated to the other node?

What's recommended in this scenario.

Thanks,

Daniel

[Jaime Valencia]

The recommendations are already outlined in the link I provided, yes, you need a logical DB per node.