Re: pg_basebackup is taking backup of extra files inside a tablespace directory

Поиск
Список
Период
Сортировка
От Hari Babu
Тема Re: pg_basebackup is taking backup of extra files inside a tablespace directory
Дата
Msg-id 008101cdcd42$41cd6d90$c56848b0$@kommi@huawei.com
обсуждение исходный текст
Ответ на Re: pg_basebackup is taking backup of extra files inside a tablespace directory  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers

> On Wed, Nov 28, 2012 at 12:43 PM, Michael Paquier < michael(dot)paquier(at)gmail(dot)com>wrote:
>> On Wed, Nov 28, 2012 at 3:55 PM, Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>wrote:
>> pg_basebackup is taking backup of extra files other than database related
>> files in side a TABLESPACE directory.

> And why do you have files not related to your PG server inside a folder
> dedicated to a PG server?

Incase of pg_upgrade old version to new version, new tablespace will be created in same tablespace path with different tablespace version number.

So while taking backup need to skip the other data directory files.

ls opt/tbs1
        PG_9.2_201204301
        PG_9.3_201210071

Regards,

Hari babu.

 

From: Michael Paquier [mailto:michael.paquier@gmail.com]
Sent: Wednesday, November 28, 2012 12:43 PM
To: Hari Babu
Cc: PostgreSQL-development
Subject: Re: [HACKERS] pg_basebackup is taking backup of extra files inside a tablespace directory

 

 

On Wed, Nov 28, 2012 at 3:55 PM, Hari Babu <haribabu.kommi@huawei.com> wrote:

pg_basebackup is taking backup of extra files other than database related files in side a TABLESPACE directory.

And why do you have files not related to your PG server inside a folder dedicated to a PG server?

--
Michael Paquier
http://michael.otacoo.com

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: pg_basebackup is taking backup of extra files inside a tablespace directory
Следующее
От: Pavan Deolasee
Дата:
Сообщение: Strange behaviour with incompatible psql/server