Re: initdb when data/ folder has mount points

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: initdb when data/ folder has mount points
Дата
Msg-id 20180222061639.GB3370@paquier.xyz
обсуждение исходный текст
Ответ на Re: initdb when data/ folder has mount points  (David Steele <david@pgmasters.net>)
Ответы Re: initdb when data/ folder has mount points
Список pgsql-general
On Wed, Feb 21, 2018 at 07:56:38PM -0500, David Steele wrote:
> On 2/21/18 7:01 PM, Tom Lane wrote:
>> For pg_log, just put it somewhere else and set the appropriate
>> configuration option to say where to write the postmaster log files.
>> Or you could use a symlink, like the solution for pg_xlog, but
>> I don't see any advantage there.
>
> Symlinking pg_log is not ideal because the logs end up in the backup. It
> gets pretty weird when those logs get restored to a standby and somebody
> starts reading them.

log_directory in postgresql.conf san be set up with an absolute
directory value.  So there is no actual need for a symlink with pg_log.
This also reduces the amount of data transfered as part of base
backups without actually needing them.
--
Michael

Вложения

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

Предыдущее
От: Pawan Sharma
Дата:
Сообщение: Re: oracle to postgresql conversion tool
Следующее
От: Alexander Farber
Дата:
Сообщение: Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later