You could instead set up High Availability and use your secondary as actual streamed and backed up database. https://www.postgresql.org/docs/current/high-availability.html
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 <seen...@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. > > Regards, > Seenu. > -- Abdul Qoyyuum Bin Haji Abdul Kadir HP No: +673 720 8043
