Re: Need help pg backup & recovery

>
>
> 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

-- 
*Paper doesn’t grow on trees. Please print responsibly.*