Setting up a server with previous day data
От | Srinivasa T N |
---|---|
Тема | Setting up a server with previous day data |
Дата | |
Msg-id | CAFruNddwg1QHJD75rH_swG_+TVMHiCxLU8pOouxxJH=mz-YUHw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Setting up a server with previous day data
Re: Setting up a server with previous day data Re: Setting up a server with previous day data Re: Setting up a server with previous day data |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: