mirror of
https://github.com/EnterpriseDB/repmgr.git
synced 2026-03-28 17:36:30 +00:00
Compare commits
1 Commits
dev/repmgr
...
dev/HL-38/
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
99bbf207b5 |
@@ -68,6 +68,7 @@ news are always welcome.
|
|||||||
|
|
||||||
Thanks from the repmgr core team.
|
Thanks from the repmgr core team.
|
||||||
|
|
||||||
|
* Ian Barwick
|
||||||
* Israel Barth
|
* Israel Barth
|
||||||
* Mario González
|
* Mario González
|
||||||
* Martín Marqués
|
* Martín Marqués
|
||||||
@@ -75,7 +76,6 @@ Thanks from the repmgr core team.
|
|||||||
|
|
||||||
Past contributors:
|
Past contributors:
|
||||||
|
|
||||||
* Ian Barwick
|
|
||||||
* Jaime Casanova
|
* Jaime Casanova
|
||||||
* Abhijit Menon-Sen
|
* Abhijit Menon-Sen
|
||||||
* Simon Riggs
|
* Simon Riggs
|
||||||
|
|||||||
@@ -192,9 +192,6 @@
|
|||||||
<listitem>
|
<listitem>
|
||||||
<simpara><link linkend="repmgr-node-service">repmgr node service</link> (to execute <command>CHECKPOINT</command> via the <option>--checkpoint</option>; note this is also called by <link linkend="repmgr-standby-switchover">repmgr standby switchover</link>)</simpara>
|
<simpara><link linkend="repmgr-node-service">repmgr node service</link> (to execute <command>CHECKPOINT</command> via the <option>--checkpoint</option>; note this is also called by <link linkend="repmgr-standby-switchover">repmgr standby switchover</link>)</simpara>
|
||||||
</listitem>
|
</listitem>
|
||||||
<listitem>
|
|
||||||
<simpara><link linkend="repmgr-node-rejoin">repmgr node rejoin</link> (to execute <command>repmgr node rejoin --force-rewind</command>)</simpara>
|
|
||||||
</listitem>
|
|
||||||
</itemizedlist>
|
</itemizedlist>
|
||||||
</para>
|
</para>
|
||||||
</sect3>
|
</sect3>
|
||||||
|
|||||||
@@ -14,7 +14,7 @@
|
|||||||
</para>
|
</para>
|
||||||
|
|
||||||
<para>
|
<para>
|
||||||
&repmgr; &repmgrversion; is compatible with all supported PostgreSQL versions from 13.x. See
|
&repmgr; &repmgrversion; is compatible with all PostgreSQL versions from 9.4. See
|
||||||
section <link linkend="install-compatibility-matrix">&repmgr; compatibility matrix</link>
|
section <link linkend="install-compatibility-matrix">&repmgr; compatibility matrix</link>
|
||||||
for an overview of version compatibility.
|
for an overview of version compatibility.
|
||||||
</para>
|
</para>
|
||||||
@@ -45,7 +45,7 @@
|
|||||||
of incompatibilities.
|
of incompatibilities.
|
||||||
</simpara>
|
</simpara>
|
||||||
<simpara>
|
<simpara>
|
||||||
If different "major" &repmgr; versions (e.g. 5.2.x and &repmgrversion;)
|
If different "major" &repmgr; versions (e.g. 4.1.x and &repmgrversion;.x)
|
||||||
are installed on different nodes, in the best case &repmgr; (in particular &repmgrd;)
|
are installed on different nodes, in the best case &repmgr; (in particular &repmgrd;)
|
||||||
will not run. In the worst case, you will end up with a broken cluster.
|
will not run. In the worst case, you will end up with a broken cluster.
|
||||||
</simpara>
|
</simpara>
|
||||||
@@ -89,6 +89,7 @@
|
|||||||
which PostgreSQL version.
|
which PostgreSQL version.
|
||||||
</para>
|
</para>
|
||||||
|
|
||||||
|
|
||||||
<table id="repmgr-compatibility-matrix">
|
<table id="repmgr-compatibility-matrix">
|
||||||
<title>&repmgr; compatibility matrix</title>
|
<title>&repmgr; compatibility matrix</title>
|
||||||
|
|
||||||
@@ -116,16 +117,16 @@
|
|||||||
<tbody>
|
<tbody>
|
||||||
<row>
|
<row>
|
||||||
<entry>
|
<entry>
|
||||||
&repmgr; 5.5
|
&repmgr; 5.4
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
Yes
|
(dev)
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
<link linkend="release-5.5.0">&repmgrversion;</link> (&releasedate;)
|
<link linkend="release-current">&repmgrversion;</link> (&releasedate;)
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
13, 14, 15, 16, 17
|
9.4, 9.5, 9.6, 10, 11, 12, 13, 15
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
|
|
||||||
@@ -134,31 +135,13 @@
|
|||||||
|
|
||||||
<row>
|
<row>
|
||||||
<entry>
|
<entry>
|
||||||
&repmgr; 5.4.1
|
&repmgr; 5.3
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
Yes
|
YES
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
<link linkend="release-5.4.1">5.4.1</link> (2023-04-04)
|
<link linkend="release-current">&repmgrversion;</link> (&releasedate;)
|
||||||
</entry>
|
|
||||||
<entry>
|
|
||||||
10, 11, 12, 13, 14, 15
|
|
||||||
</entry>
|
|
||||||
<entry>
|
|
||||||
|
|
||||||
</entry>
|
|
||||||
</row>
|
|
||||||
|
|
||||||
<row>
|
|
||||||
<entry>
|
|
||||||
&repmgr; 5.3.1
|
|
||||||
</entry>
|
|
||||||
<entry>
|
|
||||||
Yes
|
|
||||||
</entry>
|
|
||||||
<entry>
|
|
||||||
<link linkend="release-5.3.1">5.3.1</link> (2022-02-15)
|
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
9.4, 9.5, 9.6, 10, 11, 12, 13, 14, 15
|
9.4, 9.5, 9.6, 10, 11, 12, 13, 14, 15
|
||||||
@@ -173,7 +156,7 @@
|
|||||||
&repmgr; 5.2
|
&repmgr; 5.2
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
No
|
NO
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
<link linkend="release-5.2.1">5.2.1</link> (2020-12-07)
|
<link linkend="release-5.2.1">5.2.1</link> (2020-12-07)
|
||||||
@@ -191,7 +174,7 @@
|
|||||||
&repmgr; 5.1
|
&repmgr; 5.1
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
No
|
NO
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
<link linkend="release-5.1.0">5.1.0</link> (2020-04-13)
|
<link linkend="release-5.1.0">5.1.0</link> (2020-04-13)
|
||||||
@@ -209,7 +192,7 @@
|
|||||||
&repmgr; 5.0
|
&repmgr; 5.0
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
No
|
NO
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
<link linkend="release-5.0">5.0</link> (2019-10-15)
|
<link linkend="release-5.0">5.0</link> (2019-10-15)
|
||||||
@@ -228,7 +211,7 @@
|
|||||||
&repmgr; 4.x
|
&repmgr; 4.x
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
No
|
NO
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
<link linkend="release-4.4">4.4</link> (2019-06-27)
|
<link linkend="release-4.4">4.4</link> (2019-06-27)
|
||||||
@@ -246,7 +229,7 @@
|
|||||||
&repmgr; 3.x
|
&repmgr; 3.x
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
No
|
NO
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
<ulink url="https://repmgr.org/release-notes-3.3.2.html">3.3.2</ulink> (2017-05-30)
|
<ulink url="https://repmgr.org/release-notes-3.3.2.html">3.3.2</ulink> (2017-05-30)
|
||||||
@@ -264,7 +247,7 @@
|
|||||||
&repmgr; 2.x
|
&repmgr; 2.x
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
No
|
NO
|
||||||
</entry>
|
</entry>
|
||||||
<entry>
|
<entry>
|
||||||
<ulink url="https://repmgr.org/release-notes-2.0.3.html">2.0.3</ulink> (2015-04-16)
|
<ulink url="https://repmgr.org/release-notes-2.0.3.html">2.0.3</ulink> (2015-04-16)
|
||||||
@@ -283,12 +266,12 @@
|
|||||||
|
|
||||||
<important>
|
<important>
|
||||||
<para>
|
<para>
|
||||||
The &repmgr; series older than 5.x are no longer maintained or supported.
|
The &repmgr; 2.x and 3.x series are no longer maintained or supported.
|
||||||
We strongly recommend upgrading to the latest &repmgr; version.
|
We strongly recommend upgrading to the latest &repmgr; version.
|
||||||
</para>
|
</para>
|
||||||
<para>
|
<para>
|
||||||
Following the release of &repmgr; 5.0, there will be no further releases of
|
Following the release of &repmgr; 5.0, there will be no further releases of
|
||||||
the &repmgr; 4.x series or older. Note that &repmgr; 5.x is an incremental development
|
the &repmgr; 4.x series. Note that &repmgr; 5.x is an incremental development
|
||||||
of the 4.x series and &repmgr; 4.x users should upgrade to this as soon as possible.
|
of the 4.x series and &repmgr; 4.x users should upgrade to this as soon as possible.
|
||||||
</para>
|
</para>
|
||||||
</important>
|
</important>
|
||||||
|
|||||||
@@ -1,9 +1,9 @@
|
|||||||
<!-- doc/legal.xml -->
|
<!-- doc/legal.xml -->
|
||||||
|
|
||||||
<date>2025</date>
|
<date>2022</date>
|
||||||
|
|
||||||
<copyright>
|
<copyright>
|
||||||
<year>2010-2025</year>
|
<year>2010-2022</year>
|
||||||
<holder>EDB</holder>
|
<holder>EDB</holder>
|
||||||
</copyright>
|
</copyright>
|
||||||
|
|
||||||
@@ -11,7 +11,7 @@
|
|||||||
<title>Legal Notice</title>
|
<title>Legal Notice</title>
|
||||||
|
|
||||||
<para>
|
<para>
|
||||||
<productname>repmgr</productname> is Copyright © 2010-2025
|
<productname>repmgr</productname> is Copyright © 2010-2022
|
||||||
by EDB All rights reserved.
|
by EDB All rights reserved.
|
||||||
</para>
|
</para>
|
||||||
|
|
||||||
|
|||||||
@@ -113,29 +113,6 @@
|
|||||||
</varlistentry>
|
</varlistentry>
|
||||||
|
|
||||||
|
|
||||||
<varlistentry>
|
|
||||||
<term><option>-S/--superuser</option></term>
|
|
||||||
<listitem>
|
|
||||||
<para>
|
|
||||||
Specify a superuser to be used by <application>pg_rewind</application>
|
|
||||||
for its source server connection.
|
|
||||||
</para>
|
|
||||||
<para>
|
|
||||||
<application>pg_rewind</application> requires a normal (non-replication)
|
|
||||||
connection with <literal>pg_read_server_files</literal> privilege or
|
|
||||||
superuser rights. If the &repmgr; user has the <literal>REPLICATION</literal>
|
|
||||||
attribute but lacks these privileges, use this option to specify
|
|
||||||
a suitably privileged user for the <application>pg_rewind</application>
|
|
||||||
connection. The superuser's password should be configured in
|
|
||||||
<filename>.pgpass</filename>.
|
|
||||||
</para>
|
|
||||||
<para>
|
|
||||||
This option is only effective in combination with
|
|
||||||
<option>--force-rewind</option>.
|
|
||||||
</para>
|
|
||||||
</listitem>
|
|
||||||
</varlistentry>
|
|
||||||
|
|
||||||
<varlistentry>
|
<varlistentry>
|
||||||
<term><option>-W/--no-wait</option></term>
|
<term><option>-W/--no-wait</option></term>
|
||||||
<listitem>
|
<listitem>
|
||||||
@@ -304,23 +281,6 @@
|
|||||||
a "magic bullet" which can resolve all problematic replication situations.
|
a "magic bullet" which can resolve all problematic replication situations.
|
||||||
</para>
|
</para>
|
||||||
|
|
||||||
<note>
|
|
||||||
<para>
|
|
||||||
<command>pg_rewind</command> requires a normal (non-replication) connection to
|
|
||||||
the source server. The user for this connection must have superuser rights or
|
|
||||||
the <literal>pg_read_server_files</literal> role.
|
|
||||||
</para>
|
|
||||||
<para>
|
|
||||||
If the &repmgr; user has the <literal>REPLICATION</literal> attribute but does
|
|
||||||
not have the privileges required by <command>pg_rewind</command>, use the
|
|
||||||
<option>-S/--superuser</option> option to specify a suitably privileged user
|
|
||||||
for the <command>pg_rewind</command> source connection. For example:
|
|
||||||
<programlisting>
|
|
||||||
repmgr node rejoin -f /etc/repmgr.conf -d 'host=node3 dbname=repmgr user=repmgr' \
|
|
||||||
--force-rewind -S postgres</programlisting>
|
|
||||||
</para>
|
|
||||||
</note>
|
|
||||||
|
|
||||||
<para>
|
<para>
|
||||||
A typical use-case for <command>pg_rewind</command> is when a scenario like the following
|
A typical use-case for <command>pg_rewind</command> is when a scenario like the following
|
||||||
is encountered:
|
is encountered:
|
||||||
|
|||||||
@@ -2838,29 +2838,9 @@ do_node_rejoin(void)
|
|||||||
appendShellString(&command,
|
appendShellString(&command,
|
||||||
config_file_options.data_directory);
|
config_file_options.data_directory);
|
||||||
|
|
||||||
if (runtime_options.superuser[0] != '\0')
|
appendPQExpBuffer(&command,
|
||||||
{
|
" --source-server='%s'",
|
||||||
t_conninfo_param_list rewind_conninfo = T_CONNINFO_PARAM_LIST_INITIALIZER;
|
primary_node_record.conninfo);
|
||||||
char *rewind_conninfo_str = NULL;
|
|
||||||
|
|
||||||
initialize_conninfo_params(&rewind_conninfo, false);
|
|
||||||
parse_conninfo_string(primary_node_record.conninfo, &rewind_conninfo, NULL, false);
|
|
||||||
param_set(&rewind_conninfo, "user", runtime_options.superuser);
|
|
||||||
rewind_conninfo_str = param_list_to_string(&rewind_conninfo);
|
|
||||||
|
|
||||||
appendPQExpBuffer(&command,
|
|
||||||
" --source-server='%s'",
|
|
||||||
rewind_conninfo_str);
|
|
||||||
|
|
||||||
pfree(rewind_conninfo_str);
|
|
||||||
free_conninfo_params(&rewind_conninfo);
|
|
||||||
}
|
|
||||||
else
|
|
||||||
{
|
|
||||||
appendPQExpBuffer(&command,
|
|
||||||
" --source-server='%s'",
|
|
||||||
primary_node_record.conninfo);
|
|
||||||
}
|
|
||||||
|
|
||||||
if (runtime_options.dry_run == true)
|
if (runtime_options.dry_run == true)
|
||||||
{
|
{
|
||||||
@@ -3718,7 +3698,6 @@ do_node_help(void)
|
|||||||
printf(_(" --config-archive-dir directory to temporarily store retained configuration files\n" \
|
printf(_(" --config-archive-dir directory to temporarily store retained configuration files\n" \
|
||||||
" (default: /tmp)\n"));
|
" (default: /tmp)\n"));
|
||||||
printf(_(" -W, --no-wait don't wait for the node to rejoin cluster\n"));
|
printf(_(" -W, --no-wait don't wait for the node to rejoin cluster\n"));
|
||||||
printf(_(" -S, --superuser=USERNAME superuser to use for pg_rewind if repmgr user is not superuser\n"));
|
|
||||||
puts("");
|
puts("");
|
||||||
|
|
||||||
printf(_("NODE SERVICE\n"));
|
printf(_("NODE SERVICE\n"));
|
||||||
|
|||||||
@@ -5359,13 +5359,6 @@ do_standby_switchover(void)
|
|||||||
}
|
}
|
||||||
|
|
||||||
appendPQExpBufferChar(&node_rejoin_options, ' ');
|
appendPQExpBufferChar(&node_rejoin_options, ' ');
|
||||||
|
|
||||||
if (runtime_options.superuser[0] != '\0')
|
|
||||||
{
|
|
||||||
appendPQExpBuffer(&node_rejoin_options,
|
|
||||||
"--superuser=%s ",
|
|
||||||
runtime_options.superuser);
|
|
||||||
}
|
|
||||||
}
|
}
|
||||||
|
|
||||||
key_value_list_free(&remote_config_files);
|
key_value_list_free(&remote_config_files);
|
||||||
|
|||||||
@@ -1761,7 +1761,6 @@ check_cli_parameters(const int action)
|
|||||||
case STANDBY_SWITCHOVER:
|
case STANDBY_SWITCHOVER:
|
||||||
case NODE_CHECK:
|
case NODE_CHECK:
|
||||||
case NODE_SERVICE:
|
case NODE_SERVICE:
|
||||||
case NODE_REJOIN:
|
|
||||||
break;
|
break;
|
||||||
default:
|
default:
|
||||||
item_list_append_format(&cli_warnings,
|
item_list_append_format(&cli_warnings,
|
||||||
|
|||||||
Reference in New Issue
Block a user