Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
Why so long between archive calls?
- From: "Chris Hoover" <revoohc(at)gmail(dot)com>
- To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
- Subject: Why so long between archive calls?
- Date: Tue, 29 Aug 2006 11:35:30 -0400
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
- Follow-Ups:
- Re: Why so long between archive calls?
- From: Andy Shellam
- Re: Why so long between archive calls?
- Prev by Date: dbsize.so for PostgreSQL 8.1.4 on Red Hat Enterprise Linux 4.0
- Next by Date: Re: dbsize.so for PostgreSQL 8.1.4 on Red Hat Enterprise Linux 4.0
- Previous by thread: pgsql.v814 - BLCKSZ
- Next by thread: Re: Why so long between archive calls?
- Indexes: