{"id":63501,"date":"2024-09-24T09:00:41","date_gmt":"2024-09-24T07:00:41","guid":{"rendered":"https:\/\/nolabnoparty.com\/?p=63501"},"modified":"2026-04-29T12:22:29","modified_gmt":"2026-04-29T10:22:29","slug":"configure-postgresql-database-for-horizon-8-events","status":"publish","type":"post","link":"https:\/\/nolabnoparty.com\/en\/configure-postgresql-database-for-horizon-8-events\/","title":{"rendered":"Configure PostgreSQL database for Horizon 8 events"},"content":{"rendered":"<p><img decoding=\"async\" class=\"aligncenter wp-image-63905 size-full\" title=\"configure-postgresql-database-for-horizon-8-events-01\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2024\/09\/configure-postgresql-database-for-horizon-8-events-01.jpg\" alt=\"configure-postgresql-database-for-horizon-8-events-01\" width=\"602\" height=\"202\" \/><\/p>\n<p>To store log events, Omnissa Horizon (formely known as <a href=\"https:\/\/nolabnoparty.com\/en\/vmware-horizon-8-upgrade-sequence\/\">VMware Horzon<\/a>) supports <strong>MS-SQL, Oracle and PostgreSQL<\/strong> database platforms.<\/p>\n<p>To <strong>keep costs under control<\/strong>, you can eliminate the need for a <strong>Windows license<\/strong> by using the PostgreSQL database solution on a Linux OS.<\/p>\n<p><!--more--><\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-63907 size-full\" title=\"configure-postgresql-database-for-horizon-8-events-02\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2024\/09\/configure-postgresql-database-for-horizon-8-events-02.jpg\" alt=\"configure-postgresql-database-for-horizon-8-events-02\" width=\"386\" height=\"162\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Install PostgreSQL database on Linux Ubuntu<\/h2>\n<p>In this example, the <a href=\"https:\/\/www.postgresql.org\/\" target=\"_blank\" rel=\"noopener\">PostgreSQL database<\/a>\u00a0will be installed on <strong>Linux Ubuntu OS<\/strong>.<\/p>\n<p>SSH the Ubuntu server with an account with <em>root<\/em> permissions.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-63909 size-large\" title=\"configure-postgresql-database-for-horizon-8-events-03\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2024\/09\/configure-postgresql-database-for-horizon-8-events-03-600x46.jpg\" alt=\"configure-postgresql-database-for-horizon-8-events-03\" width=\"600\" height=\"46\" \/><\/p>\n<p>Install the PostgreSQL package.<\/p>\n<p><span style=\"color: #0000ff;\"># sudo apt install postgresql<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-63911 size-large\" title=\"configure-postgresql-database-for-horizon-8-events-04\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2024\/09\/configure-postgresql-database-for-horizon-8-events-04-600x330.jpg\" alt=\"configure-postgresql-database-for-horizon-8-events-04\" width=\"600\" height=\"330\" \/><\/p>\n<p>Start the service.<\/p>\n<p><span style=\"color: #0000ff;\"># sudo systemctl restart postgresql<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-63913 size-large\" title=\"configure-postgresql-database-for-horizon-8-events-05\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2024\/09\/configure-postgresql-database-for-horizon-8-events-05-600x46.jpg\" alt=\"configure-postgresql-database-for-horizon-8-events-05\" width=\"600\" height=\"46\" \/><\/p>\n<p>This article has been written for\u00a0<a href=\"https:\/\/www.starwindsoftware.com\/blog\/\" target=\"_blank\" rel=\"noopener noreferrer\">StarWind blog<\/a>\u00a0and can be found in\u00a0<a href=\"https:\/\/www.starwindsoftware.com\/blog\/configure-postgresql-database-for-horizon-8-events\/\" target=\"_blank\" rel=\"noopener\">this page<\/a>. It covers the full procedure to\u00a0<strong>configure PostgreSQL for Horizon 8 events<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h2>Configure the database in Horizon<\/h2>\n<p>Access the Horizon console and access the <strong>Event Configuration<\/strong> section. Click <strong>Edit<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-63915 size-large\" title=\"configure-postgresql-database-for-horizon-8-events-06\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2024\/09\/configure-postgresql-database-for-horizon-8-events-06-600x476.jpg\" alt=\"configure-postgresql-database-for-horizon-8-events-06\" width=\"600\" height=\"476\" \/><\/p>\n<p>Enter the configuration settings specifying <strong>PostgreSQL<\/strong> as <strong>Database Type<\/strong>. Click <strong>OK<\/strong> to save the configuration.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-63917 size-large\" title=\"configure-postgresql-database-for-horizon-8-events-07\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2024\/09\/configure-postgresql-database-for-horizon-8-events-07-600x737.jpg\" alt=\"configure-postgresql-database-for-horizon-8-events-07\" width=\"600\" height=\"737\" \/><\/p>\n<p>The <strong>Event Database<\/strong> has been configured successfully.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-63919 size-full\" title=\"configure-postgresql-database-for-horizon-8-events-08\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2024\/09\/configure-postgresql-database-for-horizon-8-events-08.jpg\" alt=\"configure-postgresql-database-for-horizon-8-events-08\" width=\"600\" height=\"505\" \/><\/p>\n<p>Using PostgreSQL running on a Linux OS to store <a href=\"https:\/\/nolabnoparty.com\/en\/vmware-horizon-configure-smart-card-authentication\/\">Omnissa Horizon<\/a> events, allows to save money because a <strong>Windows license is no longer required<\/strong>.<\/p>\n<p>Read the\u00a0<a href=\"https:\/\/www.starwindsoftware.com\/blog\/configure-postgresql-database-for-horizon-8-events\/\" target=\"_blank\" rel=\"noopener\">full article<\/a>\u00a0on StarWind blog.<\/p>\n<p><img decoding=\"async\" title=\"signature\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/images\/firma.jpg\" alt=\"signature\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To store log events, Omnissa Horizon (formely known as VMware Horzon) supports MS-SQL, Oracle and PostgreSQL database platforms. To keep costs under control, you can eliminate the need for a Windows license by using the PostgreSQL database solution on a Linux OS.<\/p>\n","protected":false},"author":3,"featured_media":63905,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"linkedin_93tdZWzMZc_93tdZWzMZc":"","facebook_2879994398731222_17841400390232720":"","twitter_113568041_113568041":"","mastodon_115463926174894442_115463926174894442":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","footnotes":""},"categories":[1025,2905],"tags":[695,2892,1711,2466],"class_list":["post-63501","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-horizon-en","category-omnissa-en","tag-database-en","tag-events","tag-horizon","tag-postgresql-en","has_thumb"],"_links":{"self":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts\/63501","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/comments?post=63501"}],"version-history":[{"count":0,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts\/63501\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/media\/63905"}],"wp:attachment":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/media?parent=63501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/categories?post=63501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/tags?post=63501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}