[ic] Postgresql

[Dan Browning]

At 10:46 AM 2/23/2002 -0500, you wrote:
>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.

In addition, PostgreSQL does have replication features now.


| Dan Browning, Sr. Tech Consultant
| Kavod Technologies, 1498 SE Tech Center Pl Ste 170
| Vancouver, WA 98683  <dan.browning@kavod.com>
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"It took me fifteen years to discover that I had no talent for writing,
but I couldn't give up because by that time I was too famous."
                 -- Robert Benchly