Skip site navigation (1) Skip section navigation (2)

Re: postgres replication only some datas

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Matthias Blohm <m(dot)blohm(at)digisec(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres replication only some datas
Date: 2004-08-25 00:43:32
Message-ID: 412BE0B4.2050701@Yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
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 #

In response to

pgsql-general by date

Next:From: Christopher BrowneDate: 2004-08-25 00:56:01
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions
Previous:From: Matthew HixsonDate: 2004-08-25 00:06:03
Subject: Re: no JDBC driver source with 7.4.5?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group