pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Khusro Jaleel <mailing-lists@kerneljack.com>
To: pgsql-admin@postgresql.org
Subject: Re: Backing up a replication set every 30 mins
Date: Wed, 15 Feb 2012 17:09:03 +0000
Message-ID: <4F3BE6AF.5070102@kerneljack.com> (raw)
In-Reply-To: <4F3B87460200002500045612@gw.wicourts.gov>
References: <4F3BA826.9000708@kerneljack.com>
	<CANjgnBvJU-0C=eDkKf32YV2UrC+bVfsM8X=542T-Yn92p=vVEA@mail.gmail.com>
	<4F3BBBA6.1040707@kerneljack.com>
	<4F3B715102000025000455FB@gw.wicourts.gov>
	<4F3BCCA2.1030102@kerneljack.com>
	<4F3B7D5F0200002500045603@gw.wicourts.gov>
	<4F3BD7CC.10407@kerneljack.com>
	<4F3B87460200002500045612@gw.wicourts.gov>

On 02/15/2012 04:21 PM, Kevin Grittner wrote:
> Khusro Jaleel<mailing-lists@kerneljack.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.




view thread (10+ messages)

Message-ID: <4F3BE6AF.5070102@kerneljack.com>
Permalink:  ../4F3BE6AF.5070102@kerneljack.com/
Also on:    postgresql.org/message-id/4F3BE6AF.5070102@kerneljack.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: mailing-lists@kerneljack.com
  Subject: Re: Backing up a replication set every 30 mins
  In-Reply-To: <4F3BE6AF.5070102@kerneljack.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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