Re: Setting up a server with previous day data

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 <seenutn(at)gmail(dot)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