Re: Backing up a replication set every 30 mins

From: Khusro Jaleel <mailing-lists(at)kerneljack(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backing up a replication set every 30 mins
Date: 2012-02-15 17:09:03
Message-ID: 4F3BE6AF.5070102@kerneljack.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 02/15/2012 04:21 PM, Kevin Grittner wrote:
> Khusro Jaleel<mailing-lists(at)kerneljack(dot)com> wrote:
>
>> I thought setting archive_timeout = 30 would only create 1
>> archive file every 30 minutes, but I was wrong.
>
> The default unit of measure is seconds, so the above would create at
> least two WAL files per minute. Try setting to '30min'.
>
> -Kevin
>

For crying out loud! I did specify "30min" on other machines but put in
"30" on this one, I guess it was a typo! I hope it was this simple and
it works now! :-)

Thanks everyone for your help.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Reinhard Asmus 2012-02-16 13:21:12 Connections to the Database
Previous Message Kevin Grittner 2012-02-15 16:21:58 Re: Backing up a replication set every 30 mins