<html><body><div style="font-family: Verdana; font-size: 10pt; color: #000000"><div>Thanks Ryan.</div><div><br></div><div>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. </div><div><br></div><div><br></div><div><br></div><div><span name="x"></span>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst, Network Infrastructure<br>Computing and Communications Services (CCS)<br>University of Guelph<br><div><br></div>519‐824‐4120 Ext 56354<br>lelio@uoguelph.ca<br>www.uoguelph.ca/ccs<br>Room 037, Animal Science and Nutrition Building<br>Guelph, Ontario, N1G 2W1<span name="x"></span><br></div><div><br></div><hr id="zwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" data-mce-style="color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From: </b>"Ryan Huff" <ryanhuff@outlook.com><br><b>To: </b>"Lelio Fulgenzi" <lelio@uoguelph.ca><br><b>Cc: </b>cisco-voip@puck.nether.net<br><b>Sent: </b>Tuesday, July 21, 2015 2:45:36 PM<br><b>Subject: </b>RE: [cisco-voip] CUCM IM&P and postgress database "instances"<br><div><br></div><style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style><div dir="ltr">Lelio,<br><div><br></div>Follow this guide; <br><div><br></div><a href="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" target="_blank" data-mce-href="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">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</a><br><div><br></div>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.<br><div><br></div>Thanks,<br><div><br></div>Ryan<br><div><br></div><div><hr id="stopSpelling">Date: Tue, 21 Jul 2015 14:38:19 -0400<br>From: lelio@uoguelph.ca<br>To: ryanhuff@outlook.com<br>CC: cisco-voip@puck.nether.net<br>Subject: Re: [cisco-voip] CUCM IM&P and postgress database "instances"<br><div><br></div><div style="font-family:Verdana;font-size:10pt;color:#000000;" data-mce-style="font-family: Verdana; font-size: 10pt; color: #000000;"><div><br></div><div>Thanks Ryan. </div><div><br></div><div>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.</div><div><br></div><div>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. </div><div><br></div><div>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.</div><div><br></div><div>Cheers, Lelio</div><div><br></div><div><br></div><div><span></span>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst, Network Infrastructure<br>Computing and Communications Services (CCS)<br>University of Guelph<br><div><br></div>519‐824‐4120 Ext 56354<br>lelio@uoguelph.ca<br>www.uoguelph.ca/ccs<br>Room 037, Animal Science and Nutrition Building<br>Guelph, Ontario, N1G 2W1<span></span><br></div><div><br></div><hr id="ecxzwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" data-mce-style="color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From: </b>"Ryan Huff" <ryanhuff@outlook.com><br><b>To: </b>"Lelio Fulgenzi" <lelio@uoguelph.ca><br><b>Cc: </b>cisco-voip@puck.nether.net<br><b>Sent: </b>Tuesday, July 21, 2015 2:30:06 PM<br><b>Subject: </b>RE: [cisco-voip] CUCM IM&P and postgress database "instances"<br><div><br></div><div dir="ltr">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.<br><div><br></div><div><hr id="ecxstopSpelling">Date: Tue, 21 Jul 2015 13:12:23 -0400<br>From: lelio@uoguelph.ca<br>To: ryanhuff@outlook.com<br>CC: cisco-voip@puck.nether.net<br>Subject: Re: [cisco-voip] CUCM IM&P and postgress database "instances"<br><div><br></div><div style="font-family:Verdana;font-size:10pt;color:#000000;" data-mce-style="font-family: Verdana; font-size: 10pt; color: #000000;"><div><br></div><div>So depending on my cluster configuration, I could have up to six or eight postgreSQL instances running on my database server?<br></div><div><br></div><div>Seems like overkill. Wonder why they couldn't simply use a different table in the database?<br></div><div><br></div><div><span></span>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst, Network Infrastructure<br>Computing and Communications Services (CCS)<br>University of Guelph<br><div><br></div>519‐824‐4120 Ext 56354<br>lelio@uoguelph.ca<br>www.uoguelph.ca/ccs<br>Room 037, Animal Science and Nutrition Building<br>Guelph, Ontario, N1G 2W1<span></span><br></div><div><br></div><hr id="ecxzwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" data-mce-style="color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From: </b>"Ryan Huff" <ryanhuff@outlook.com><br><b>To: </b>lelio@uoguelph.ca, cisco-voip@puck.nether.net<br><b>Sent: </b>Tuesday, July 21, 2015 1:07:47 PM<br><b>Subject: </b>Re: [cisco-voip] CUCM IM&P and postgress database "instances"<br><div><br></div><p dir="ltr">Lelio,</p><p dir="ltr">Yes you need an external instance of postgresql. I find that Ubuntu works best.</p><p dir="ltr">Thanks,</p><p dir="ltr">Ryan</p><br><div><br></div>-------- Original Message --------<br>From: Lelio Fulgenzi <lelio@uoguelph.ca><br>Sent: Tuesday, July 21, 2015 12:37 PM<br>To: cisco-voip@puck.nether.net<br>Subject: [cisco-voip] CUCM IM&P and postgress database "instances"<br><div><br></div><div style="font-family:Verdana;font-size:10pt;color:#000000;" data-mce-style="font-family: Verdana; font-size: 10pt; color: #000000;"><div><br></div><div>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.<br></div><div><br></div><div><a href="http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/srnd/9x/uc9x/presence.html" target="_blank" data-mce-href="http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/srnd/9x/uc9x/presence.html">http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/srnd/9x/uc9x/presence.html</a><br></div><div><br></div><div>In particular:<br></div><div><br></div><div><a href="http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/srnd/9x/uc9x/presence.html#wp1133638" target="_blank" data-mce-href="http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/srnd/9x/uc9x/presence.html#wp1133638">http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/srnd/9x/uc9x/presence.html#wp1133638</a><br></div><div><br></div><div>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?<br></div><div><br></div><div><br></div><div><br></div><div><span></span>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst, Network Infrastructure<br>Computing and Communications Services (CCS)<br>University of Guelph<br><div><br></div>519‐824‐4120 Ext 56354<br>lelio@uoguelph.ca<br>www.uoguelph.ca/ccs<br>Room 037, Animal Science and Nutrition Building<br>Guelph, Ontario, N1G 2W1<span></span><br></div><div><br></div></div></div><div><br></div></div></div></div></div><div><br></div></div></div></div></div><div><br></div></div></body></html>