On 2/19/18 3:41 PM, Don Seiler wrote:
> On Mon, Feb 19, 2018 at 10:17 AM, David Steele <david@pgmasters.net
> <mailto:david@pgmasters.net>> wrote:
>
> If pg_log is symlinked to PGDATA it will be copied. pg_xlog is not
> copied in any backup.
>
>
> So an external pg_log directory symlinked into $PGDATA will have its log
> contents copied?
Yes.
> I'm curious, why even copy the pg_log logs? They aren't needed for
> database restore or recovery.
The general philosophy is to copy everything except what we know for
sure can be excluded. In practice, this means sticking to what
pg_basebackup excludes because that list is vetted by the community.
Also, relocating the log directory is easy using the log_directory
setting, so that's what I recommend if it's an issue. Some users do
want to backup their logs.
--
-David
david@pgmasters.net