Re: postgres replication only some datas - Mailing list pgsql-general

From Christopher Browne
Subject Re: postgres replication only some datas
Date
Msg-id m3eklyouu2.fsf@wolfe.cbbrowne.com
Whole thread Raw
List pgsql-general
After a long battle with technology, Matthias Blohm <m.blohm@digisec.de>, an earthling, wrote:
> Hello,
> a question about a tool or a possibility how could something work.
>
> following situation:
> we have a database which is full of very sensitive information and needed that db to use our online website.
> but now we move the website to a server outside our office and needed to replicate only some datas to the online db.
> with the tool slony i found out , that some tables could be
> replicated, but in some tables are some information, which we do not
> wont to replicate.
> so we need a tool or an idea how to do that.
> I though about a dump and deleting the sensitive datas, but the
> database is about a half gig and we need the changed entries directly
> on the online db within seconds.
>
> Anybody how could help?

Is there some way you could separate out the "sensitive" material into
a separate table so that you'd have:

- Table "public_stuff" with the replicable data;
- Table "private_stuff" with the data that shouldn't be replicated;
- View "all_stuff", which unifies the data when it needs to be
  combined.

You might use a rule to decide which data goes where, or perhaps a
stored procedure "create_stuff(elements)".
--
select 'cbbrowne' || '@' || 'ntlug.org';
http://www.ntlug.org/~cbbrowne/nonrdbms.html
Perhaps the purpose of categorical algebra is to show that that which is
trivial, is trivially trivial.

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Catching server shutdown in C
Next
From: Frank van Vugt
Date:
Subject: Why does =ANY() need an extra cast when used on an array returned by a select?