agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Simon Riggs <simon@2ndQuadrant.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Greg Stark <gsstark@mit.edu>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Simplifying replication
Date: Tue, 26 Oct 2010 13:27:29 +0100
Message-ID: <1288096049.1587.253.camel@ebony> (raw)
In-Reply-To: <AANLkTik-L-68UpwgyBh5HtROzkEYQ297fiy7C-c6qRfX@mail.gmail.com>
References: <201010220022.o9M0M8Q29438@momjian.us>
<4CC0DEDE.7060707@agliodbs.com>
<AANLkTin0RfGOvk20vLYYfCDzdf5Sf94aQ5V-xOBB+Kqx@mail.gmail.com>
<AANLkTik-L-68UpwgyBh5HtROzkEYQ297fiy7C-c6qRfX@mail.gmail.com>
On Thu, 2010-10-21 at 20:57 -0400, Robert Haas wrote:
> Very true. But the lack of a -1 setting for wal_keep_segments means
> that if you would like to take a backup without archiving, you must
> set wal_keep_segments to a value greater than or equal to the rate at
> which you generate WAL segments multiplied by the time it takes you to
> run a backup. If that doesn't qualify as requiring arcane knowledge,
> I'm mystified as to what ever could.
People are missing the point here:
You have to put the WAL files *somewhere* while you do the base backup.
PostgreSQL can't itself work out where that is, nor can it work out
ahead of time how big it will need to be, since it is up to you how you
do your base backup. Setting a parameter to -1 doesn't make the problem
go away, it just pretends and hopes it doesn't exist, but screws you
badly if you do hit the wall.
My view is that is irresponsible, even if I share people's wish that the
problem did not exist.
--
Simon Riggs http://www.2ndQuadrant.com/books/
PostgreSQL Development, 24x7 Support, Training and Services
view thread (50+ messages) latest in thread
Message-ID: <1288096049.1587.253.camel@ebony>
Permalink: ../1288096049.1587.253.camel@ebony/
Also on: postgresql.org/message-id/1288096049.1587.253.camel@ebony
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: simon@2ndQuadrant.com, robertmhaas@gmail.com, gsstark@mit.edu, josh@agliodbs.com, bruce@momjian.us
Subject: Re: Simplifying replication
In-Reply-To: <1288096049.1587.253.camel@ebony>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox