Re: Survey on backing up unlogged tables: help us with PostgreSQL development!

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Andy Colson <andy(at)squeakycode(dot)net>, PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Date: 2010-11-20 13:02:36
Message-ID: 4CE7C6EC.7060806@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Josh Berkus wrote:
>> With the current patches, the data survives a restart just fine.
>
> Per -hackers, that's not guarenteed.

"Not guaranteed" is fine. What people are asking for is "often survives".

AFAIK we don't truncate the log file created by the log_filename GUC
on every unclean crash and every clean shutdown.

Should we? :-)

Why not?

For people who intend to use these tables to log application data,
they'd have the exact same reasons for not wanting them truncated
when they don't need to be.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Elliot Chance 2010-11-20 13:05:11 Fwd: [pgsql-www] Forums at postgresql.com.au
Previous Message Elliot Chance 2010-11-20 13:02:31 Fwd: [pgsql-www] Forums at postgresql.com.au