This way, you get up-to-date data that you can query/generate reports with.
On Tue, Jul 19, 2022 at 3:22 PM Srinivasa T N <seenutn@gmail.com> wrote:
Hi All,
I have a primary postgresql 12 server which is being continuously used for transaction processing. For reporting purposes, I want to set up a secondary server which has got previous day data. Everyday night, I want the data from primary to be shifted to secondary. I can achieve this manually using pg_basebackup on primary and pg_restore on secondary. Is there any other automated efficient way to achieve the same? Any relevant docs would be helpful.