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 le...@uoguelph.ca www.uoguelph.ca/ccs Room 037, Animal Science and Nutrition Building Guelph, Ontario, N1G 2W1 ----- Original Message ----- From: "Ryan Huff" <ryanh...@outlook.com> To: "Lelio Fulgenzi" <le...@uoguelph.ca> Cc: cisco-voip@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: le...@uoguelph.ca To: ryanh...@outlook.com CC: cisco-voip@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 le...@uoguelph.ca www.uoguelph.ca/ccs Room 037, Animal Science and Nutrition Building Guelph, Ontario, N1G 2W1 From: "Ryan Huff" <ryanh...@outlook.com> To: "Lelio Fulgenzi" <le...@uoguelph.ca> Cc: cisco-voip@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: le...@uoguelph.ca To: ryanh...@outlook.com CC: cisco-voip@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 le...@uoguelph.ca www.uoguelph.ca/ccs Room 037, Animal Science and Nutrition Building Guelph, Ontario, N1G 2W1 From: "Ryan Huff" <ryanh...@outlook.com> To: le...@uoguelph.ca, cisco-voip@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 <le...@uoguelph.ca> Sent: Tuesday, July 21, 2015 12:37 PM To: cisco-voip@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 le...@uoguelph.ca www.uoguelph.ca/ccs Room 037, Animal Science and Nutrition Building Guelph, Ontario, N1G 2W1
_______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
