RE: Need help pg backup & recovery

Thanks Lætitia,

When I setup the physical backup with one of the tools you specified, will that recover the /pgindexes & /pgtablespaces ?

Thanks,

Srikar

From: Lætitia Avrot [mailto:laetitia(dot)avrot(at)gmail(dot)com]
Sent: Monday, June 10, 2019 15:57
To: Srikar Vankadaru <srikar(at)opsveda(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: 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.