Search Postgresql Archives

WAL archive deletion methodology

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

when a warm standby "slave" database is being maintained, what is the best way to keep the WAL archive files from cluttering up the disk? According to http://www.postgresql.org/docs/8.2/interactive/warm-standby.html it seems to me that one could either initiate periodic backups (stop PITR slave; pg_start_backup() & rsync & pg_stop_backuo(); start recovery) and delete all files before the "START WAL LOCATION" mentioned in the *.backup file, or just keep the PITR slave running and use pg_controldata to identify the files that are no longer needed (although I'm not sure how to translate a checkpoint location to a WAL archive filename).

What's a reliable way to do this?

Thanks,
 Marinos


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux