Re: Proposal: pg_rewind to skip config files

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Chris Travers <chris(dot)travers(at)adjust(dot)com>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal: pg_rewind to skip config files
Date: 2017-09-04 13:38:14
Message-ID: 20170904133814.qxshuosfgiovpljp@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Chris Travers wrote:
> On Mon, Sep 4, 2017 at 12:23 PM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
> wrote:
> > On Mon, Sep 4, 2017 at 7:21 PM, Michael Paquier
> > <michael(dot)paquier(at)gmail(dot)com> wrote:
> > > A simple idea would be to pass as a parameter a regex on which we
> > > check files to skip when scanning the directory of the target remotely
> > > or locally. This needs to be used with care though, it would be easy
> > > to corrupt an instance.
> >
> > I actually shortcut that with a strategy similar to base backups: logs
> > are on another partition, log_directory uses an absolute path, and
> > PGDATA has no reference to the log path.
> Yeah, it is quite possible to move all these out of the data directory, but
> bad things can happen when you accidentally copy configuration or logs over
> those on the target and expecting that all environments will be properly
> set up to avoid these problems is not always a sane assumption.

I agree that operationally it's better if these files weren't in PGDATA
to start with, but from a customer support perspective, things are
frequently not already setup like that, so failing to support that
scenario is a loser.

I wonder how portable fnmatch() is in practice (which we don't currently
use anywhere). A shell glob seems a more natural interface to me for
this than a regular expression.

Álvaro Herrera
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message i.kartyshov 2017-09-04 13:41:23 Re: make async slave to wait for lsn to be replayed
Previous Message Alvaro Herrera 2017-09-04 13:27:11 Re: pg_basebackup throttling doesn't throttle as promised