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

Thu Jul 23 10:28:48 EDT 2015

If you do active / standby presence you can't have it point to the same
external chat db. As a result you'll need to do some kind of load balancing
/ application level dns (gtm)
On 22 Jul 2015 7:58 am, "Ryan Huff" <ryanhuff at outlook.com> wrote:

> 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
>
> ------------------------------
> *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
>
>
>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20150724/74a152dc/attachment.html>