Olap and tenant tables not created after doing "ant run-install-extseed"

[cmunozjuste]

Hello,

We are starting with OfBiz and we would like to use Postgres as the database. I configured the localpostnew datasource at the entityengine.xml file, and I changed in the default delegator this:

<group-map group-name="org.ofbiz" datasource-name="localpostnew"/>
<group-map group-name="org.ofbiz.olap" datasource-name="localpostnew"/>
<group-map group-name="org.ofbiz.tenant" datasource-name="localpostnew"/>

After running "ant run-install-extseed", everything is ok, except for the fact that the olap and tenant tables are missing on the new Postgres database.
I have noticed that in the default configuration for Derby, three databases are used, one for tenant tables, one for olap tables and one for the rest.

Is having three databases a must in Postgres, too? Our intention was to use one database for everything.

Thanks a lot,

Carlos

[BJ Freeman]

if you follow the entityengine layout you will see that each has a
different db.
you need three seperate db in postgres
so copy the localpostnew
to localpostolap
localposttenant
each being a seperate postgres db.


cmunozjuste sent the following on 9/24/2010 5:13 AM:

>
> Hello,
>
> We are starting with OfBiz and we would like to use Postgres as the
> database. I configured the localpostnew datasource at the entityengine.xml
> file, and I changed in the default delegator this:
>
> <group-map group-name="org.ofbiz" datasource-name="localpostnew"/>
> <group-map group-name="org.ofbiz.olap" datasource-name="localpostnew"/>
> <group-map group-name="org.ofbiz.tenant" datasource-name="localpostnew"/>
>
> After running "ant run-install-extseed", everything is ok, except for the
> fact that the olap and tenant tables are missing on the new Postgres
> database.
> I have noticed that in the default configuration for Derby, three databases
> are used, one for tenant tables, one for olap tables and one for the rest.
>
> Is having three databases a must in Postgres, too? Our intention was to use
> one database for everything.
>
> Thanks a lot,
>
> Carlos

[Mike Z]

I used this as a reference.  Worked great;

http://www.toivari.com/devblog/2010/06/16/configure-ofbiz-to-use-postgresql-server/


On Fri, Sep 24, 2010 at 9:07 AM, BJ Freeman <[hidden email]> wrote:

> if you follow the entityengine layout you will see that each has a different
> db.
> you need three seperate db in postgres
> so copy the localpostnew
> to localpostolap
> localposttenant
> each being a seperate postgres db.
>
>
> cmunozjuste sent the following on 9/24/2010 5:13 AM:
>>
>> Hello,
>>
>> We are starting with OfBiz and we would like to use Postgres as the
>> database. I configured the localpostnew datasource at the entityengine.xml
>> file, and I changed in the default delegator this:
>>
>> <group-map group-name="org.ofbiz" datasource-name="localpostnew"/>
>> <group-map group-name="org.ofbiz.olap" datasource-name="localpostnew"/>
>> <group-map group-name="org.ofbiz.tenant" datasource-name="localpostnew"/>
>>
>> After running "ant run-install-extseed", everything is ok, except for the
>> fact that the olap and tenant tables are missing on the new Postgres
>> database.
>> I have noticed that in the default configuration for Derby, three
>> databases
>> are used, one for tenant tables, one for olap tables and one for the rest.
>>
>> Is having three databases a must in Postgres, too? Our intention was to
>> use
>> one database for everything.
>>
>> Thanks a lot,
>>
>> Carlos
>
>

[cmunozjuste]

Thank you both for your help.

So I reckon that three databases are needed. I was just trying to make it work with one database in order to save resources, but if it cannot be done, then I will set up three.

Thanks again.

Carlos