Re: PITR compatible backup with exclusion - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: PITR compatible backup with exclusion
Date
Msg-id me17qj$q4h$1@ger.gmane.org
Whole thread Raw
In response to Re: PITR compatible backup with exclusion  (jaime soler <jaime.soler@gmail.com>)
List pgsql-admin
jaime soler wrote on 14.03.2015 12:30:
>> What if you change that big table to UNLOGGED?
>> As unlogged tables don't generate WAL they don't contribute to the PITR "restore time"
>> (and they won't be restored if you have to do a PITR!)
>
> However, they are not crash-safe: an unlogged table is automatically
> truncated after a crash or unclean shutdown.

That is correct, but Martin wrote in the initial question:

> The backup of the table itself is also reduntant,
>as the table data can be recreated by importing from the source files

So if the data lost, it apparently doesn't matter.




pgsql-admin by date:

Previous
From: jaime soler
Date:
Subject: Re: PITR compatible backup with exclusion
Next
From: jaime soler
Date:
Subject: Re: WAL log management w/ multiple slaves