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

From Tatsuo Ishii
Subject Re: pg_rewind and postgresql.conf
Date
Msg-id 20180504.220838.1864996865700526706.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: pg_rewind and postgresql.conf  (Isaac Morland <isaac.morland@gmail.com>)
List pgsql-hackers
> 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.

To make ALTER SYSTEM works, the server needs to start up in the first
place. But without changing the port number, it's impossible to start
the server in some cases. In my case, I create several PostgreSQL
database clusters on single server by assigning different port
numbers. If the port number is already used by other server (in
pg_rewind case the source server aparently uses the port), the rewound
server won't start up.

Best regards,
--
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: Ildar Musin
Date:
Subject: MAP syntax for arrays
Next
From: Tatsuo Ishii
Date:
Subject: Re: pg_rewind and postgresql.conf