| 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 07:44:55 |
| Message-ID: | 0A785E2B61EB46419AF185662F54938C@dell2 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi!
>> 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 ?
>I think that it would be good if you spend some time reading the
>documentation on this stuff, particularly the part about restrictions,
>to understand the use cases where that can become useful:
>https://www.postgresql.org/docs/devel/logical-replication.html
Thank you.
I read it and havent found any reference to PITR recovery.
For PITR recovery it should probably save sql statements to files and allow to specify recovery target time
for applying sql statements to base backup.
Is PITR recovery supported only using binary WAL files ?
Other limits can probably be solved.
Andrus.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anders Bøgh Bruun | 2020-05-25 08:19:06 | Re: Logical replication troubles |
| Previous Message | Laurenz Albe | 2020-05-25 06:47:59 | Re: Request to help on Query improvement suggestion. |