Re: [GENERAL] [pgadmin-support] Best backup strategy for production systems - Mailing list pgsql-admin

From Michael Paquier
Subject Re: [GENERAL] [pgadmin-support] Best backup strategy for production systems
Date
Msg-id CAB7nPqQ8mN3coVgTZqX4yc1w2djTXi+L4=pcZrhXuZkJNT+uKg@mail.gmail.com
Whole thread Raw
In response to Re: [pgadmin-support] Best backup strategy for production systems  (Oliver <ofabelo@gmail.com>)
List pgsql-admin
Please avoid top-posting...

On Mon, Jun 30, 2014 at 7:24 PM, Oliver <ofabelo@gmail.com> wrote:
Ok, thanks.
I mean by original wal segments to files generated in pg_xlog, yes. I have to 0 the parameter wal_keep_segments. They are being generated with 16MB of size and they are being rotated. What parameter controls how many files can be generated? Or will it grow indefinitely?
checkpoint_segments. A maximum of (3 * checkpoint_segments + 1) WAL segments can generated. This can be more though as this is a soft limit, but once this limit is reached server will remove WAL segments instead of keeping them. Per the docs:
http://www.postgresql.org/docs/9.3/static/wal-configuration.html
--
Michael

pgsql-admin by date:

Previous
From: Oliver
Date:
Subject: Re: [GENERAL] [pgadmin-support] Best backup strategy for production systems
Next
From: Luis Marin
Date:
Subject: PostgreSql 9.3 High Availability Best Practices