[ic] Postgresql

Sat Feb 23 10:47:00 2002

On Sat, Feb 23, 2002 at 01:09:22PM +1100, George Osvald wrote:
> Would it be a good idea to connect interchange residing on my ISP's server  
> with my postgresql database on my local machine via ADSL?
> I wander how reliable that connection would be.
> If I simply rsync the two databases every 10 minutes or so I might have a 
> problem with primary key duplication.

Depends on what you are doing.  For everything, it is almost
certainly a bad idea.  Youd be better off running the store on
the ADSL line.

OTOH, maybe you only place the final orders onto the local
machine and periodically check inventory, etc....  That can 
work better or worse, depending on reliability of
routing (and infrastructure - there is a reason ISPs exist)

We just finished bringing up a store with AS400 back end
100s of miles + firewalls + proxies away.  The connection
is slow, but it's only real time for placing orders (8sec),
checking inventory in checkout sequence (2sec), and authorizing
credit cards (20-40 seconds).  Everything else talks to a
local database.  **That** database gets updated from the
AS400 in the background.

> 
> 
> -- 
> 
> Regards,
> 
> George Osvald
> OK STUDIO
> Ph: (02) 9792 8501
> Fax: (02) 9792 8502
> Mob: 0411 766 792
> mail@okstudio.com.au
> http://www.okstudio.com.au
> PO BOX 552
> PADSTOW
> NSW 2211
> AUSTRALIA
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users

-- 

Christopher F. Miller, Publisher                               cfm@maine.com
MaineStreet Communications, Inc           208 Portland Road, Gray, ME  04039
1.207.657.5078                                         http://www.maine.com/
Content/site management, online commerce, internet integration, Debian linux