Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott Marlowe
Subject Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Date
Msg-id AANLkTikoDoOyq+pNW9knhyKzDmNN+_E-8-JEeD+ChSvv@mail.gmail.com
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>)
Responses Re: Survey on backing up unlogged tables: help us with PostgreSQL development!  (Josh Berkus <josh@agliodbs.com>)
List pgsql-general
Tree view 
On Tue, Nov 16, 2010 at 5:23 PM, Scott Ribe <scott_ribe@elevated-dev.com> 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.

I'd vote for backing up the schema of an unlogged table so it's there
on a restore.

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Next
From: Scott Mead
Date:
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!