[HACKERS] Re:Sync Data

[Paulo Angelo]

Helo,

On Thu, 31 May 2001 [EMAIL PROTECTED] wrote:

Questions:

   1) What is the connection between small and big Dbs? (LAN/WAN)


   2) Is there a consistent connection between systems?

   3) Are you looking for synchronous (before the insert commits)
  or asynchronous (after the insert commits)?

   4) Is there any chance for insert/update conflicts
  (insert/update same record in same table)
   on the big DB?


- problem :  I have four small DBs that would sync data thru
  Internet during the night (128 kbs/s), there is no
  conflicts and there is nobody inserting data in
  small DBs while its syncing.

I think it answers all the questions.


Thanks.



 Darren Johnson
 Source Software Institute




---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

[HACKERS] Sync Data

[Paulo Angelo]

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 [EMAIL PROTECTED])