I'm trying to centralize data in a unique db, like it:



	---		---		---
       |DB |	       |DB |	       |DB |
	---		---		---
          \              |            /
            \            |         /
	      \	  -----------    /
	   	|	     |/
                | "Big" DB   |
                |    with    |
                | centralized|
                | data       |
                 ------------

Information:

	1) The "small" DBs sync data with the "big" DB.
	2) We have 4 linux box above.
	3) The big DB has a copy of all data. Just the "small"
	    DBs inserts data in the "big" one.


The question:  Does Postgres do it?

[]'s


Paulo Angelo


Wed, 30 May 2001 18:07:26 -0300 (EST)
Paulo Angelo <pa@bsb.conectiva.com.br>
Sync Data
Hi Paulo,

It is unclear exactly what you want PostgreSQL to do but it seems to me
that if you want to Sync data into a central database at some point or
other during the day, you should design your application to take care of
it, not rely on PostgreSQL to do anything special.

That is, simply move all the data from the smaller databases to the
central database with a scheduled processing system. 

Gavin

On Wed, 30 May 2001, Paulo Angelo wrote:

> I'm trying to centralize data in a unique db, like it:
> 
> 
> 
> 	---		---		---
>        |DB |	       |DB |	       |DB |
> 	---		---		---
>           \              |            /
>             \            |         /
> 	      \	  -----------    /
> 	   	|	     |/
>                 | "Big" DB   |
>                 |    with    |
>                 | centralized|
>                 | data       |
>                  ------------
> 
> Information:
> 
> 	1) The "small" DBs sync data with the "big" DB.
> 	2) We have 4 linux box above.
> 	3) The big DB has a copy of all data. Just the "small"
> 	    DBs inserts data in the "big" one.
> 
> 
> The question:  Does Postgres do it?
> 
> []'s
> 
> 
> Paulo Angelo
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 


Fri, 1 Jun 2001 17:54:57 +1000 (EST)
Gavin Sherry <swm@linuxworld.com.au>
Re: Sync Data