Someone actually asked this exact question and got a reply just
yesterday. Take a look in the archives...

On Thu, Nov 03, 2005 at 05:11:14PM +0000, Carlos Benkendorf wrote:
> Hello,
>  
> Currently our company has a lot of small stores distributed around the country and in the actual database configuration we have a central database and all the small stores accessing it remotely.
>  
> All primary key tables were designed with a column identifying the store that it belongs. In other words, the store that can update the line, other stores can read it but the system was designed in such a way that other stores can not update information that do not belong to them.
>  
> The performance is not good because the line speed that connects the store to the central database sometimes is overloaded. We?re thinking to replicate the central database to each store. The store would be able to read all the information from the local database but should only update lines that belong to that store. 
>  
> When a store needs read information about other stores, it is not necessary to be updated, it can be a yesterday snapshot.
>  
> During the night all the local store databases will be consolidated in only one database and replicated again to the stores. In the morning, when the store opens, the local database has an updated and consolidated data.
> I would appreciate suggestions about how the best way to implement such soluction.
>  
> Slony-1? SQL scripts?
>  
> Thanks in advance!
> 
> Benkendorf
> 
> 
> 		
> ---------------------------------
>  Yahoo! Acesso Gr?tis: Internet r?pida e gr?tis.
> Instale o discador agora!

> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
Jim C. Nasby, Database Architect                decibel at decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"