Postgres Pro
Downloads
Home   >   mailing lists

Need help pg backup & recovery - Mailing list pgsql-novice

From Srikar Vankadaru
Subject Need help pg backup & recovery
Date
Msg-id 004101d51f75$0ba07f00$22e17d00$@opsveda.com
Whole thread Raw
Responses Re: Need help pg backup & recovery  (Lætitia Avrot <laetitia.avrot@gmail.com>)
List pgsql-novice
Tree view

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

pgsql-novice by date:

Previous
From: Martin Lund Askøe
Date:
Subject: Re: Transaction locks on first insert into partitioned table partition
Next
From: Lætitia Avrot
Date:
Subject: Re: Need help pg backup & recovery