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

[Ryan Huff]

If you need/want any additional assistance just unicast me.

Thanks,

Ryan

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

>Thanks Ryan. 
>
>That's the one I'm reading (among others). I'm in the planning stages right now. So reading through first, without actually having access to servers to try things out. 
>
>
>
>--- 
>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 
>
>----- Original Message -----
>
>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:45:36 PM 
>Subject: RE: [cisco-voip] CUCM IM&P and postgress database "instances" 
>
>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/6309e8fc/attachment.html>