Postgres Pro
Downloads
Home   >   mailing lists

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

From Ivan Voras
Subject Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Date
Msg-id ic0vgm$mau$2@dough.gmane.org
Whole thread Raw
In response to Re: Survey on backing up unlogged tables: help us with PostgreSQL development!  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-general
Tree view 
On 11/17/10 01:23, Scott Ribe wrote:
> On Nov 16, 2010, at 3:46 PM, Josh Berkus wrote:
>
>>   ...and will be truncated (emptied) on database restart.
>
> I think that's key. Anything that won't survive a database restart, I sure don't expect to survive backup&  restore.

FWIW, I agree with this reasoning. Iff the automatic truncate on clean
restart could be turned off, I'd also expect the data to be in the
backup - in that case only.

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Next
From: Fredric Fredricson
Date:
Subject: Re: The first dedicated PostgreSQL forum