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

postgres replication only some datas

From: Matthias Blohm <m(dot)blohm(at)digisec(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres replication only some datas
Date: 2004-08-23 11:50:47
Message-ID: 1093261970.890297@nntp (view raw or flat)
Thread:
Lists: 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 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.

Anybody how could help?

Greetings
Matthias


Responses

pgsql-general by date

Next:From: SecrétariatDate: 2004-08-23 13:03:33
Subject: Connection to a PG 8.0 Beta 1 win32 server
Previous:From: Csaba NagyDate: 2004-08-23 11:31:28
Subject: Re: view triggers/procedures

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