Re: pgBackRest backup from standby

From: Martin Marques <martin(dot)marques(at)2ndquadrant(dot)com>
To: David Steele <david(at)pgmasters(dot)net>, Don Seiler <don(at)seiler(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pgBackRest backup from standby
Date: 2018-02-19 20:59:24
Message-ID: 371d175d-8fa9-580b-1b84-e7807aac69dc@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

El 19/02/18 a las 17:53, David Steele escribió:
> On 2/19/18 3:41 PM, Don Seiler wrote:
>
>> I'm curious, why even copy the pg_log logs? They aren't needed for
>> database restore or recovery.
>
> 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.

I was about to reply to Don about this, but David's reply was very clear.

If you don't want the logs inside pgdata (a very wise idea, specially if
you place them on a different partition), just change the configuration GUC.

Regards,

--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Aditya Nugraha 2018-02-19 21:09:47 Re: Error when compiling postgresql 9.6.7 with Visual Studio 15.5.6
Previous Message Don Seiler 2018-02-19 20:56:58 Re: pgBackRest backup from standby