Need help pg backup & recovery

"Srikar Vankadaru" <[email protected]> Mon, 10 Jun 2019 15:42:41 +0530
Newsgroups gmane.comp.db.postgresql.novice
Message-ID <[email protected]>
Hello Folks,

 

Need help in PG backup & PIT recovery. We have setup PG server with
following filesystem layout:

 

PG Revision - 11.2

Filesystem Layout:

 

Data - /pgdata

Tablespaces - /pgtablespaces

Indexes - /pgindexes

 

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.

 

Thanks,

Srikar