pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFrequency of archive_cleanup_command
4+ messages / 4 participants
[nested] [flat]
* Frequency of archive_cleanup_command
@ 2011-08-10 17:36 A J <s5aly@yahoo.com>
2011-08-10 17:44 ` Re: Frequency of archive_cleanup_command Raghavendra <raghavendra.rao@enterprisedb.com>
2011-08-10 17:58 ` Re: Frequency of archive_cleanup_command Jerry Sievers <gsievers19@comcast.net>
2011-08-10 18:01 ` Re: Frequency of archive_cleanup_command Simon Riggs <simon@2ndQuadrant.com>
0 siblings, 3 replies; 4+ messages in thread
From: A J @ 2011-08-10 17:36 UTC (permalink / raw)
To: pgsql-admin
Couple of questions:
1. At what frequency is the archive_cleanup_command executed from the recovery.conf file on the standby ?
2. If for some reason lets say a WAL file is missing from the archive directory but the files after that are present. When the standby tries to restore the missing WAL file, does it fail or it simply skips the missing WAL file and goes to the next one.
Thanks.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Frequency of archive_cleanup_command
2011-08-10 17:36 Frequency of archive_cleanup_command A J <s5aly@yahoo.com>
@ 2011-08-10 17:44 ` Raghavendra <raghavendra.rao@enterprisedb.com>
2 siblings, 0 replies; 4+ messages in thread
From: Raghavendra @ 2011-08-10 17:44 UTC (permalink / raw)
To: A J <s5aly@yahoo.com>; +Cc: pgsql-admin
>
> 2. If for some reason lets say a WAL file is missing from the archive
> directory but the files after that are present. When the standby tries to
> restore the missing WAL file, does it fail or it simply skips the missing
> WAL file and goes to the next one.
>
> I wont think it is possible if you are missing any one of the WALs in
restoration process.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Frequency of archive_cleanup_command
2011-08-10 17:36 Frequency of archive_cleanup_command A J <s5aly@yahoo.com>
@ 2011-08-10 17:58 ` Jerry Sievers <gsievers19@comcast.net>
2 siblings, 0 replies; 4+ messages in thread
From: Jerry Sievers @ 2011-08-10 17:58 UTC (permalink / raw)
To: A J <s5aly@yahoo.com>; +Cc: pgsql-admin
A J <s5aly@yahoo.com> writes:
> Couple of questions: 1. At what frequency is the
> archive_cleanup_command executed from the recovery.conf file on the
> standby ?
Typically once per WAL file being processed.
> 2. If for some reason lets say a WAL file is missing from the
> archive directory but the files after that are present. When the
> standby tries to restore the missing WAL file, does it fail or it
> simply skips the missing WAL file and goes to the next one.
Neither.
A standby will sit waiting forever for the next WAL segment that it
needs.
You can't just skip missing WALs :-)
HTH
> Thanks.
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 305.321.1144
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Frequency of archive_cleanup_command
2011-08-10 17:36 Frequency of archive_cleanup_command A J <s5aly@yahoo.com>
@ 2011-08-10 18:01 ` Simon Riggs <simon@2ndQuadrant.com>
2 siblings, 0 replies; 4+ messages in thread
From: Simon Riggs @ 2011-08-10 18:01 UTC (permalink / raw)
To: A J <s5aly@yahoo.com>; +Cc: pgsql-admin
On Wed, Aug 10, 2011 at 6:36 PM, A J <s5aly@yahoo.com> wrote:
> Couple of questions:
> 1. At what frequency is the archive_cleanup_command executed from the
> recovery.conf file on the standby ?
> 2. If for some reason lets say a WAL file is missing from the archive
> directory but the files after that are present. When the standby tries to
> restore the missing WAL file, does it fail or it simply skips the missing
> WAL file and goes to the next one.
It fails. The gap must be repaired manually, or you're out of luck.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2011-08-10 18:01 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-10 17:36 Frequency of archive_cleanup_command A J <s5aly@yahoo.com>
2011-08-10 17:44 ` Raghavendra <raghavendra.rao@enterprisedb.com>
2011-08-10 17:58 ` Jerry Sievers <gsievers19@comcast.net>
2011-08-10 18:01 ` Simon Riggs <simon@2ndQuadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox