postgres replication only some datas

Поиск
Список
Период
Сортировка
От Matthias Blohm
Тема postgres replication only some datas
Дата
Msg-id 1093261970.890297@nntp
обсуждение исходный текст
Ответы Re: postgres replication only some datas
Список 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 по дате отправления: