|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|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
Chris Travers wrote:
> On Mon, Sep 4, 2017 at 12:23 PM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
> > 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 https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
|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|