Hi all,

I'm faced to a big problem!!

I have to do this for a customer:

create a database on my server; this database will be queried and updated
through the web --- this is easy

H!ave the same databse on my customer server. This databse will be queried
and updated by the customer . -esay too

The 2 databases have to be synchronized both ways ! Huh How can I do
that???

Can you give me some pointers... I'd love to do it with postgresql
instead of going to Oracle just because they can replicate bases...

TIA

-- 
Olivier PRENANT         	Tel:	+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)


Wed, 7 Jun 2000 16:38:44 +0200 (MET DST)
Olivier PRENANT <ohp@pyrenet.fr>
Big projet, please help
Olivier PRENANT wrote:
> 
> Hi all,
> 
> I'm faced to a big problem!!
> 
> I have to do this for a customer:
> 
> create a database on my server; this database will be queried and updated
> through the web --- this is easy
> 
> H!ave the same databse on my customer server. This databse will be queried
> and updated by the customer . -esay too
> 
> The 2 databases have to be synchronized both ways ! Huh How can I do
> that???

Just a thought:

have two sets of tables client_xxx and web_xxx and allow updates on
'local' 
tables only.

for queries create views like 
(select * from client_xxx union select * from web_xxx)

if client wants to modyify web tables have her do it over web.

to synchronize just copy over the tables

> Can you give me some pointers... I'd love to do it with postgresql
> instead of going to Oracle just because they can replicate bases...

A general info on _file_system_ replication can be found at

http://www.coda.cs.cmu.edu/

it probably won't help you much with db replication



A distributed db based on early postgreSQL versions is at 

http://s2k-ftp.cs.berkeley.edu:8000/mariposa/



---------
Hannu

Thu, 08 Jun 2000 10:09:58 +0300
Hannu Krosing <hannu@tm.ee>
Re: Big projet, please help