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

2015-03-02 Thread Ryan King
I have archiving enabled for PITR but it has been causing problems. So I changed the archive_command to ‘cd .’ to disable for now. However, I’m currently looking for a script/process that will rotate the logs every week or so, and also ensure archived wal files don’t pile up. I > On Feb 27, 2015

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

2015-02-27 Thread Jim Nasby
On 2/23/15 5:39 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/lo

[GENERAL] 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