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

After a long battle with technology, Matthias Blohm <m(dot)blohm(at)digisec(dot)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.

On 8/23/2004 7:50 AM, Matthias Blohm 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.

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


Jan

> 
> Anybody how could help?
> 
> Greetings
> Matthias
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend


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