| Lists: | pgsql-admin |
|---|
| From: | Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | archive_log command... |
| Date: | 2006-06-21 09:47:11 |
| Message-ID: | 1150883232.5508.4.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Can I force archiving of the WAL files using CHECKPOINT statement? My
checkpoing_segments is set to 32, but still archive_command is beeing
called up only every 45 minutes or so. Is there a way to speed this up a
bit? (I'd love to have it around 10 minutes, so I can have almost-live
backed-up server).
Mario
--
Mario Splivalo
Mob-Art
mario(dot)splivalo(at)mobart(dot)hr
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | mario(dot)splivalo(at)mobart(dot)hr |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: archive_log command... |
| Date: | 2006-06-22 01:30:03 |
| Message-ID: | 200606220130.k5M1U3G09804@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Mario Splivalo wrote:
> Can I force archiving of the WAL files using CHECKPOINT statement? My
> checkpoing_segments is set to 32, but still archive_command is beeing
> called up only every 45 minutes or so. Is there a way to speed this up a
> bit? (I'd love to have it around 10 minutes, so I can have almost-live
> backed-up server).
No, but it is on the TODO list.
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From: | Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: archive_log command... |
| Date: | 2006-06-22 10:41:39 |
| Message-ID: | 1150972899.10531.0.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
On Wed, 2006-06-21 at 21:30 -0400, Bruce Momjian wrote:
> Mario Splivalo wrote:
> > Can I force archiving of the WAL files using CHECKPOINT statement? My
> > checkpoing_segments is set to 32, but still archive_command is beeing
> > called up only every 45 minutes or so. Is there a way to speed this up a
> > bit? (I'd love to have it around 10 minutes, so I can have almost-live
> > backed-up server).
>
> No, but it is on the TODO list.
>
So, the only thing I could to is to reduce checkpoint_segments?
Mario
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | mario(dot)splivalo(at)mobart(dot)hr |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: archive_log command... |
| Date: | 2006-06-23 05:42:19 |
| Message-ID: | 200606230542.k5N5gJG12667@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Mario Splivalo wrote:
> On Wed, 2006-06-21 at 21:30 -0400, Bruce Momjian wrote:
> > Mario Splivalo wrote:
> > > Can I force archiving of the WAL files using CHECKPOINT statement? My
> > > checkpoing_segments is set to 32, but still archive_command is beeing
> > > called up only every 45 minutes or so. Is there a way to speed this up a
> > > bit? (I'd love to have it around 10 minutes, so I can have almost-live
> > > backed-up server).
> >
> > No, but it is on the TODO list.
> >
>
> So, the only thing I could to is to reduce checkpoint_segments?
No, that doesn't help because a partially-filled WAL file with little
database activity could be stay unarchived for a long time.
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From: | Jim Nasby <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | mario(dot)splivalo(at)mobart(dot)hr, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: archive_log command... |
| Date: | 2006-06-28 00:17:46 |
| Message-ID: | DF27B15B-97EF-4E8D-807A-FDFE9591507B@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
On Jun 23, 2006, at 12:42 AM, Bruce Momjian wrote:
> Mario Splivalo wrote:
>> On Wed, 2006-06-21 at 21:30 -0400, Bruce Momjian wrote:
>>> Mario Splivalo wrote:
>>>> Can I force archiving of the WAL files using CHECKPOINT
>>>> statement? My
>>>> checkpoing_segments is set to 32, but still archive_command is
>>>> beeing
>>>> called up only every 45 minutes or so. Is there a way to speed
>>>> this up a
>>>> bit? (I'd love to have it around 10 minutes, so I can have
>>>> almost-live
>>>> backed-up server).
>>>
>>> No, but it is on the TODO list.
>>>
>>
>> So, the only thing I could to is to reduce checkpoint_segments?
>
> No, that doesn't help because a partially-filled WAL file with little
> database activity could be stay unarchived for a long time.
You can however copy the active WAL file at any time, and as many
times as you want. And there's recently been a function added that
will tell you what that exact file is (I think it's only in HEAD, but
I could be wrong).
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461