Replication by schema

From: Armin Resch <armin(at)reschab(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Replication by schema
Date: 2011-02-16 19:45:37
Message-ID: AANLkTikf2SDaQKs9KWuScxXshFwu_p+0A-gXf3r0YSVO@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi there,

what options do exist to replicate from a master by schema?

What I'm really after is this scenario:

Say, I have 100 databases out in the field. All of them have the same schema
and are autonomous masters. Now, at a central location, I want to replicate
from all masters to a central slave (which would have the combined data
footprint from all masters). Now, if schema-based replication was possible,
I would configure the slave to replicate the first master's schema 'A' to
the central slave's schema 'Master01', the second master's schema 'A' to the
central slave's schema 'Master02', etc.

Making sense? Is there appetite by anyone else for something like that?
Would there be insurmountable architectural hurdles to make this a built-in
replication option?

Rgds,
-ar

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2011-02-16 20:33:18 Re: Replication by schema
Previous Message Dean Gibson (DB Administrator) 2011-02-16 18:01:47 Re: Moving the data directory