Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group