Re: pg_basebackup and pg_stat_tmp directory

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: pg_basebackup and pg_stat_tmp directory
Дата
Msg-id CABUevEyZ5L9Z=g-pzX3+dTBUKdROfRSDBGNaZu+hw6=_t2mCHg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_basebackup and pg_stat_tmp directory  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: pg_basebackup and pg_stat_tmp directory  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
On Tue, Jan 28, 2014 at 6:11 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
On Tue, Jan 28, 2014 at 9:26 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> Hi,
>
> The files in pg_stat_tmp directory don't need to be backed up because they are
> basically reset at the archive recovery. So I think it's worth
> changing pg_basebackup
> so that it skips any files in pg_stat_tmp directory. Thought?

I think this is good idea, but can't it also avoid
PGSTAT_STAT_PERMANENT_TMPFILE along with temp files in
pg_stat_tmp


All stats files should be excluded. IIRC the PGSTAT_STAT_PERMANENT_TMPFILE refers to just the global one. You want to exclude based on PGSTAT_STAT_PERMANENT_DIRECTORY (and of course based on the guc stats_temp_directory if it's in PGDATA.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Storing pg_stat_statements query texts externally, pg_stat_statements in core
Следующее
От: Rajeev rastogi
Дата:
Сообщение: Observed Compilation warning in WIN32 build