| From: | "Andrus" <kobruleht2(at)hot(dot)ee> |
|---|---|
| To: | "Michael Paquier" <michael(at)paquier(dot)xyz> |
| Cc: | "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:02:49 |
| Message-ID: | 672D501EF09642EB82A7226828644214@dell2 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
How to set logical replication for all user databases in cluster so that when new database is added or new tables are added to
database they will start replicate automatically ?
Will it require more powerful backup server to replay main server sql stream from different databases.
Andrus.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2020-05-25 06:30:51 | Re: Query returns no rows in pg_basebackup cluster |
| Previous Message | Andrus | 2020-05-25 05:47:32 | Re: Query returns no rows in pg_basebackup cluster |