RE: [ic] Tables

[patrick.bennett@ccgenesis.com]

I think what he meant is that you can give an option to makecat to
put all the data from the foundation store into an SQL database
such as Postgres.

During the makecat process, it asks you if you want to use an SQL
database.  You answer 1 to that.  Then it will ask you if you use
mySQL - just hit enter.  Then enter 1 when it asks if you want to
use PostreSQL.

Also if you want your database to be on another server, you can put
in a ;host=mydatabaseserver at the end of the DBI connect string,
where mydatabaseserver is some machine other than your IC machine.

When you start interchange for the first time after doing the
makecat, it checks if the tables it needs are in the PostgreSQL
database.  If they aren't it creates them and populates them.  The
files it uses to do so are in <catroot>/dbconf/pgsql and have names
like products.pgsql.  Here is a list of the files:

-rw-r--r--   1 interch  htdocs       114 Sep  7 14:10 2ndDayAir.dbm
-rw-r--r--   1 interch  htdocs       114 Sep  7 14:10 Ground.dbm
-rw-r--r--   1 interch  htdocs       114 Sep  7 14:10 NextDayAir.dbm
-rw-r--r--   1 interch  htdocs        58 Sep  7 14:10 access.dbm
-rw-r--r--   1 interch  htdocs       291 Sep  7 14:10 affiliate.pgsql
-rw-r--r--   1 interch  htdocs       471 Sep  7 14:10 area.pgsql
-rw-r--r--   1 interch  htdocs       461 Sep  7 14:10 cat.pgsql
-rw-r--r--   1 interch  htdocs        81 Sep  7 14:10 component.dbm
-rw-r--r--   1 interch  htdocs       644 Sep  7 14:10 country.pgsql
-rw-r--r--   1 interch  htdocs       856 Sep  7 14:10 gift_certs.pgsql
-rw-r--r--   1 interch  htdocs       465 Sep  7 14:10 inventory.pgsql
-rw-r--r--   1 interch  htdocs        58 Sep  7 14:10 locale.dbm
-rw-r--r--   1 interch  htdocs       654 Sep  7 14:10 merchandising.pgsql
-rw-r--r--   1 interch  htdocs        58 Sep  7 14:10 mv_metadata.dbm
-rw-r--r--   1 interch  htdocs      1702 Sep  7 14:10 options.pgsql
-rw-r--r--   1 interch  htdocs       889 Sep  7 14:10 order_returns.pgsql
-rw-r--r--   1 interch  htdocs      1380 Sep  7 14:10 orderline.pgsql
-rw-r--r--   1 interch  htdocs       501 Sep  7 14:10 pgsql.cfg
-rw-r--r--   1 interch  htdocs       900 Sep  7 14:10 pricing.pgsql
-rw-r--r--   1 interch  htdocs      1210 Sep  7 14:10 products.pgsql
-rw-r--r--   1 interch  htdocs       774 Sep  7 14:10 state.pgsql
-rw-r--r--   1 interch  htdocs      3256 Sep  7 14:10 transactions.pgsql
-rw-r--r--   1 interch  htdocs      3016 Sep  7 14:10 userdb.pgsql
-rw-r--r--   1 interch  htdocs        58 Sep  7 14:10 variable.dbm

Note that even if you do this, some things are still kept on the
IC server, as mentioned in another post from me today.  I believe the
ones listed with a .dbm extension do not get put in the SQL database
(obviously they don't have a .pgsql file so IC won't know how to put
them in the database).

Patrick

-----Original Message-----
From: Fred Pope [mailto:fred@satcomresources.com]
Sent: Wednesday, October 17, 2001 3:56 PM
To: interchange-users@interchange.redhat.com
Subject: RE: [ic] Tables


> Have you tried makecat? 

Iam trying to find table structures being used by interchange so that i
can move them to my database Postgresql.

_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users