Re: postgres replication only some datas - Mailing list pgsql-general

From Jan Wieck
Subject Re: postgres replication only some datas
Date
Msg-id 412BE0B4.2050701@Yahoo.com
Whole thread Raw
In response to postgres replication only some datas  (Matthias Blohm <m.blohm@digisec.de>)
List 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,
whichwe 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@Yahoo.com #

pgsql-general by date:

Previous
From: Matthew Hixson
Date:
Subject: Re: no JDBC driver source with 7.4.5?
Next
From: Lawrence C
Date:
Subject: Re: [ADMIN] Dump and Restore