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

From: Ivan Voras <ivoras(at)freebsd(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Date: 2010-11-17 16:22:51
Message-ID: ic0vgm$mau$2@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Aram Fingal 2010-11-17 16:32:32 Alter table to "on update cascade"
Previous Message Steve Crawford 2010-11-17 16:16:48 Re: Survey on backing up unlogged tables: help us with PostgreSQL development!