Re: Survey on backing up unlogged tables: help us with PostgreSQL development! - Mailing list pgsql-general

From Ron Mayer
Subject Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Date
Msg-id 4CE77020.3080309@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Survey on backing up unlogged tables: help us with PostgreSQL development!  (Glen Parker <glenebob@nwlink.com>)
List pgsql-general
Glen Parker wrote:
> As was already mentioned, application logs.  Unlogged tables would be
> perfect for that, provided they don't go *poof* every now and then for
> no good reason.  Nobody's going to be too heart broken if a handful of
> log records go missing, or get garbled, after a server crash or power
> outage.  Delete 'em all after every restart though, and that's a problem.

How often are you doing unintentional restarts?

I'd guess for many people it's "whenever I had so many backend crashes
that I get motivated to check if I'm running the latest minor release".

And if it's an intentional restart - surely you could archive your
application logs before doing the restart, no?

pgsql-general by date:

Previous
From: Grant Mckenzie
Date:
Subject: newbie question - delete before insert
Next
From: Thomas Kellerer
Date:
Subject: Re: newbie question - delete before insert