| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Secrétariat | 2004-08-23 13:03:33 | Connection to a PG 8.0 Beta 1 win32 server |
| Previous Message | Csaba Nagy | 2004-08-23 11:31:28 | Re: view triggers/procedures |