I am working on getting my development system working with archive logging
so I can use the pitr features of Postgres. However, I am finding that the
actual archiving is not keeping up with the generation of the logs. I am
now over 500 wal archive files behind (8+ GB).
What controls how often the archive_command is called?
The actual running of my archive script is taking 1-2 seconds, so I'm not
sure why we are so far behind.
Thanks for any advise,
Chris
PG 8.1.3
RH AS 4