Online backup of PostgreSQL data.

Поиск
Список
Период
Сортировка
От Raman, Karthik IN BLR STS
Тема Online backup of PostgreSQL data.
Дата
Msg-id 8D15F77F211D7D4786182E1C8E679FAD349B19FE3D@INBLRK77M1MSX.in002.siemens.net
обсуждение исходный текст
Ответы Re: Online backup of PostgreSQL data.  (John R Pierce <pierce@hogranch.com>)
Список 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

 
 

В списке pgsql-general по дате отправления:

Предыдущее
От: Sylvain MARECHAL
Дата:
Сообщение: Re: BDR truncate and replication sets
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Online backup of PostgreSQL data.