Re: 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