On 7/19/22 00:22, Srinivasa T N 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.
Use Postgres FDW:
https://www.postgresql.org/docs/current/postgres-fdw.html
to set up a link between the two?
Regards,
Seenu.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
