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
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
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