Re: Regarding "Point-in-time Recovery" feature

Поиск
Список
Период
Сортировка
От Mathis, Jason
Тема Re: Regarding "Point-in-time Recovery" feature
Дата
Msg-id CABAbqyeSB-CpmV4eLpGjvVSLY_witTnXONN4ysJev-5n7AgddA@mail.gmail.com
обсуждение исходный текст
Ответ на Regarding "Point-in-time Recovery" feature  (Saurabh Gupta A <saurabh.a.gupta@ericsson.com>)
Ответы Re: Regarding "Point-in-time Recovery" feature
Список pgsql-performance
Full explanation starts here: http://www.postgresql.org/docs/9.3/static/continuous-archiving.html.

While there are some considerations to take in it does not relate to performance. Generally most production systems run with archiving on. Take a minute to read through the documentation and let us know if you have any questions. Most questions about "backup and recovery" should be asked in the admin mailing list.

Good Luck,
jason

On Mon, Feb 23, 2015 at 5:38 AM, Saurabh Gupta A <saurabh.a.gupta@ericsson.com> wrote:

Hello,

Has anybody used online backup feature of postgreSQL? In fact precise postgreSQL term is called: "Point-in-time Recovery" (PITR)
This means enabling following additional options in config:
---
archive_command = on
archive_command = 'cp %p /usr/local/pgsql/pgDataPITR/wals/%f' # This is only example path
---

 

If yes then may I know how it is used and how it impacts database performance?

 

 

Regards:

Saurabh

 

 


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

Предыдущее
От: Saurabh Gupta A
Дата:
Сообщение: Regarding "Point-in-time Recovery" feature
Следующее
От: luis.sa@htip.com.br
Дата:
Сообщение: Re: Regarding "Point-in-time Recovery" feature