<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Enable citext for external Horizon DB in Workspace ONE Discussions</title>
    <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764267#M5025</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I am new to PostGres DB installation and was wondering which version of PostGres DB OVF should I use for Horizon Workspace. I found &lt;STRONG&gt;VMware-vFabric-Postgres-appliance-9.2.2.0-997837_OVF10.ova &lt;/STRONG&gt;when searching for PostGres under All Downloads. However when I seached for vFabric PostGres I also fond an appliance :: vFabric Postgres Appliance - Release Date 2012-10-16, ersion: V9.1.6.0 [Binary (.ova)]. Was wondering which one would be a better option to use.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Subho&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 01 Apr 2013 10:47:19 GMT</pubDate>
    <dc:creator>SubhoMUS</dc:creator>
    <dc:date>2013-04-01T10:47:19Z</dc:date>
    <item>
      <title>Enable citext for external Horizon DB</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764263#M5021</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Does anyone know how to setup the Postgres DB that's required for production Horizon Workspace?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So far, I've created the db, added a user and created a schema called saas that it appears to be asking for. It's now asking for citext to be enabled on the db but I'm not sure how to do it.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 21 Mar 2013 13:25:20 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764263#M5021</guid>
      <dc:creator>treverjackson</dc:creator>
      <dc:date>2013-03-21T13:25:20Z</dc:date>
    </item>
    <item>
      <title>Re: Enable citext for external Horizon DB</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764264#M5022</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;We are in the final stages of publishing a document explaining how to setup an external database. Please ping me privately for more info.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 21 Mar 2013 14:25:52 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764264#M5022</guid>
      <dc:creator>pbjork</dc:creator>
      <dc:date>2013-03-21T14:25:52Z</dc:date>
    </item>
    <item>
      <title>Re: Enable citext for external Horizon DB</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764265#M5023</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello you,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;We have done this ourselves by figuring things out by our own. There is very little or no documentation all on this issue. From my point of view Workspace 1.0 is a joke in so many ways.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I am not a database guy, but here it goes: You have created a new empty DB and workspace is complaining about the citext extension is missing.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If you are running PGAdmin, under your new DB -&amp;gt; Right click Extensions and create new. Name it "citext"&lt;/P&gt;&lt;P&gt;Under defentitions select schema; &lt;STRONG&gt;public&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;and version 1.0&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Simple as that. It has worked for us. Unfortunately we have run in to several other issues along the way.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;GLHF&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 25 Mar 2013 08:03:22 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764265#M5023</guid>
      <dc:creator>JockeJoakim</dc:creator>
      <dc:date>2013-03-25T08:03:22Z</dc:date>
    </item>
    <item>
      <title>Re: Enable citext for external Horizon DB</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764266#M5024</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN&gt;Actually, the "Configuring an External Database" topic in the Horizon Workspace documentation - &lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="https://www.vmware.com/support/pubs/horizon-workspace-pubs.html"&gt;https://www.vmware.com/support/pubs/horizon-workspace-pubs.html&lt;/A&gt;&lt;SPAN&gt; (see Intalling Installing Horizon Workspace, pages 56-58) covers most of the issues above, specifically CITEXT requirement.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;We would definitely improve Workspace documentation based on your feedback. &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 25 Mar 2013 23:25:46 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764266#M5024</guid>
      <dc:creator>kzelenko</dc:creator>
      <dc:date>2013-03-25T23:25:46Z</dc:date>
    </item>
    <item>
      <title>Re: Enable citext for external Horizon DB</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764267#M5025</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I am new to PostGres DB installation and was wondering which version of PostGres DB OVF should I use for Horizon Workspace. I found &lt;STRONG&gt;VMware-vFabric-Postgres-appliance-9.2.2.0-997837_OVF10.ova &lt;/STRONG&gt;when searching for PostGres under All Downloads. However when I seached for vFabric PostGres I also fond an appliance :: vFabric Postgres Appliance - Release Date 2012-10-16, ersion: V9.1.6.0 [Binary (.ova)]. Was wondering which one would be a better option to use.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Subho&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 01 Apr 2013 10:47:19 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764267#M5025</guid>
      <dc:creator>SubhoMUS</dc:creator>
      <dc:date>2013-04-01T10:47:19Z</dc:date>
    </item>
    <item>
      <title>Re: Enable citext for external Horizon DB</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764268#M5026</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Neither one appears to meets the CITEXT requirement at least upon deployment.&lt;/P&gt;&lt;P&gt;I am unsure if there is some way to add it.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;EDIT: See below for what I've now tested as working from scratch.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 01 Apr 2013 19:31:57 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764268#M5026</guid>
      <dc:creator>CXSANGUY</dc:creator>
      <dc:date>2013-04-01T19:31:57Z</dc:date>
    </item>
    <item>
      <title>Re: Enable citext for external Horizon DB</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764269#M5027</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;We are using the 9.2 vFabric Postgres Appliance with Horizon and it is working very well.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The CITEXT extension is simply aded to the database schema after creating the database. &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 01 Apr 2013 19:40:34 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764269#M5027</guid>
      <dc:creator>treverjackson</dc:creator>
      <dc:date>2013-04-01T19:40:34Z</dc:date>
    </item>
    <item>
      <title>Re: Enable citext for external Horizon DB</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764270#M5028</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;My concern here is more that I have to stamp my name and companies name on these installs (As a VMware View Consultant) and I prefer being certain through documentation or direct VMware confirmation that what I do is correct.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In the interim though the following steps appear to work for me:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri; MARGIN: 0in"&gt;Deploy vFabric Postgres Virtual Appliance (Specify fixed IP Address)&lt;/P&gt;&lt;P style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri; MARGIN: 0in"&gt;Manually create "horizon" user account - Using &lt;A href="https://yourip:8443/"&gt;https://x.x.x.x:8443/&lt;/A&gt;&lt;/P&gt;&lt;P style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri; MARGIN: 0in"&gt;Manually add database "horizon" for "horizon" user account&lt;/P&gt;&lt;P style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri; MARGIN: 0in"&gt;Right-Click Horizon DB-&amp;gt;Enter SQL Code-&amp;gt;CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public; [EXECUTE]&lt;/P&gt;&lt;P style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri; MARGIN: 0in"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; (You could also i suppose just add a new type under "other objects" in the GUI but the above is how i tested it from scratch)&lt;/P&gt;&lt;P style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri; MARGIN: 0in"&gt;Manually create schema "saas" (Do NOT check case sensitive) under horizon schemas&lt;/P&gt;&lt;P style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri; MARGIN: 0in"&gt;During Horizon Install or Afterwards enter JDBC URL = jdbc:postgresql://x.x.x.x/horizon?stringtype=unspecified&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri; MARGIN: 0in"&gt;SUCCESS!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 01 Apr 2013 21:58:32 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764270#M5028</guid>
      <dc:creator>CXSANGUY</dc:creator>
      <dc:date>2013-04-01T21:58:32Z</dc:date>
    </item>
    <item>
      <title>Re: Enable citext for external Horizon DB</title>
      <link>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764271#M5029</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Sorry this took some time but here is some guidance on this subject.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A class="jive-link-wiki-small" href="http://communities.vmware.com/docs/DOC-22915"&gt;http://communities.vmware.com/docs/DOC-22915&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;A small guide on using external vFabric Postgres with Horizon Workspace.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 10 Apr 2013 14:34:57 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Workspace-ONE-Discussions/Enable-citext-for-external-Horizon-DB/m-p/1764271#M5029</guid>
      <dc:creator>rsjensen</dc:creator>
      <dc:date>2013-04-10T14:34:57Z</dc:date>
    </item>
  </channel>
</rss>

