postgres replication only some datas - Mailing list pgsql-general

From Matthias Blohm
Subject postgres replication only some datas
Date
Msg-id 1093261970.890297@nntp
Whole thread Raw
Responses Re: postgres replication only some datas  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Oleg
Date:
Subject: Re: problem with postgresql-dump while upgrading to 7.4
Next
From: Secrétariat
Date:
Subject: Re: No connection to a PG 8.0 Beta 1 win32 server