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 4CE7C6EC.7060806@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Survey on backing up unlogged tables: help us with PostgreSQL development!  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Survey on backing up unlogged tables: help us with PostgreSQL development!  (Josh Berkus <josh@agliodbs.com>)
List 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.




pgsql-general by date:

Previous
From: Radosław Smogura
Date:
Subject: Re: The first dedicated PostgreSQL forum
Next
From: Elliot Chance
Date:
Subject: Fwd: [pgsql-www] Forums at postgresql.com.au