postgres replication only some datas

[Matthias Blohm]

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?

Greetings
Matthias

[Christopher Browne]

Re: postgres replication only some datas

After a long battle with technology, Matthias Blohm <m.blohm@digise c.de>, an earthling, wrote:[color=blue]
> 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?[/color]

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

- Table "public_stu ff" with the replicable data;
- Table "private_st uff" 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(e lements)".
--
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.

[Jan Wieck]

Re: postgres replication only some datas

On 8/23/2004 7:50 AM, Matthias Blohm wrote:
[color=blue]
> 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.[/color]

Setup another set of tables that you actually replicate and have them
maintained by triggers that contain the logic what to have online.


Jan
[color=blue]
>
> Anybody how could help?
>
> Greetings
> Matthias
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend[/color]


--
#============== =============== =============== =============== ===========#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#============== =============== =============== ====== JanWieck@Yahoo. com #

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match