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.
Regards,
Seenu.