Re: [PERFORM] Regarding "Point-in-time Recovery" feature

2015-02-23 Thread luis . sa
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

Re: [PERFORM] Regarding "Point-in-time Recovery" feature

2015-02-23 Thread Mathis, Jason
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 k

[PERFORM] Regarding "Point-in-time Recovery" feature

2015-02-23 Thread Saurabh Gupta A
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