| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Andrus <kobruleht2(at)hot(dot)ee> |
| Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Query returns no rows in pg_basebackup cluster |
| Date: | 2020-05-25 06:42:10 |
| Message-ID: | CAKFQuwb4ZCAtVFB2BhHyOfi+tOtsynmAs63t-tEoSjk4HWLAjA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sunday, May 24, 2020, Andrus <kobruleht2(at)hot(dot)ee> wrote:
> Hi!
>
> Backup in created in Windows from Linux server using pg_receivewal and
>>> pg_basebackup .
>>> Can this backup used for PITR in Linux ?
>>>
>> No. Physical copies need to be based on the same platform. If you
>> wish to replicate a cluster without any platform, architecture or even
>> not-too-many major version constraints, there is also logical
>> replication available since v10.
>>
>
> Will logical replication also allow two modes:
> 1. PITR recovery can used if needed
> 2. Hot standby: User databases in both clusters contain same data.
>
>
Why are you spending so much effort on this Window/Linux hybrid setup? Get
yourself another Linux server and setup physical replication. It sounds
like it will exactly meet your requirements and you will waste more time
and money working out alternatives than the server would cost.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2020-05-25 06:47:59 | Re: Request to help on Query improvement suggestion. |
| Previous Message | Michael Paquier | 2020-05-25 06:30:51 | Re: Query returns no rows in pg_basebackup cluster |