PostGreSQL Replication

From: Gabriele <gabriele_palma(at)tin(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: PostGreSQL Replication
Date: 2007-07-07 12:16:56
Message-ID: 1183810616.126249.189310@d55g2000hsg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas 'ads' Scherbaum 2007-07-07 12:51:43 Re: Problem with autovacuum and pg_autovacuum
Previous Message Carmen Martinez 2007-07-07 12:16:24 catalog location