Thread: postgres replication only some datas

postgres replication only some datas

From
Matthias Blohm
Date:
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
wedo 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?

Greetings
Matthias


Re: postgres replication only some datas

From
Jan Wieck
Date:
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 #