pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: edwin.polkerman@splendiddata.com
Subject: BUG #16783: pg_rewind: option -c does not work when configuration files are outside data directory
Date: Mon, 21 Dec 2020 15:14:14 +0000
Message-ID: <16783-6adba0a6c08728e8@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16783
Logged by:          Edwin Polkerman
Email address:      edwin.polkerman@splendiddata.com
PostgreSQL version: 13.1
Operating system:   Centos7/8, RHEL7/8, SUSE12/15
Description:        

To my opinion this report is more an improvement then a real bug.

We use PostgreSQL in such way that the configuration files are outside the
data directory. So for target location following applies:
 - data location          : /var/postgres/13/data
 - config files location: /etc/postgres/13/data

On the target location 'restore_command' is filled in postgresql.conf.
Trying pg_rewind with following command:
pg_rewind --target-pgdata=/var/postgres/13/data -P -R -c
--source-server='host=<ip-address> port=5432 user=<user> password=<passwd>
dbname=postgres'

Following Fatal message is shown:
pg_rewind: fatal: restore_command is not set in the target cluster

pg_rewind looks at the postgresql.conf in /var/postgres/13/data in stead of
the location where the configuration files reside (/etc/postgres/13/data).
It would be nice to add an option to tell pg_rewind that configuration files
are on a different location.



view thread (2+ messages)  latest in thread

Message-ID: <16783-6adba0a6c08728e8@postgresql.org>
Permalink:  ../16783-6adba0a6c08728e8@postgresql.org/
Also on:    postgresql.org/message-id/16783-6adba0a6c08728e8@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, edwin.polkerman@splendiddata.com
  Subject: Re: BUG #16783: pg_rewind: option -c does not work when configuration files are outside data directory
  In-Reply-To: <16783-6adba0a6c08728e8@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox