Re: unlogged tables

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Andres Freund" <andres@anarazel.de>, <pgsql-hackers@postgresql.org>
Cc: "Josh Berkus" <josh@agliodbs.com>
Date: 2010-11-16T22:36:12Z
Lists: pgsql-hackers
Andres Freund <andres@anarazel.de> wrote:
 
> One way your backup runs too long and too much data changes, the
> other way round you loose the data which you assumed safely
> backuped.
> 
> Isn't that a *really* easy decision?
 
Yeah.  Count me in the camp which wants the default behavior to be
that pg_dump backs up all permanent tables, even those which aren't
WAL-logged (and therefore aren't kept up in PITR backups, hot/warm
standbys, or streaming replication).
 
-Kevin