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: (view raw, whole thread or download thread mbox)
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.


> 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-2017 The PostgreSQL Global Development Group