Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Installing iHub with existing Postgres server
tokorhon
<p>Hello!</p>
<p> </p>
<p>I'm trying to install iHub on a Windows7 (64-bit) machine, but the installation fails probably because there is already a running Postgres server instance on this machine.</p>
<p> </p>
<p>setupiHub.log says:</p>
<pre class="_prettyXprint">
setupootbpg:
[echo] Starting setup OOTB PostgreSQL database.
init.ootbpg:
[echo] Initializing PostgreSQL for Actuate.
initpostgresql:
setenv:
format.system.name:
[exec] The files belonging to this database system will be owned by user "myusername".
[exec] This user must also own the server process.
[exec]
[exec] The database cluster will be initialized with locale "English_United States.1252".
[exec] The default text search configuration will be set to "english".
[exec]
[exec] creating directory C:/Actuate3/modules/BIRTiHub/iHub/data/postgresql/data ... initdb: could not create directory "C:/Actuate3/modules/BIRTiHub/iHub/data/postgresql": Permission denied
[exec] Result: 1
BUILD FAILED</pre>
<p>How can I set iHub to use the already installed Postgres?</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
Find more posts tagged with
Comments
Clement Wong
<p>The iHub can co-exist with a previously installed PostgreSQL server. The one that comes with the iHub is a low profile one used to manage the meta-data of the iHub volume.</p>
<p> </p>
<p>Thank you for including the setup log. Regarding the error message "<span>creating directory C</span><span>:</span><span>/Actuate3/</span><span>modules</span><span>/</span><span>BIRTiHub</span><span>/</span><span>iHub</span><span>/</span><span>data</span><span>/</span><span>postgresql</span><span>/</span><span>data </span><span>...</span><span> initdb</span><span>:</span><span> could </span><span>not</span><span> create directory </span><span>"C:/Actuate3/modules/BIRTiHub/iHub/data/postgresql"</span><span>:</span><span> </span><span>Permission</span><span> denied", what Windows user are you installing the iHub? Is the user an administrator, or is part of the Administrator group? A workaround would be to create an C:\Actuate3 folder, and explicitly assign read/write access to the user you are installing and have it propagate recursively, before you run the install .exe.</span></p>
<p> </p>
<p>Should you require additional assistance, we can have a local Support Engineer contact you. Please PM me with your contact information and which country you reside in.</p>
tokorhon
<p>Thank you for your answer! I was able to setup iHub by creating directory "<span>C:/Actuate3/modules/BIRTiHub/iHub/data/postgresql" manually and setting enough permissions for it.</span></p>
<p> </p>
<p><span>Does iHub always use internal Postgres or can I use a company's Postgres server as metadata database?</span></p>
Clement Wong
<p>Yes, iHub 3.1.1 supports the following for Database Software for iHub Server Encyclopedia @ <a data-ipb='nomediaparse' href='
http://developer.actuate.com/resources/supported-products/ihub/birt-ihub3-1-1'>http://developer.actuate.com/resources/supported-products/ihub/birt-ihub3-1-1</a></p>
;
<pre class="_prettyXprint _lang-nocode">
Database Servers Server Versions
Oracle 11g R1 & R2,
12c R1: 12.1.0.2.0 (Patchset as of July 2014)
PostgreSQL Database 9.2 (provided with our products)
</pre>