Pg_logical without subscription. Can we log the operations ?

Поиск
Список
Период
Сортировка
От Dilshan
Тема Pg_logical without subscription. Can we log the operations ?
Дата
Msg-id CAK_cvDfrR1=5Gf5qxnxAg7zw7Wt_AexowCjx=mzDzsghuhwUMA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Pg_logical without subscription. Can we log the operations ?  (Steve Atkins <steve@blighty.com>)
Список pgsql-general
Hi Team,
 I am working on a requirement, where I need to log each and every operation on the master db. So I was thinking if I could do with pg_logical by setting my master db as publisher and setting a new db as subscriber and dropping the subscription there after. I am wondering, how to get the operations that a subscription would receive just into logs. Could you guide me on that? Otherwise is there a possibility to receive all the operation without dropping subscription and logging the details and deleting the subscription tables to save space. I am planning to have logs rotated and purging logs every month. Could you please guide me about the possibility of this approach?
Thanks in advance,
Dilshan

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: FTS trigger works 1 at a time, but fails with bulk insert script
Следующее
От: Rob Sargent
Дата:
Сообщение: COPY threads