After a long battle with technology, Matthias Blohm <[EMAIL PROTECTED]>, 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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly