Postgres Pro
Downloads
Home   >   mailing lists

Re: Backing up a replication set every 30 mins - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Backing up a replication set every 30 mins
Date
Msg-id 4F3B87460200002500045612@gw.wicourts.gov
Whole thread Raw
In response to Re: Backing up a replication set every 30 mins  (Khusro Jaleel <mailing-lists@kerneljack.com>)
Responses Re: Backing up a replication set every 30 mins  (Khusro Jaleel <mailing-lists@kerneljack.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Ian Lea
Date:
Subject: Re: Backing up a replication set every 30 mins
Next
From: Khusro Jaleel
Date:
Subject: Re: Backing up a replication set every 30 mins