Re: BUG #13645: pg_basebackup backup hash index & unlogged table - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #13645: pg_basebackup backup hash index & unlogged table
Date
Msg-id 20151005013741.GA6797@momjian.us
Whole thread Raw
In response to BUG #13645: pg_basebackup backup hash index & unlogged table  (digoal@126.com)
Responses Re: BUG #13645: pg_basebackup backup hash index & unlogged table  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
On Mon, Sep 28, 2015 at 06:15:24AM +0000, digoal@126.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      13645
> Logged by:          digoal
> Email address:      digoal@126.com
> PostgreSQL version: 9.4.4
> Operating system:   CentOS 6.x x64
> Description:
>
> HI,
>    Hash index and unlogged table don't generate XLOG record, when we use
> pg_basebackup's backup datafile & xlog archive recovery database, unlogged
> table datafile will purged, and hash index also has unconsistent data page.
>   Why pg_basebackup not filter the hash index datafile & unlogged table
> datafile, these file waste net band and backup file's capcity.

We will issue a warning in 9.5 when hash indexes are created.  I am not
sure why we don't filter out hash indexed and unlogged tables.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription                             +

pgsql-bugs by date:

Previous
From: James Coleman
Date:
Subject: Re: BUG #13659: Constraint names truncated without error
Next
From: Michael Paquier
Date:
Subject: Re: BUG #13645: pg_basebackup backup hash index & unlogged table