| From: | "Raman, Karthik IN BLR STS" <karthik(dot)raman(at)siemens(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Online backup of PostgreSQL data. |
| Date: | 2015-09-17 07:31:18 |
| Message-ID: | 8D15F77F211D7D4786182E1C8E679FAD349B19FE3D@INBLRK77M1MSX.in002.siemens.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi All,
I need a small clarification. We are using PostgreSQL version 9.4.1
We have a requirement to take the online backup of a running PostgreSQL system (with out stopping the database).
As per the design / architecture of PostgreSQL system, is it technically allowed to dynamically copy the "Data" folder of PostgreSQL system (with out using any replication concept).
While restoring (we are allowed to stop the database!), can we directly restore this data folder? Are there any potential problem we will come across by doing this way?
(Or) Should I use some replication concept like using pg_basebackup (?) to achieve the same. (In our case, we do not need replication as a feature to do in different PC). It is sufficient for us to take the backup in the same PC.
Any suggestions / help is highly appreciated. Thanks in advance!
With best regards,
Karthik R
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2015-09-17 07:53:33 | Re: Online backup of PostgreSQL data. |
| Previous Message | Sylvain MARECHAL | 2015-09-17 07:17:16 | Re: BDR truncate and replication sets |