Re: Need help pg backup & recovery
| От | Lætitia Avrot |
|---|---|
| Тема | Re: Need help pg backup & recovery |
| Дата | |
| Msg-id | CAB_COdhFtkvJ5PrfeQjza5YDMOGWBCDYrPW1JEAJ_bcC8oEYGw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Need help pg backup & recovery ("Srikar Vankadaru" <srikar@opsveda.com>) |
| Ответы |
RE: Need help pg backup & recovery
|
| Список | pgsql-novice |
Now I setup up full backup using pgdump and WAL logs (for PITR).
During the recovery will the pgdump recovers /pgtablespaces and /pgindexes as well ?
I want to understand how to take backup in this scenario so I should be able to do a full PITR.
Hi,
pg_dump is a logical backup. You can't apply WAL on top of it. You can't PITR out of a logical dump. To do that, you need a physical backup (look at pg_basebackup, pg_barman, pg_backrest or pg_probackup) to be able to apply WALs. You'll find more informations in [that](https://www.postgresql.org/docs/current/backup.html) documentation page
Have a nice day,
Lætitia
pg_dump is a logical backup. You can't apply WAL on top of it. You can't PITR out of a logical dump. To do that, you need a physical backup (look at pg_basebackup, pg_barman, pg_backrest or pg_probackup) to be able to apply WALs. You'll find more informations in [that](https://www.postgresql.org/docs/current/backup.html) documentation page
Have a nice day,
Lætitia
Paper doesn’t grow on trees. Please print responsibly.
В списке pgsql-novice по дате отправления: