| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
| Subject: | Re: Replication/backup defaults |
| Date: | 2017-01-02 13:55:06 |
| Message-ID: | CANP8+jJkDsKgDmc0f8jhggEOi4nPPMp6-E=-D+965BWcgE-RfA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2 January 2017 at 09:39, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> The conclusion has been that our defaults should really allow people to take
> backups of their systems, and they currently don't.
>
> Making things run faster is tuning, and people should expect to do that if
> they need things to run faster. But being able to make a backup is pretty
> fundamental.
In the hope of making things better in 10.0, I remove my objection. If
people want to use wal_level = minimal they can restart their server
and they can find that out in the release notes.
Should we set wal_level = replica or wal_level = logical as the
default for 10.0?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2017-01-02 14:24:45 | Re: Replication slot xmin is not reset if HS feedback is turned off while standby is shut down |
| Previous Message | Petr Jelinek | 2017-01-02 13:32:33 | Re: Logical Replication WIP |