[ic] Updating gdbm files

Janine Ohmer janine at furfly.net
Wed Jan 26 01:21:22 UTC 2011


On Jan 25, 2011, at 3:18 PM, Peter wrote:

> On 26/01/11 08:59, Janine Ohmer wrote:
>> 1. Not all of my tables are stored in gdbm files; much of the data is
>> in Postgres, but not all. I have the following gdbm files:
>> 
>> .2ndDayAir.gdbm
>> access.gdbm
>> component.gdbm
>> Ground.gdbm
>> ichelp.gdbm
>> locale.gdbm
>> mv_metadata.gdbm
>> NextDayAir.gdbm
>> route.gdbm
>> survey.gdbm
>> variable.gdbm
>> 
>> I don't remember why I set it up this way.
> 
> It is done this way by default in the Foundation demo.
> 
>> Would I be better off
> trying to move these tables into Postgres, or are they supposed to be
> kept separate? And assuming they should stay separate, does this change
> your advice at all?
> 
> You can move them into your SQL db if you want.  Be aware that if you
> try to move the variable table into your SQL db then you create a
> chicken and egg problem as you likely have some variables defined which
> tell IC how to access the SQL DB.  You will need to move those specific
> variables out into Variable directives early in your catalog.cfg file if
> you do this.  Note that there is no requirement that you do this.  There
> is no security issue with keeping things the way they are and once you
> get those tables imported properly odds are you won't have any issues
> with them.
> 
>> FWIW, I already tried turning on Debug in interchange.cfg and
> restarting; It was my understanding that this would flush all databases
> to text files, but that doesn't seem to have happened (some of the txt
> files are very old).
>> 
>> 2. Can I paste the code snippet in on the "Test Code" administrators
> pane,
> 
> Yes

Thank you all, this worked perfectly.

janine




More information about the interchange-users mailing list