| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Srinivasa T N <seenutn(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Setting up a server with previous day data |
| Date: | 2022-07-19 15:02:24 |
| Message-ID: | 1a276620-d600-8e9e-8299-4f4bea4746ab@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastien Flaesch | 2022-07-19 15:33:52 | Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence |
| Previous Message | Adrian Klaver | 2022-07-19 15:00:43 | Re: Out Of Memory |