On 8/23/2004 7:50 AM, Matthias Blohm wrote:
> 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.
> Anybody how could help?
> ---------------------------(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 #
In response to
pgsql-general by date
|Next:||From: Christopher Browne||Date: 2004-08-25 00:56:01|
|Subject: Re: Unsupported 3rd-party solutions (Was: Few questions|
|Previous:||From: Matthew Hixson||Date: 2004-08-25 00:06:03|
|Subject: Re: no JDBC driver source with 7.4.5?|