Re: initdb when data/ folder has mount points - Mailing list pgsql-general

From Michael Paquier
Subject Re: initdb when data/ folder has mount points
Date
Msg-id 20180222061639.GB3370@paquier.xyz
Whole thread Raw
In response to Re: initdb when data/ folder has mount points  (David Steele <david@pgmasters.net>)
Responses Re: initdb when data/ folder has mount points  (David Steele <david@pgmasters.net>)
List 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

Attachment

pgsql-general by date:

Previous
From: Pawan Sharma
Date:
Subject: Re: oracle to postgresql conversion tool
Next
From: Alexander Farber
Date:
Subject: Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later