| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Oliver <ofabelo(at)gmail(dot)com> |
| Cc: | jayknowsunix(at)gmail(dot)com, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, Forums postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [ADMIN] [pgadmin-support] Best backup strategy for production systems |
| Date: | 2014-06-30 11:34:37 |
| Message-ID: | CAB7nPqQ8mN3coVgTZqX4yc1w2djTXi+L4=pcZrhXuZkJNT+uKg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-admin pgsql-general |
Please avoid top-posting...
On Mon, Jun 30, 2014 at 7:24 PM, Oliver <ofabelo(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Koch | 2014-07-01 08:32:47 | Extended capabilities for managing MATERIALIZED VIEWs |
| Previous Message | Oliver | 2014-06-30 10:29:57 | Re: [pgadmin-support] Best backup strategy for production systems |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luis Marin | 2014-07-02 16:03:21 | PostgreSql 9.3 High Availability Best Practices |
| Previous Message | Oliver | 2014-06-30 10:29:57 | Re: [pgadmin-support] Best backup strategy for production systems |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Olarte | 2014-06-30 12:05:15 | Re: Very high latency, low bandwidth replication |
| Previous Message | Szymon Guz | 2014-06-30 11:00:22 | Re: collecting employees who completed 5 and 10 years in the current month |