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  (Abdul Qoyyuum <aqoyyuum@cardaccess.com.au>)
Re: Setting up a server with previous day data  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Setting up a server with previous day data  (Stephen Frost <sfrost@snowman.net>)
Re: Setting up a server with previous day data  (Ron <ronljohnsonjr@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Proposed Translations of Updated Code of Conduct Policy
Следующее
От: Ganesh Korde
Дата:
Сообщение: Re: pg_receivewal/xlog to ship wal to cloud