[cisco-voip] CUCM IM&P and postgress database "instances"

[Ryan Huff]

Lelio,

Follow this guide; 

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/im_presence/database_setup/9_0_1/CUP0_BK_D6919EAA_00_database-setup-guide-imp-90/CUP0_BK_D6919EAA_00_database-setup-guide-imp-90_chapter_010.html

Walks you through the DB setup ... etc.  Having done CPIM compliance server installs more than a few times, I can tell you it isn't as tough as the docs make it seem.

Thanks,

Ryan

Date: Tue, 21 Jul 2015 14:38:19 -0400
From: lelio at uoguelph.ca
To: ryanhuff at outlook.com
CC: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CUCM IM&P and postgress database "instances"


Thanks Ryan. 
Just reading through some more documents and it seems that's correct. One actual spin of the postgreSQL process with multiple databases on that process. The documents show that I have to create the appropriate users and databases on the postgreSQL CLI and then the rest is done on the IM&P servers, i.e. the creating of the tables.
This is still a pilot project, but I want to be able to use as many features as possible. In the event we go production, especially if we go Jabber for Everyone, I would definitely recommend some sort of postgreSQL cluster or however they do redundancy. 
We have limited postgreSQL experience in our area, so it might even mean getting a contractor in to decide how to configure things properly. Especially for things like performance and system backup/restore.
Cheers, Lelio

---
Lelio Fulgenzi, B.A.
Senior Analyst, Network Infrastructure
Computing and Communications Services (CCS)
University of Guelph

519‐824‐4120 Ext 56354
lelio at uoguelph.ca
www.uoguelph.ca/ccs
Room 037, Animal Science and Nutrition Building
Guelph, Ontario, N1G 2W1

From: "Ryan Huff" <ryanhuff at outlook.com>
To: "Lelio Fulgenzi" <lelio at uoguelph.ca>
Cc: cisco-voip at puck.nether.net
Sent: Tuesday, July 21, 2015 2:30:06 PM
Subject: RE: [cisco-voip] CUCM IM&P and postgress database "instances"

I believe it would still be just one DB instance on your external DB server for the IM&P cluster. Now outside of the Cisco world; you could then setup your own PostgreSQL farm for redundancy ... etc.

Date: Tue, 21 Jul 2015 13:12:23 -0400
From: lelio at uoguelph.ca
To: ryanhuff at outlook.com
CC: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CUCM IM&P and postgress database "instances"


So depending on my cluster configuration, I could have up to six or eight postgreSQL instances running on my database server?

Seems like overkill. Wonder why they couldn't simply use a different table in the database?

---
Lelio Fulgenzi, B.A.
Senior Analyst, Network Infrastructure
Computing and Communications Services (CCS)
University of Guelph

519‐824‐4120 Ext 56354
lelio at uoguelph.ca
www.uoguelph.ca/ccs
Room 037, Animal Science and Nutrition Building
Guelph, Ontario, N1G 2W1

From: "Ryan Huff" <ryanhuff at outlook.com>
To: lelio at uoguelph.ca, cisco-voip at puck.nether.net
Sent: Tuesday, July 21, 2015 1:07:47 PM
Subject: Re: [cisco-voip] CUCM IM&P and postgress database "instances"

Lelio,Yes you need an external instance of postgresql. I find that Ubuntu works best.Thanks,Ryan

-------- Original Message --------
From: Lelio Fulgenzi <lelio at uoguelph.ca>
Sent: Tuesday, July 21, 2015 12:37 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] CUCM IM&P and postgress database "instances"


I'm trying to make sense out of the database instance requirements for persistent chat, etc., in the IM&P section of the v9 SRND.

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/srnd/9x/uc9x/presence.html

In particular:

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/srnd/9x/uc9x/presence.html#wp1133638

Are they referring to different tables in the same database process running on the server, or are they requiring that I spin up additional postgreSQL instances on different TCP ports?



---
Lelio Fulgenzi, B.A.
Senior Analyst, Network Infrastructure
Computing and Communications Services (CCS)
University of Guelph

519‐824‐4120 Ext 56354
lelio at uoguelph.ca
www.uoguelph.ca/ccs
Room 037, Animal Science and Nutrition Building
Guelph, Ontario, N1G 2W1



 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20150721/248a0b0b/attachment.html>