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

Lelio Fulgenzi lelio at uoguelph.ca
Tue Jul 21 14:38:19 EDT 2015


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 

----- 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: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/c1798342/attachment.html>


More information about the cisco-voip mailing list