pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRegarding "Point-in-time Recovery" feature
3+ messages / 3 participants
[nested] [flat]
* Regarding "Point-in-time Recovery" feature
@ 2015-02-23 11:38 Saurabh Gupta A <saurabh.a.gupta@ericsson.com>
2015-02-23 16:03 ` Re: Regarding "Point-in-time Recovery" feature Mathis, Jason <jmathis@enova.com>
0 siblings, 1 reply; 3+ messages in thread
From: Saurabh Gupta A @ 2015-02-23 11:38 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Regarding "Point-in-time Recovery" feature
2015-02-23 11:38 Regarding "Point-in-time Recovery" feature Saurabh Gupta A <saurabh.a.gupta@ericsson.com>
@ 2015-02-23 16:03 ` Mathis, Jason <jmathis@enova.com>
2015-02-23 16:11 ` Re: Regarding "Point-in-time Recovery" feature luis.sa@htip.com.br
0 siblings, 1 reply; 3+ messages in thread
From: Mathis, Jason @ 2015-02-23 16:03 UTC (permalink / raw)
To: Saurabh Gupta A <saurabh.a.gupta@ericsson.com>; +Cc: 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
>
>
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Regarding "Point-in-time Recovery" feature
2015-02-23 11:38 Regarding "Point-in-time Recovery" feature Saurabh Gupta A <saurabh.a.gupta@ericsson.com>
2015-02-23 16:03 ` Re: Regarding "Point-in-time Recovery" feature Mathis, Jason <jmathis@enova.com>
@ 2015-02-23 16:11 ` luis.sa@htip.com.br
0 siblings, 0 replies; 3+ messages in thread
From: luis.sa@htip.com.br @ 2015-02-23 16:11 UTC (permalink / raw)
To: pgsql-performance
And there is an app to this: Barman --> http://www.pgbarman.org/
On Mon, 23 Feb 2015 10:03:35 -0600, Mathis, Jason wrote:
> Full explanation starts
>
> here: http://www.postgresql.org/docs/9.3/static/continuous-archiving.html
> [1].
>
> 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 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
>>
>>
>>
>>
>
>
>
> Links:
> ------
> [1]
> http://www.postgresql.org/docs/9.3/static/continuous-archiving.html
> [2] mailto:saurabh.a.gupta@ericsson.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-02-23 16:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-02-23 11:38 Regarding "Point-in-time Recovery" feature Saurabh Gupta A <saurabh.a.gupta@ericsson.com>
2015-02-23 16:03 ` Mathis, Jason <jmathis@enova.com>
2015-02-23 16:11 ` luis.sa@htip.com.br
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox