Re: pg_rewind and postgresql.conf - Mailing list pgsql-hackers

From Isaac Morland
Subject Re: pg_rewind and postgresql.conf
Date
Msg-id CAMsGm5dokoD1jwQNCexBAjb99romSVEbKxhDkkLWZ2uN+zos+Q@mail.gmail.com
Whole thread Raw
In response to pg_rewind and postgresql.conf  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: pg_rewind and postgresql.conf  (Chris Travers <chris.travers@adjust.com>)
Re: pg_rewind and postgresql.conf  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
Would it work to use ALTER SYSTEM (postgresql.auto.conf)? Or is that copied by pg_rewind also?

Even if so, using the ALTER SYSTEM command after pg_rewind might be an easy way of correcting the port back to what you want without doing more complicated processing or re-writing the entire postgresql.conf.

On 4 May 2018 at 06:59, Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
Currently pg_rewind copies all files including postgresql.conf. It
would be nice if pg_rewind has an option to not copy
postgresql.conf. I sometimes create multiple PostgreSQL database
clusters with different port number which postmaster is listening on
for a testing purpose. So existing postgresql.conf on the target
cluster being overwritten by pg_rewind is annoying. I believe there
are some use cases where different port numbers are used among
PostgreSQL database clusters in the real world.

Comments?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


pgsql-hackers by date:

Previous
From: Chris Travers
Date:
Subject: Re: pg_rewind and postgresql.conf
Next
From: Chris Travers
Date:
Subject: Re: pg_rewind and postgresql.conf