PostGreSQL Replication - Mailing list pgsql-general

From Gabriele
Subject PostGreSQL Replication
Date
Msg-id 1183810616.126249.189310@d55g2000hsg.googlegroups.com
Whole thread Raw
Responses Re: PostGreSQL Replication
Re: PostGreSQL Replication
Re: PostGreSQL Replication
List pgsql-general
I know this is a delicate topic which must be approached cautiously.

Let's have a server which feed data to multiple slaves, usually using
direct online connections. Now, we may want to allow those client to
sync the data to a local replica, work offline and then resync the
data back to the server. Which is the easiest way to approach this
problem?

Can you address me to tools, documentation, tech reference or other
resource on this topic? I've found people talking about Slony-I, what
can you tell me on this tool? Are there other tools?

Moreover, additionally to the previous question, let's take the case i
do have multiple indipendent and separate server and then i want to
upload the information of these server (actually not everything but a
subset of the data) to another server (here we have a unidirectional
comm, as opposed to previous bidirectional comm and we have asymmetric
structure as opposed to the previous exact replica), what are the
tools, documentation, best practices or other resources to approach
this problem?

Thank you!


pgsql-general by date:

Previous
From: Carmen Martinez
Date:
Subject: catalog location
Next
From: henryJack
Date:
Subject: What secret resipy of PostgreSQL (insert more faster than delete)?