Re: Proposal: pg_rewind to skip config files

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Chris Travers <chris(dot)travers(at)adjust(dot)com>
Cc: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal: pg_rewind to skip config files
Date: 2017-09-04 10:21:34
Message-ID: CAB7nPqQgE=JWEAAWC90wMDkwyuHt_g6UqGk4=tvoudtVCKC2Ng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Sep 4, 2017 at 5:53 PM, Chris Travers <chris(dot)travers(at)adjust(dot)com> wrote:
> In some experiments with pg_rewind and rep mgr I noticed that local testing
> is complicated by the fact that pg_rewind appears to copy configuration
> files from the source to target directory.
>
> I would propose to make a modest patch to exclude postgresql.conf,
> pg_hba.conf, and pg_ident.conf from the file tree traversal.
>
> Any feedback before I create.a proof of concept?

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.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2017-09-04 10:23:03 Re: Proposal: pg_rewind to skip config files
Previous Message Alvaro Herrera 2017-09-04 10:18:27 Re: dropping partitioned tables without CASCADE