On 7 June 2012 14:59, Kevin Grittner <[email protected]> wrote: > Tom Lane <[email protected]> wrote: > >> there is no guarantee that we'll manage to reach a database state >> that is consistent with data already flushed out to disk during >> the last checkpoint. > > Robert Haas <[email protected]> wrote: > >> I know of real customers who would have suffered real data loss >> had this code been present in the server version they were using. >> Checkpoints are the *only* mechanism by which SLRU pages get >> flushed to disk on a mostly-idle system. That means if something >> happens to your pg_xlog directory, and you haven't had a >> checkpoint, you're screwed.
If that is the concern, then its a one line fix to add the missing clog flush. The other suggestions I've skim read seem fairly invasive at this stage of the release. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
