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

Re: Backing up a replication set every 30 mins

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Khusro Jaleel" <mailing-lists(at)kerneljack(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Backing up a replication set every 30 mins
Date: 2012-02-15 16:21:58
Message-ID: 4F3B87460200002500045612@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: Khusro JaleelDate: 2012-02-15 17:09:03
Subject: Re: Backing up a replication set every 30 mins
Previous:From: Ian LeaDate: 2012-02-15 16:19:26
Subject: Re: Backing up a replication set every 30 mins

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