Re: BUG #13645: pg_basebackup backup hash index & unlogged table

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: BUG #13645: pg_basebackup backup hash index & unlogged table
Дата
Msg-id 20151005013741.GA6797@momjian.us
обсуждение исходный текст
Ответ на BUG #13645: pg_basebackup backup hash index & unlogged table  (digoal@126.com)
Ответы Re: BUG #13645: pg_basebackup backup hash index & unlogged table
Список 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 по дате отправления:

Предыдущее
От: James Coleman
Дата:
Сообщение: Re: BUG #13659: Constraint names truncated without error
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #13645: pg_basebackup backup hash index & unlogged table